Re: [SQL NOTIFY Help] sending NOTIFY to the external program - Mailing list pgsql-sql

From Richard Huxton
Subject Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Date
Msg-id 459B83F1.9050609@archonet.com
Whole thread Raw
In response to [SQL NOTIFY Help] sending NOTIFY to the external program  (<ramachandra.bhaskaram@wipro.com>)
List pgsql-sql
ramachandra.bhaskaram@wipro.com wrote:
> Hi,
> 
>     In one of our project we are supposed to send the notifications
> regarding any row modifications in a perticular table to the external
> application which will be implementing the listen event for the same.
> We are using the postgress version 8.0.3.

>     Can anybody clarify whether we can pass the primary key value of
> the record modified in the extra attribute of this structure?

Afraid not. You'll need to record the pkey in a "process_these" table 
and have the application check there.

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From:
Date:
Subject: [SQL NOTIFY Help] sending NOTIFY to the external program
Next
From:
Date:
Subject: Re: [SQL NOTIFY Help] sending NOTIFY to the external program