BUG #5911: pg_notify() function only works when channel name is lower case

From: "Joshua McDougall" <josh(at)schemaverse(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5911: pg_notify() function only works when channel name is lower case
Date: 2011-03-03 15:20:59
Message-ID: 201103031520.p23FKxFJ049037@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5911
Logged by: Joshua McDougall
Email address: josh(at)schemaverse(dot)com
PostgreSQL version: 9.0.3
Operating system: Slackware Linux Kernel 2.6.28.6
Description: pg_notify() function only works when channel name is
lower case
Details:

When using the pg_notify(text,text) function, the channel name MUST be lower
case otherwise the message does not go through.

So, while this will work:

LISTEN ERRORCHANNEL;
NOTIFY ERRORCHANNEL, 'something!';
NOTIFY eRrorChanNel, 'something!';

this will not:
SELECT pg_notify('ERRORCHANNEL','something!');

You must use:
SELECT pg_notify('errorchannel','something!');

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2011-03-03 15:24:27 Re: Corrupted index on 9.0.3 streaming hot standby
Previous Message Robert Haas 2011-03-03 15:20:06 Re: BUG #5895: Ability to match more than just CN in client certificate