Re: problem with ON UPDATE rule - Mailing list pgsql-general

From Tom Lane
Subject Re: problem with ON UPDATE rule
Date
Msg-id 20468.1280770469@sss.pgh.pa.us
Whole thread Raw
In response to problem with ON UPDATE rule  (Phil Dagosto <phildagosto@gmail.com>)
List pgsql-general
Phil Dagosto <phildagosto@gmail.com> writes:
> I am trying to use event notifications controlled by an ON UPDATE
> rule.

Rules don't work the way you are hoping --- in particular, the NOTIFY
will fire whether or not any individual rows get inserted.  You might
have better luck using a trigger instead.

            regards, tom lane

pgsql-general by date:

Previous
From: Phil Dagosto
Date:
Subject: problem with ON UPDATE rule
Next
From: "Joshua D. Drake"
Date:
Subject: Re: solaris slow