Re: [SQL NOTIFY Help] sending NOTIFY to the external program

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: [SQL NOTIFY Help] sending NOTIFY to the external program
Дата
Msg-id 459B83F1.9050609@archonet.com
обсуждение исходный текст
Ответ на [SQL NOTIFY Help] sending NOTIFY to the external program  (<ramachandra.bhaskaram@wipro.com>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: [SQL NOTIFY Help] sending NOTIFY to the external program
Следующее
От:
Дата:
Сообщение: Re: [SQL NOTIFY Help] sending NOTIFY to the external program