Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifiesafter CommitTransactionCommand - Mailing list pgsql-bugs

From RekGRpth
Subject Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifiesafter CommitTransactionCommand
Date
Msg-id CAPgh2mJrNN7SSs0H6Ak7bTiyMsXk9Onc7b5B9geb59=qBEqURA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand
Next
From: Tom Lane
Date:
Subject: Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand