Postgres Pro
Downloads
Home   >   mailing lists

Re: NOTIFY / LISTEN silently parses and discards schema-ish portion of notification name ... - Mailing list pgsql-hackers

From James Robinson
Subject Re: NOTIFY / LISTEN silently parses and discards schema-ish portion of notification name ...
Date
Msg-id C0903F77-C132-4937-96F8-4EE35069DA1E@socialserve.com
Whole thread Raw
In response to NOTIFY / LISTEN silently parses and discards schema-ish portion of notification name ...  (James Robinson <jlrobins@socialserve.com>)
List pgsql-hackers
Tree view

On Apr 16, 2009, at 6:51 AM, pgsql-hackers-owner@postgresql.org wrote:


Considered unexpected behavior, or at least in its undocumented form.
If value given to NOTIFY seems schema-qualified, the schema
qualification is eroded by the time it is presented to the listener --

See:

http://archives.postgresql.org//pgsql-patches/2007-02/msg00437.php

Pretty sure 8.4 will not use "relation".

Thanks for pointer on a proposed patch, Greg. That patch looks like it hasn't been applied to the 8.2 maintenance stream.

Looks like in 8.3 the grammar changed the name argument to ColId production, which goes unparsed. Shame on me for using such an old version [ 8.2 ], but hey, it works.



----

James Robinson

Socialserve.com


pgsql-hackers by date:

Previous
From: Kevin Field
Date:
Subject: Re: Postgres SQL specification (tests)
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Yet another regression issue with Fedora-10 + PG 8.4 beta1