SEO

#1 (**permalink**) 04-09-2008, 08:27 AM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-09-2008, 08:27 AM

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

pgplsql and notifications