Re: Restrictions of channel arg of pg_notofy

Axel Rau <[email protected]> Sun, 28 Apr 2019 18:22:12 +0200
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>

> Am 27.04.2019 um 20:51 schrieb Tom Lane <[email protected]>:
> 
> I think more likely what you're running into is that the NOTIFY won't
> be delivered until end of transaction?


Both the INSERT and the LISTEN are one-statement transactions.
I have investigated further:
pg_notify does not work at all, even with a constant string channel arg.
NOTIFY works.
This is release 11.2.

What am I doing wrong?
Axel
---
PGP-Key:29E99DD6  ☀  computing @ chaos claudius