9.0+ way of determining if a LISTEN channel has a backend listening?

From: James Robinson <jlrobins(at)socialserve(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: 9.0+ way of determining if a LISTEN channel has a backend listening?
Date: 2011-06-01 15:51:30
Message-ID: 30AD2CDF-A92B-4437-84EF-7995C61492C8@socialserve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Sabino Mullane 2011-06-01 22:22:39 Re: 9.0+ way of determining if a LISTEN channel has a backend listening?
Previous Message Dean le Roux 2011-06-01 15:00:41 Re: problem with update data sets from front ends 8.4, Ubuntu 10.04