Confirmed this problem on cvs-tip. Replacing the DO INSTEAD ( DELETE....) with DO INSTEAD (INSERT...) allows multiple insert statements which function fine using OLD.a_data and OLD.b_data.
So it must be something else. Could it be because once the DELETE FROM A has run the tuple no longer exists in the view? On Wed, 2002-11-20 at 10:49, Malcolm Hutty wrote: > According to the manual you can stack multiple queries in a RULE: > CREATE RULE R_DEL_AB AS > ON DELETE TO V_AB > DO INSTEAD > ( > DELETE FROM A WHERE a_data=OLD.a_data; > DELETE FROM B WHERE b_data=OLD.b_data; > ); -- Rod Taylor <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
