On Monday, 21 February 2022 at 04:48:56 UTC, Chris Piker wrote:
On Sunday, 20 February 2022 at 18:36:21 UTC, eugene wrote:
I often use two connections, one for perform main task
(upload some data and alike) and the second for getting
notifications from PG, 'cause it very incovinient to
do both in a single connection.
Ah, a very handy tip. It would be convoluted to multiplex
notifications
on the data connection.
I am remembering psql client behavior - it sees notifications
only after some request. It is really inconvinient to perform
regular tasks and be ready to peek up notifications at any moment
in one connection.