Postgres Pro
Downloads
Home   >   mailing lists

Re: Allow LISTEN on patterns - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Allow LISTEN on patterns
Date
Msg-id CAKAnmm+BJidBmAabseWZG7xcFzy3qZEpVJCKhC0F3R019USnzA@mail.gmail.com
Whole thread Raw
In response to Re: Allow LISTEN on patterns  (Trey Boudreau <trey@treysoft.com>)
List pgsql-hackers
Tree view
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)


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: "Burd, Greg"
Date:
Subject: Re: Expanding HOT updates for expression and partial indexes
Next
From: Daniel Gustafsson
Date:
Subject: Re: Adding support for SSLKEYLOGFILE in the frontend