Is there a way in post-9.0 postgres for one session to determine if a LISTEN channel currently has a backend registered to receive notifications? Prior to 9.0, one could select from system catalog table pg_listener.

Function pg_listening_channels() returns list of symbol names *this* session is listening on; I'd like to find out if a given listen channel has *any* (i.e other session) listeners.

Thanks!
----
James Robinson
Socialserve.com


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to