pgplsql and notifications

Started by Kenéz Attilaabout 20 years ago2 messagesgeneral
Jump to latest
#1Kenéz Attila
akenez@energo-szoft.hu

Hi all,

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. I mean
something like this:

create procedure do_i_have_notifications(text) returns boolean as '
...
' language (plpg)sql;

(or:

create procedure received_notifications() returns setof text as '
...
' langugae (plpg)sql;
)

Is there a way to do this?

Thanks,

Attila Ken�z

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Kenéz Attila (#1)
Re: pgplsql and notifications

=?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