notification information functions - Mailing list pgsql-hackers

From Andrew Dunstan
Subject notification information functions
Date
Msg-id 48308AEB.40102@dunslane.net
Whole thread Raw
Responses Re: notification information functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: notification information functions  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers
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.

Comments?

cheers

andrew


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1
Next
From: Tom Lane
Date:
Subject: Re: notification information functions