Yes, I've used RAISE NOTICE, but I'm unable to catch it in my code. I've
used PQsetNoticeProcessor to set my callback function but doesn't seem to
work. In My application I'm unable to catch the notice launched by the
trigger. Wich function I have to use in my application in order to catch the
notice event?
Luca.
From: Kenneth Downs <ken@xxxxxxxxxx>
To: Luca Ciciriello <luca_ciciriello@xxxxxxxxxxx>
CC: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Retrieve the record ID
Date: Fri, 20 Jul 2007 08:49:33 -0400
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
_________________________________________________________________
The next generation of Hotmail is here! http://www.newhotmail.co.uk/
