LISTEN & NOTIFY data

From: Burra <burra(at)colorado(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: LISTEN & NOTIFY data
Date: 2001-12-03 13:44:17
Message-ID: Pine.GSO.4.40.0112030638320.7178-100000@ucsub.colorado.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hello all,
Is there any way to send data along with the NOTIFY command... like
possibly oid?

I have a process listening on a certain NOTIFY name. When it gets that
signal from the database I want it to beable to get the "row" that was
affected and do some operations on it. Right now I have to do a
complex query to see what has changed... and that is just not efficent
enough for my needs. It would be great if postgres would get this
functionality, if it doesn't have it already... I hope :)

---------------------[-- burra(at)colorado(dot)edu --]--------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-12-03 14:31:28 Re: LISTEN & NOTIFY data
Previous Message Ken Corey 2001-12-03 09:05:50 Re: Disk space problem...