Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKoW4-0000k8-60 for pgsql-sql@arkaria.postgresql.org; Sun, 28 Apr 2019 18:27:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hKoW2-000457-RB for pgsql-sql@arkaria.postgresql.org; Sun, 28 Apr 2019 18:27:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKoSU-0005v1-4m for pgsql-sql@lists.postgresql.org; Sun, 28 Apr 2019 18:23:26 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKoSQ-000769-6c for pgsql-sql@lists.postgresql.org; Sun, 28 Apr 2019 18:23:24 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x3SINGA0015105; Sun, 28 Apr 2019 14:23:16 -0400 From: Tom Lane To: Axel Rau cc: pgsql-sql@lists.postgresql.org Subject: Re: Restrictions of channel arg of pg_notofy In-reply-to: References: <023C223F-4FC9-4E9E-A8C6-17F491358FA7@Chaos1.DE> <28634.1556391117@sss.pgh.pa.us> <11072.1556470926@sss.pgh.pa.us> <5881D6C2-071E-47AA-A1DB-3C38CD6852BB@Chaos1.DE> Comments: In-reply-to Axel Rau message dated "Sun, 28 Apr 2019 19:46:12 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <15103.1556475795.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sun, 28 Apr 2019 14:23:16 -0400 Message-ID: <15104.1556475796@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Axel Rau writes: >> Am 28.04.2019 um 19:02 schrieb Tom Lane >: >>> 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