Paul <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
