Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 01991B617C5 for ; Wed, 1 Jun 2011 19:22:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 83175-07 for ; Wed, 1 Jun 2011 22:22:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zql.com (zql.com [206.222.31.58]) by mail.postgresql.org (Postfix) with ESMTP id 95752B6175B for ; Wed, 1 Jun 2011 19:22:39 -0300 (ADT) Received: from localhost ([127.0.0.1]) by zql.com with smtp (Exim 4.68) (envelope-from ) id 1QRtoF-0002y7-EF; Wed, 01 Jun 2011 18:22:39 -0400 From: "Greg Sabino Mullane" To: pgsql-sql@postgresql.org Subject: Re: 9.0+ way of determining if a LISTEN channel has a backend listening? X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <30AD2CDF-A92B-4437-84EF-7995C61492C8@socialserve.com> Date: Wed, 1 Jun 2011 22:22:39 -0000 X-Mailer: JoyMail 2.4.0 Message-ID: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/3 X-Sequence-Number: 35469 -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > 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? No, there is no way. As mentioned on a similar thread on -hackers, you could possibly use advisory locks if you really need to know what another session is listening to. - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201106011822 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAk3mu54ACgkQvJuQZxSWSsiAYwCg/Oa00qCfiRI3jxhml6a2fnkz 8IUAn3Re+3IUo2IynMIRLLqzH4+uyN9n =YL88 -----END PGP SIGNATURE-----