| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Listen / Notify questions |
| Date: | 2006-07-09 16:51:03 |
| Message-ID: | 20060709165103.GB63466@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
On Sun, Jul 09, 2006 at 11:43:15AM +0200, Joost Kraaijeveld wrote:
> 1. Is there a way to determine which sessions are listening for a
> certain notify message?
SELECT * FROM pg_listener;
http://www.postgresql.org/docs/8.1/interactive/catalog-pg-listener.html
> 2. If a session ends without "unlisten" (e.g. my listening program
> crashes), is that session automatically removed from the list of
> sessions that should be notified?
According to the LISTEN documentation, "A session's listen registrations
are automatically cleared when the session ends." You can confirm
this by querying pg_listener.
http://www.postgresql.org/docs/8.1/interactive/sql-listen.html
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wolfgang.wening | 2006-07-11 15:57:24 | No library found for -lpq |
| Previous Message | Joost Kraaijeveld | 2006-07-09 09:43:15 | Listen / Notify questions |