Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group