Re: pgplsql and notifications

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kenéz Attila <akenez(at)energo-szoft(dot)hu>
Cc: "Psql_General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgplsql and notifications
Date: 2006-02-19 17:07:42
Message-ID: 11510.1140368862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-1?Q?Ken=E9z_Attila?= <akenez(at)energo-szoft(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2006-02-19 18:56:00 Backslashes in data in version 8.1.2
Previous Message Peter 2006-02-19 14:22:41 Re: Domains