Re: Restrictions of channel arg of pg_notofy - Mailing list pgsql-sql

From Axel Rau
Subject Re: Restrictions of channel arg of pg_notofy
Date
Msg-id E5B1FE41-D93A-4CA3-8754-1650A90CBFAD@Chaos1.DE
Whole thread Raw
In response to Re: Restrictions of channel arg of pg_notofy  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Restrictions of channel arg of pg_notofy  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Restrictions of channel arg of pg_notofy
Next
From: Tom Lane
Date:
Subject: Re: Restrictions of channel arg of pg_notofy