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