| Lists: | pgsql-hackers |
|---|
| 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 |
| 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
¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬
| 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.
-Neil
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Agent M <agentm(at)themactionfaction(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: listen not schema-aware |
| Date: | 2006-04-01 01:52:12 |
| Message-ID: | 6378.1143856332@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Neil Conway <neilc(at)samurai(dot)com> writes:
> i.e. the LISTEN/NOTIFY argument is not the name of a relation, so it
> wouldn't make much sense to schema-qualify it.
I'm not entirely sure why we even have the grammar allowing qualified
names in these statements. It's not documented that you can do that.
regards, tom lane