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