Re: LISTEN & NOTIFY data

Is there any way to listen to all NOTIFY signals?

--------------------[-- burra@colorado.edu --]--------------------------

On Mon, 3 Dec 2001, Tom Lane wrote:

> Burra <burra@colorado.edu> writes:
> > Is there any way to send data along with the NOTIFY command... like
> > possibly oid?
>
> Put the data you need into a table, and use NOTIFY as a signal that
> it's time to look into that table.  Anything else can't work because
> of the signal-ish nature of NOTIFY --- in particular, that if the same
> condition is signaled multiple times while you are within a transaction
> block, you'll get just one notification when you come out of the
> transaction.  If you tried to piggyback OIDs on the messages, you'd lose
> all but one.
>
> You may care to study the advice given on the NOTIFY reference page.
>
>             regards, tom lane