Thank you both for clearing that up (and doing so quite quickly!).
The behavior makes complete sense now that I understand what is
happening here behind the scenes.
Regards,
Josh
On 3/3/2011 11:24 AM, Tom Lane wrote:
"Joshua McDougall" writes:
When using the pg_notify(text,text) function, t
"Joshua McDougall" writes:
> When using the pg_notify(text,text) function, the channel name MUST be lower
> case otherwise the message does not go through.
It's not clear to me that this is a bug. The argument of NOTIFY is a
SQL identifier, which is folded to lower case by the lexer if not
doubl
On Thu, Mar 3, 2011 at 9:20 AM, Joshua McDougall wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5911
> Logged by: Joshua McDougall
> Email address: j...@schemaverse.com
> PostgreSQL version: 9.0.3
> Operating system: Slackware Linux Kernel 2.6.28.6
>
The following bug has been logged online:
Bug reference: 5911
Logged by: Joshua McDougall
Email address: j...@schemaverse.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
