Re: 9.0+ way of determining if a LISTEN channel has a backend listening?

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: 9.0+ way of determining if a LISTEN channel has a backend listening?
Дата
Msg-id acd79182fa480c98af84161982120be3@biglumber.com
обсуждение исходный текст
Ответ на 9.0+ way of determining if a LISTEN channel has a backend listening?  (James Robinson <jlrobins@socialserve.com>)
Список 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-----



В списке pgsql-sql по дате отправления:

Предыдущее
От: James Robinson
Дата:
Сообщение: 9.0+ way of determining if a LISTEN channel has a backend listening?
Следующее
От: lists-pgsql@useunix.net
Дата:
Сообщение: selecting records X minutes apart