Paul <magamos(at)mail(dot)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
In response to
- Bug? at 2001-05-31 04:50:35 from Paul
pgsql-bugs by date
|Next:||From: Michael Caine||Date: 2001-06-04 15:57:33|
|Subject: Re(2): REFERENCES fails on derived classes|
|Previous:||From: Stephan Szabo||Date: 2001-06-04 15:33:30|
|Subject: Re: Problem with sql |