From: | Burra <burra(at)colorado(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: LISTEN & NOTIFY data |
Date: | 2001-12-03 16:04:55 |
Message-ID: | Pine.GSO.4.40.0112030903510.7178-100000@ucsub.colorado.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Is there any way to listen to all NOTIFY signals?
--------------------[-- burra(at)colorado(dot)edu --]--------------------------
On Mon, 3 Dec 2001, Tom Lane wrote:
> Burra <burra(at)colorado(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-03 16:09:33 | Re: LISTEN & NOTIFY data |
Previous Message | Tom Lane | 2001-12-03 14:31:28 | Re: LISTEN & NOTIFY data |