Re: Catalog for LISTEN'ed to notification channels?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Catalog for LISTEN'ed to notification channels?
Дата
Msg-id 4047830.1687440599@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Catalog for LISTEN'ed to notification channels?  (Dominique Devienne <ddevienne@gmail.com>)
Ответы Re: Catalog for LISTEN'ed to notification channels?
Список pgsql-general
Dominique Devienne <ddevienne@gmail.com> writes:
> Can I introspect which "channel(s)" the current (or any other session) is
> LISTEN'ing to?

The pg_listening_channels() function will show you channel names the
current session is listening to.  There's no way to find out about
other sessions, because that state is only backend-local.

            regards, tom lane



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

Предыдущее
От: "xxai.art"
Дата:
Сообщение: postgresql 16beta1-alpine3.18 : build plugin , VARSIZE_ANY_EXHDR: symbol not found
Следующее
От: Abhishek Dasgupta
Дата:
Сообщение: FIPS-related Error: Password Must Be at Least 112 Bits on Postgres 14, Unlike in Postgres 11