| From: | "Luca Ciciriello" <luca_ciciriello(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Retrieve the record ID |
| Date: | 2007-07-20 07:55:25 |
| Message-ID: | BAY114-F121046E852CC366D4EDF629AF40@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shane Ambler | 2007-07-20 09:08:45 | Re: Retrieve the record ID |
| Previous Message | Richard Huxton | 2007-07-20 07:44:31 | Re: several postgres installations on the same machine? |