Thread: Bug?

Sequence:
-------------------------------------------------------------
listen xxx;
create table xx (a int4);
create rule xx_xx2 as on delete to xx where old.a=1 do notify xxx;
-------------------------------------------------------------

Output:
something like "backend closed connection"

Output I expected:
at least some error message, but not closing of connection.
I know that my SQL sequence is wrong, but i just expected the error
message.

PostgreSQL version:
7.1.1

Platform information:
Linux Slackware 7.1, kernel 2.4.1

--
Best regards,
 Paul                          mailto:magamos@mail.ru

Paul <magamos@mail.ru> writes:
> create rule xx_xx2 as on delete to xx where old.a=1 do notify xxx;

I see it too.  Will investigate.

            regards, tom lane

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