Re: [GENERAL] Determine all listeners subscribed to notifcations and what channels

2015-02-17 Thread Merlin Moncure
On Tue, Feb 17, 2015 at 4:01 PM, Tom Lane wrote: > Cory Tucker writes: >> I'm interested in trying to figure out which channels have been subscribed >> to (using LISTEN). From what I could tell via a little Googling, there >> used to be a table named pg_catalog.pg_listener that contained all thi

Re: [GENERAL] Determine all listeners subscribed to notifcations and what channels

2015-02-17 Thread Tom Lane
Cory Tucker writes: > I'm interested in trying to figure out which channels have been subscribed > to (using LISTEN). From what I could tell via a little Googling, there > used to be a table named pg_catalog.pg_listener that contained all this > information, but that seems to have disappeared som

Re: [GENERAL] Determine all listeners subscribed to notifcations and what channels

2015-02-17 Thread Igor Neyman
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Cory Tucker Sent: Tuesday, February 17, 2015 4:21 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Determine all listeners subscribed to notifcations and what channels I'm interest

[GENERAL] Determine all listeners subscribed to notifcations and what channels

2015-02-17 Thread Cory Tucker
I'm interested in trying to figure out which channels have been subscribed to (using LISTEN). From what I could tell via a little Googling, there used to be a table named pg_catalog.pg_listener that contained all this information, but that seems to have disappeared somewhere in the 9.x release (I'