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