From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-sql@postgresql.org
Subject: Re: 9.0+ way of determining if a LISTEN channel has a backend listening?
Date: Wed, 1 Jun 2011 22:22:39 -0000
Message-ID: <acd79182fa480c98af84161982120be3@biglumber.com> (raw)
In-Reply-To: <30AD2CDF-A92B-4437-84EF-7995C61492C8@socialserve.com>
-----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-----
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: greg@turnstep.com
Subject: Re: 9.0+ way of determining if a LISTEN channel has a backend listening?
In-Reply-To: <acd79182fa480c98af84161982120be3@biglumber.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