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 에서도 변수를 사용할 수 있나요?
|