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(at)sss(dot)pgh(dot)pa(dot)us>:
> PG Bug reporting form <noreply(at)postgresql(dot)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
>