Server->Client notification (without polling)?

Поиск
Список
Период
Сортировка
От Wolfgang Keller
Тема Server->Client notification (without polling)?
Дата
Msg-id 0001HW.C1370538007493AFF0488530@news.individual.de
обсуждение исходный текст
Ответы Re: Server->Client notification (without polling)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hello,

I wonder whether there is a "standard" "built-in" mechanism for a PostgreSQL
client to register with the database for notification in case of
modifications to a given table.

As I understand from the manual, the LISTEN and NOTIFY SQL commands require
to poll the database to retrieve the notification events...?

Would a trigger implemented in PL/Python allow to implement such a
notification mechanism? Would this be an efficient way to do so?

TIA,

Sincerely,

Wolfgang Keller

--
My email-address is correct.
Do NOT remove ".nospam" to reply.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: installing postgresql 8.1.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Server->Client notification (without polling)?