Postgres Pro
Downloads
Home   >   mailing lists

Re: pgplsql and notifications - Mailing list pgsql-general

From Tom Lane
Subject Re: pgplsql and notifications
Date
Msg-id 11510.1140368862@sss.pgh.pa.us
Whole thread Raw
In response to pgplsql and notifications  (Kenéz Attila <akenez@energo-szoft.hu>)
List pgsql-general
Tree view 
=?ISO-8859-1?Q?Ken=E9z_Attila?= <akenez@energo-szoft.hu> writes:
> I would like to implement a function in plpgsql (or sql if it is possible)
> that can say me if I had some notification of some listened table.

Notifications are delivered to the client (and then promptly forgotten
by the backend).  There is no way to track accumulated notifications
except on the client side.

            regards, tom lane

pgsql-general by date:

Previous
From: Peter
Date:
Subject: Re: Domains
Next
From: Mike Nolan
Date:
Subject: Backslashes in data in version 8.1.2