Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4786AB60619 for ; Wed, 1 Jun 2011 13:10:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 80146-09 for ; Wed, 1 Jun 2011 16:10:27 +0000 (UTC) X-Greylist: delayed 00:18:56.460044 by SQLgrey-1.7.6 Received: from mail.socialserve.com (mail2.socialserve.com [66.129.73.133]) by mail.postgresql.org (Postfix) with ESMTP id B1A61B5FE6A for ; Wed, 1 Jun 2011 13:10:27 -0300 (ADT) Received: from jlrobins.mthousingsearch.com (jlrobins.socialserve.com [10.1.1.43]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: jlrobins) by mail.socialserve.com (Postfix) with ESMTP id EE2EF170506 for ; Wed, 1 Jun 2011 11:51:30 -0400 (EDT) Message-Id: <30AD2CDF-A92B-4437-84EF-7995C61492C8@socialserve.com> From: James Robinson To: pgsql-sql@postgresql.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Subject: 9.0+ way of determining if a LISTEN channel has a backend listening? Date: Wed, 1 Jun 2011 11:51:30 -0400 X-Mailer: Apple Mail (2.936) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/2 X-Sequence-Number: 35468 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