Re: Calling external program from trigger

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Calling external program from trigger
Дата
Msg-id 28911.1053442991@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Calling external program from trigger  (Kaare Rasmussen <kar@kakidata.dk>)
Список pgsql-hackers
Kaare Rasmussen <kar@kakidata.dk> writes:
> I would like to notify a server whenever a certain table is updated.

What do you mean by "notify" exactly?

Perhaps you could have a background job that remains always connected to
the database, but sleeps waiting for a NOTIFY to arrive.  A rule like
"ON UPDATE TO foo DO NOTIFY foo_changed" would serve to awaken it.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: System triggers
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Interessting problem