I'v got the same problem with view/rule/delete in v. 7.1.2 (view/rule/insert
and update - work)
Could you tell me where is the patch ?
U�ytkownik "Tom Lane" <tgl@sss.pgh.pa.us> napisa� w wiadomo�ci
news:27340.992455816@sss.pgh.pa.us...
> Pete Leonard <pete@hero.com> writes:
> > Unfortunately, I'm still not quite there - I'm still experiencing DB
> > hangs, and was able to duplicate it with the following simplified
schema.
> > Is this a 7.1-specific bug? Is it breaking 7.1.2 as well?
> > ...
> > create rule delete_foobar as on delete to foobar
> > do instead (
> > insert into log (id, action) values (OLD.id, 'deleted');
> > delete from foo where id=OLD.id;
> > );
>
> Almost anything involving a multi-action rule and references to views
> is probably vulnerable to the bug I found yesterday :-(. Please try
> it with 7.1.2 plus the patch I posted.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
