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: 2006-04-01 01:42:02
Message-ID: 1143855722.21012.10.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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.


In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-04-01 01:52:12 Re: listen not schema-aware
Previous Message Mike Rylander 2006-04-01 01:35:35 Re: First Aggregate Funtion?