From: James Robinson <jlrobins@socialserve.com>
To: pgsql-sql@postgresql.org
Subject: 9.0+ way of determining if a LISTEN channel has a backend listening?
Date: Wed, 1 Jun 2011 11:51:30 -0400
Message-ID: <30AD2CDF-A92B-4437-84EF-7995C61492C8@socialserve.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jlrobins@socialserve.com
Subject: Re: 9.0+ way of determining if a LISTEN channel has a backend listening?
In-Reply-To: <30AD2CDF-A92B-4437-84EF-7995C61492C8@socialserve.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox