Postgres Pro
Downloads
Home   >   mailing lists

Re: listen not schema-aware - Mailing list pgsql-hackers

From Neil Conway
Subject Re: listen not schema-aware
Date
Msg-id 1143855722.21012.10.camel@localhost.localdomain
Whole thread Raw
In response to listen not schema-aware  (Agent M <agentm@themactionfaction.com>)
Responses Re: listen not schema-aware  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Fri, 2006-03-31 at 20:27 -0500, Agent M wrote:
> Why is the schema ignored entirely when using listen/notify?

Per the docs:
   Commonly, the notification name is the same as the name of some   table in the database, and the notify event
essentiallymeans, "I   changed this table, take a look at it to see what's new". But no   such association is enforced
bythe NOTIFY and LISTEN commands.
 

i.e. the LISTEN/NOTIFY argument is not the name of a relation, so it
wouldn't make much sense to schema-qualify it.

-Neil

pgsql-hackers by date:

Previous
From: "Mike Rylander"
Date:
Subject: Re: First Aggregate Funtion?
Next
From: Tom Lane
Date:
Subject: Re: listen not schema-aware