Re: Bug? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug?
Date
Msg-id 3849.991668851@sss.pgh.pa.us
Whole thread Raw
In response to Bug?  (Paul <magamos@mail.ru>)
List pgsql-bugs
Paul <magamos@mail.ru> writes:
> create table xx (a int4);
> create rule xx_xx2 as on delete to xx where old.a=1 do notify xxx;
> something like "backend closed connection"

Okay, the problem here is that we don't support NOTIFY (or other utility
statements) in conditional rules.  This isn't likely to change soon.
I agree it shouldn't crash though; will fix that.

Consider using a trigger to do the notify, instead.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Problem with sql
Next
From: Trurl McByte
Date:
Subject: ...