Re: Restrictions of channel arg of pg_notofy

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Restrictions of channel arg of pg_notofy
Date: 2019-04-28 16:22:12
Message-ID: E5B1FE41-D93A-4CA3-8754-1650A90CBFAD@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Am 27.04.2019 um 20:51 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2019-04-28 17:02:06 Re: Restrictions of channel arg of pg_notofy
Previous Message Tom Lane 2019-04-27 18:51:57 Re: Restrictions of channel arg of pg_notofy