agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: 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 14:23:16 -0400
Message-ID: <15104.1556475796@sss.pgh.pa.us> (raw)
In-Reply-To: <AE68D1AC-EC94-4F35-9C2C-65A6923D79E5@Chaos1.DE>
References: <023C223F-4FC9-4E9E-A8C6-17F491358FA7@Chaos1.DE>
	<28634.1556391117@sss.pgh.pa.us>
	<E5B1FE41-D93A-4CA3-8754-1650A90CBFAD@Chaos1.DE>
	<11072.1556470926@sss.pgh.pa.us>
	<5881D6C2-071E-47AA-A1DB-3C38CD6852BB@Chaos1.DE>
	<AE68D1AC-EC94-4F35-9C2C-65A6923D79E5@Chaos1.DE>

Axel Rau <Axel.Rau@Chaos1.DE> writes:
>> Am 28.04.2019 um 19:02 schrieb Tom Lane <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>>:
>>> Hard to tell when you haven't provided a complete example.

>> This is my test case with constant string:
>> CREATE OR REPLACE FUNCTION syslog.new_event_action() RETURNS trigger
>> LANGUAGE plpgsql
>> AS $$
>> BEGIN
>> RAISE WARNING 'syslog.new_event_action() called.';
>> PERFORM pg_notify('INSERTED', '');
>> RETURN NEW;
>> END
>> $$;
>> 
>> The warning is being logged.
>> 
>> In psql session 1, I run a LISTEN INSERTED;

If you're typing it exactly like that, you have a case-folding problem.
Try
	LISTEN "INSERTED";
instead, or make the pg_notify argument lower-case.

However, that doesn't seem like it would explain your original problem,
since that didn't involve upper-case letters.

			regards, tom lane

view thread (7+ messages)  latest in thread

Message-ID: <15104.1556475796@sss.pgh.pa.us>
Permalink:  ../15104.1556475796@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/15104.1556475796@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: <15104.1556475796@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