Re: Allow LISTEN on patterns
| От | Greg Sabino Mullane |
|---|---|
| Тема | Re: Allow LISTEN on patterns |
| Дата | |
| Msg-id | CAKAnmm+BJidBmAabseWZG7xcFzy3qZEpVJCKhC0F3R019USnzA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Allow LISTEN on patterns (Trey Boudreau <trey@treysoft.com>) |
| Список | pgsql-hackers |
Does not seem like a bug to me. Just the normal auto-lowercase encountered in every other SQL command. See:
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
(0 rows)
greg=# listen foo;
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
foo
(1 row)
greg=# listen FOO;
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
foo
(1 row)
greg=# listen "FOO";
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
foo
FOO
(2 rows)
pg_listening_channels
-----------------------
(0 rows)
greg=# listen foo;
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
foo
(1 row)
greg=# listen FOO;
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
foo
(1 row)
greg=# listen "FOO";
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_channels
-----------------------
foo
FOO
(2 rows)
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
В списке pgsql-hackers по дате отправления: