Re: followup on view/rule/delete problem.

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 ?

Uytkownik "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> napisa w wiadomoci
news:27340(dot)992455816(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> Pete Leonard <pete(at)hero(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly