Re: pg_notify but no pg_listen? - Mailing list pgsql-general

From Craig Ringer
Subject Re: pg_notify but no pg_listen?
Date
Msg-id 4C732BEA.4070800@postnewspapers.com.au
Whole thread Raw
In response to Re: pg_notify but no pg_listen?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_notify but no pg_listen?
List pgsql-general
On 08/24/2010 06:43 AM, Bruce Momjian wrote:
> A.M. wrote:
>> There is a new pg_notify function in pgsql 9.0 but no pg_listen
>> equivalent? Why? It sure would be handy to pass quoted strings...
>
> Notify sends the notify;  there is no place to send a 'listen' payload.

I assume what they want is the ability to filter notifications, so they
only get notifications with a certain payload.

Seems to me that in that case you should just be using different notify
values (possibly using the two-argument form of pg_notify) so you can
listen on different things depending on what you are interested in.

--
Craig Ringer

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: IBATIS support for postgres cursors
Next
From: Craig Ringer
Date:
Subject: Re: select from pipe-delimited field