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: | [RESOLVED] Re: Restrictions of channel arg of pg_notofy |
Date: | 2019-04-29 08:23:50 |
Message-ID: | 7132CB09-50FF-4F5A-A44D-45EB441CB888@Chaos1.DE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Am 28.04.2019 um 20:23 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> 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.
Oh, I see. The constant string case now works if both LISTEN and pg_notify args are lower case.
This was an important hint.
>
> However, that doesn't seem like it would explain your original problem,
> since that didn't involve upper-case letters.
The original problem could also be resolved by ensuring same case and listen for currect facility. (-;
Thanks for your patience,
Axel
---
PGP-Key:29E99DD6 ☀ computing @ chaos claudius
From | Date | Subject | |
---|---|---|---|
Next Message | Mike LAZLO | 2019-04-30 13:41:32 | ERROR: missing FROM-clause entry for table "new" |
Previous Message | Tom Lane | 2019-04-28 18:23:16 | Re: Restrictions of channel arg of pg_notofy |