[RESOLVED] Re: Restrictions of channel arg of pg_notofy

Поиск
Список
Период
Сортировка
От Axel Rau
Тема [RESOLVED] Re: Restrictions of channel arg of pg_notofy
Дата
Msg-id 7132CB09-50FF-4F5A-A44D-45EB441CB888@Chaos1.DE
обсуждение исходный текст
Ответ на Re: Restrictions of channel arg of pg_notofy  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql

Am 28.04.2019 um 20:23 schrieb Tom Lane <tgl@sss.pgh.pa.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




В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Restrictions of channel arg of pg_notofy
Следующее
От: Mike LAZLO
Дата:
Сообщение: ERROR: missing FROM-clause entry for table "new"