Re: Retrieve the record ID

We have a system that sends back information by using the RAISE NOTICE.
I've taken two lines out of it and put them here to illustrate the
idea. You may have to play with it to get it right:

NotifyList = 'The OID is: ' || CAST(new.oid as varchar(10)) || ';';
RAISE NOTICE '%',NotifyList;

Luca Ciciriello wrote:
> Hi all.
> I'm new to this list and, first of all, I'm a new user of PostgreSQL.
> The version I'm using is 8.2.3 and I've the necessity to retrieve,
> using an
> application, the ID of a modified (INSERT, UPDATE, DELETE) record of a
> triggered table. I wasn't able to find out a way to obtain the
> required ID.
> The only information available outside of the DBMS and usable by my app
> (subscribed for a significant event) are the table name and the server
> process id.
> The application is running on Windows XP and the server is installed on
> Windows Server 2003.
> Any one knows a way to notify my app with the ID of the modified record?
> Any idea is appreciated.
>
> Thanks in advance.
>
> Luca
>
> _________________________________________________________________
> Watch all 9 Live Earth concerts live on MSN. http://liveearth.uk.msn.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com www.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010