pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed9.0+ way of determining if a LISTEN channel has a backend listening?
2+ messages / 2 participants
[nested] [flat]
* 9.0+ way of determining if a LISTEN channel has a backend listening?
@ 2011-06-01 15:51 James Robinson <jlrobins@socialserve.com>
2011-06-01 22:22 ` Re: 9.0+ way of determining if a LISTEN channel has a backend listening? Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 1 reply; 2+ messages in thread
From: James Robinson @ 2011-06-01 15:51 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 9.0+ way of determining if a LISTEN channel has a backend listening?
2011-06-01 15:51 9.0+ way of determining if a LISTEN channel has a backend listening? James Robinson <jlrobins@socialserve.com>
@ 2011-06-01 22:22 ` Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Sabino Mullane @ 2011-06-01 22:22 UTC (permalink / raw)
To: pgsql-sql
-----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-----
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-06-01 22:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-01 15:51 9.0+ way of determining if a LISTEN channel has a backend listening? James Robinson <jlrobins@socialserve.com>
2011-06-01 22:22 ` Greg Sabino Mullane <greg@turnstep.com>
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