Re: Restrictions of channel arg of pg_notofy

Axel Rau <axel.rau@chaos1.de>

From: Axel Rau <Axel.Rau@chaos1.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@lists.postgresql.org
Date: 2019-04-28T16:22:12Z
Lists: pgsql-sql

> Am 27.04.2019 um 20:51 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
> 
> 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