Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: listen not schema-aware
- From: Neil Conway <neilc(at)samurai(dot)com>
- To: Agent M <agentm(at)themactionfaction(dot)com>
- Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: listen not schema-aware
- Date: Fri, 31 Mar 2006 20:42:02 -0500
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 essentially means, "I
changed this table, take a look at it to see what's new". But no
such association is enforced by the 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
- Follow-Ups:
- Re: listen not schema-aware
- From: Tom Lane
- Re: listen not schema-aware
- References:
- listen not schema-aware
- From: Agent M
- listen not schema-aware
- Prev by Date: Re: First Aggregate Funtion?
- Next by Date: Re: listen not schema-aware
- Previous by thread: listen not schema-aware
- Next by thread: Re: listen not schema-aware
- Indexes: