Re: [BUGS] can't delete record from second table in rules of view with join select

2008-03-25 Thread Tom Lane
Sergey Burladyan <[EMAIL PROTECTED]> writes: > 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

Re: [BUGS] can't delete record from second table in rules of view with join select

2008-03-25 Thread Sergey Burladyan
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

[BUGS] can't delete record from second table in rules of view with join select

2008-03-25 Thread Sergey Burladyan
Hello, all From sql.ru forum: 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 ( dele