Обсуждение: listen/notify

Поиск
Список
Период
Сортировка

listen/notify

От
"Tomas B. Winkler"
Дата:
Hi
Could someone, please give me a little example on how to use listen/notify
mechanism. Or at least point me to some more legible documentation.
What I particulary need is that my frontend application is notified on
update/insert in a table.
Thanx a lot.

Tomas Winkler
The System Group
CSE HUJI


Re: listen/notify

От
Tom Lane
Дата:
"Tomas B. Winkler" <tomasw@cs.huji.ac.il> writes:
> Could someone, please give me a little example on how to use listen/notify
> mechanism. Or at least point me to some more legible documentation.
> What I particulary need is that my frontend application is notified on
> update/insert in a table.

Make an ON INSERT OR UPDATE trigger that executes the NOTIFY.

            regards, tom lane