CREATE OR REPLACE RULE members_view_update AS ON UPDATE TO members_view DO INSTEAD (

    UPDATE members

        SET uid = new.uid, email = new.email, nick = new.nick, passwd = new.passwd, isadmin = new.isadmin

        WHERE uid = old.uid;

    UPDATE members_data

        SET uid = new.uid, name = new.name, personal_no = new.personal_no, tel = new.tel, cell = new.cell, addr = new.addr, addr_remain = new.addr_remain

        WHERE uid = old.uid;

    UPDATE members_permission

        SET uid = new.uid, permis_admin = new.permis_admin, permis_user = new.permis_user

        WHERE uid = old.uid;

);

이렇게 rule 을 만들었습니다.

update members_view set uid=1 where uid=2 하면

members 테이블만 적용됩니다.

뭐가 문제인지 모르겠지만 update 가 한번 일어나면서 old.uid 가 바뀌는듯 합니다.

rule 에서도 변수를 사용할 수 있나요?