Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifiesafter CommitTransactionCommand

Поиск
Список
Период
Сортировка
От RekGRpth
Тема Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifiesafter CommitTransactionCommand
Дата
Msg-id CAPgh2mJrNN7SSs0H6Ak7bTiyMsXk9Onc7b5B9geb59=qBEqURA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand
Список pgsql-bugs
Дерево обсуждения
No, it wasn't. I listen in another connection and receive both notifications but only after 10 seconds!
with bst regrds, Rek>pth


пт, 14 февр. 2020 г. в 20:20, Tom Lane <tgl@sss.pgh.pa.us>:
PG Bug reporting form <noreply@postgresql.org> writes:
> psql -c "begin;select pg_notify('channel', concat_ws(' = ', 'a',
> clock_timestamp()::text));commit;select pg_sleep(10);begin;select
> pg_notify('channel', concat_ws(' = ', 'b',
> clock_timestamp()::text));commit;select now(), clock_timestamp();"

I think the main reason why this isn't reporting any notifications
is that you forgot to issue a LISTEN.

                        regards, tom lane

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