Re: Bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul <magamos(at)mail(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug?
Date: 2001-06-04 15:34:11
Message-ID: 3849.991668851@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Caine 2001-06-04 15:57:33 Re(2): REFERENCES fails on derived classes
Previous Message Stephan Szabo 2001-06-04 15:33:30 Re: Problem with sql