[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] 9.0+ way of determining if a LISTEN channel has a backend listening?
From: "Greg Sabino Mullane" <greg () turnstep ! com>
Date: 2011-06-01 22:22:39
Message-ID: acd79182fa480c98af84161982120be3 () biglumber ! com
[Download RAW message or body]
-----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-----
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic