pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Listen / Notify questions 2+ messages / 2 participants [nested] [flat]
* Listen / Notify questions @ 2006-07-09 09:43 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> 0 siblings, 1 reply; 2+ messages in thread From: Joost Kraaijeveld @ 2006-07-09 09:43 UTC (permalink / raw) To: pgsql-interfaces Hi, Two questions: 1. Is there a way to determine which sessions are listening for a certain notify message? 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? -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Listen / Notify questions @ 2006-07-09 16:51 Michael Fuhr <mike@fuhr.org> parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> 0 siblings, 0 replies; 2+ messages in thread From: Michael Fuhr @ 2006-07-09 16:51 UTC (permalink / raw) To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-07-09 16:51 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-07-09 09:43 Listen / Notify questions Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> 2006-07-09 16:51 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox