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