Re: notification information functions - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: notification information functions
Date
Msg-id 1211183178.8174.7.camel@huvostro
Whole thread Raw
In response to notification information functions  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: notification information functions  (Andrew Dunstan <andrew@dunslane.net>)
Re: notification information functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 2008-05-18 at 16:00 -0400, Andrew Dunstan wrote:
> I am working on moving the notification buffer into shared memory as 
> previously discussed. Since pg_listener will no longer exist, I think we 
> need to provide a couple of information functions.
> 
> I suggest:
> 
> pg_listened_events(out event name) returns setof record
> pg_pending_events(out  event name, out message text) returns setof record
> 
> The first would show events being listened on by the current backend, 
> while the second would show all pending events for the current db.
> 
> Given that there will no longer be any central place where events will 
> be registered to be listened on, it will not be possible to show all 
> such events for the  current db.

Are you sure that there will be no central place ? 

How will we know then that all listeners have received their events ?

------------------
Hannu




pgsql-hackers by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: WITH RECURSIVE patch V0.1
Next
From: Agro-annuaire
Date:
Subject: Agro-annuaire.com vous invite à nous rendre visite au Salon SMA-Med Food 2008 du 20 au 24 mai