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

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



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

Предыдущее
От: Dean le Roux
Дата:
Сообщение: Re: problem with update data sets from front ends 8.4, Ubuntu 10.04
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: 9.0+ way of determining if a LISTEN channel has a backend listening?