agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Axel Rau <Axel.Rau@chaos1.de>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Restrictions of channel arg of pg_notofy
Date: Sun, 28 Apr 2019 13:02:06 -0400
Message-ID: <11072.1556470926@sss.pgh.pa.us> (raw)
In-Reply-To: <E5B1FE41-D93A-4CA3-8754-1650A90CBFAD@Chaos1.DE>
References: <023C223F-4FC9-4E9E-A8C6-17F491358FA7@Chaos1.DE>
<28634.1556391117@sss.pgh.pa.us>
<E5B1FE41-D93A-4CA3-8754-1650A90CBFAD@Chaos1.DE>
Axel Rau <Axel.Rau@chaos1.de> writes:
> 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.
[ shrug... ] Works for me.
> What am I doing wrong?
Hard to tell when you haven't provided a complete example.
Just looking at the code you did show, though, I notice that
you have
PERFORM pg_notify(fac);
but there's no single-argument form of pg_notify in standard PG:
regression=# \df pg_notify
List of functions
Schema | Name | Result data type | Argument data types | Type
------------+-----------+------------------+---------------------+------
pg_catalog | pg_notify | void | text, text | func
(1 row)
Maybe whatever shim you've got for that doesn't work right?
regards, tom lane
view thread (7+ messages) latest in thread
Message-ID: <11072.1556470926@sss.pgh.pa.us>
Permalink: ../11072.1556470926@sss.pgh.pa.us/
Also on: postgresql.org/message-id/11072.1556470926@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, Axel.Rau@chaos1.de, pgsql-sql@lists.postgresql.org
Subject: Re: Restrictions of channel arg of pg_notofy
In-Reply-To: <11072.1556470926@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox