Re: Catalog for LISTEN'ed to notification channels?

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: Catalog for LISTEN'ed to notification channels?
Дата
Msg-id CAFCRh-_dGU8-NDkRGyLnh-Zi=gWXVMx9pvWxr8=wNwBmzUBPyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Catalog for LISTEN'ed to notification channels?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Thu, Jun 22, 2023 at 3:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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.

Thanks Tom. I'll take that. Useful for unit tests at least.

If anyone can share more info or pointers on the design and rationals for
async notification in PostgreSQL, why it is transactional only, with the issue
that ensues, and whether there are any plans about it, I'd appreciate. Thanks, --DD 

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

Предыдущее
От: Abhishek Dasgupta
Дата:
Сообщение: FIPS-related Error: Password Must Be at Least 112 Bits on Postgres 14, Unlike in Postgres 11
Следующее
От: Martin Mueller
Дата:
Сообщение: a really dumb password question