listen not schema-aware

From: Agent M <agentm(at)themactionfaction(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: listen not schema-aware
Date: 2006-04-01 01:27:10
Message-ID: 329c9643ed076e0200c4b414ba62a4e8@themactionfaction.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Why is the schema ignored entirely when using listen/notify? I couldn't
find any mention of this in the documentation.

Ideally, it should support schemas (and store any string it takes) but
it should at least throw an error when a schema is prepended. I guess
the workaround is to simply delete the period.

client 1:
listen schema1.msg;

client 2:
notify schema1.msg;
notify schema2.msg;

client 1:
Asynchronous notification "msg" received from server process with PID X.
Asynchronous notification "msg" received from server process with PID X.

¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬
AgentM
agentm(at)themactionfaction(dot)com
¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2006-04-01 01:31:10 Re: Suggestion: Which Binary?
Previous Message David Wheeler 2006-04-01 01:11:04 Re: Suggestion: Which Binary?