Re: followup on view/rule/delete problem. - Mailing list pgsql-general

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