Server->Client notification (without polling)?

From: Wolfgang Keller <wolfgang(dot)keller(dot)nospam(at)gmx(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Server->Client notification (without polling)?
Date: 2006-09-20 12:48:24
Message-ID: 0001HW.C1370538007493AFF0488530@news.individual.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-09-20 14:33:02 Re: Server->Client notification (without polling)?
Previous Message Tom Lane 2006-09-19 23:12:59 Re: installing postgresql 8.1.4