Hello, all > not important, is it one rule like: > create rule v_del as on delete to v do instead ( > delete from o1 where id = old.o1_id; > delete from o2 where id = old.o2_id; > ); > > or split into two rule like: > create rule v_del1 as on delete to v do instead ( > delete from o1 where id = old.o1_id; > ); > create rule v_del2 as on delete to v do instead ( > delete from o2 where id = old.o2_id; > );
Sorry, after thinking some time about this problem now i may be understand what going on there... %) When first rule was exec - no OLD row anymore in "v" view, nothing will be joined and in second rule OLD value is empty... so my question is changed to: is this expected behavior or a bug ? %) --- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs