Hannu Krosing wrote:
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 ?
Yes, quite sure. See Tom's answer to more or less this question from a
year ago:
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01570.php
What we will have in shared memory is each backend's queue pointer (if any).
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
