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