From: Jonathan Gardner <jgardner@jonathangardner.net>
To: "Anagha Joshi" <ajoshi@nulinkinc.com>, "Bruno Wolff III" <bruno@wolff.to>
Subject: Re: Latest transcation
Date: Thu, 19 Jun 2003 07:07:36 -0700
User-Agent: KMail/1.5
Cc: <pgsql-admin@postgresql.org>, <pgsql-sql@postgresql.org>
References: <FF851C7EEB75954F9BCFB5CA117AB1EC092831@delta.nulinkinc.com>
In-Reply-To: <FF851C7EEB75954F9BCFB5CA117AB1EC092831@delta.nulinkinc.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Description: clearsigned data
Content-Disposition: inline
Message-Id: <200306190707.38082.jgardner@jonathangardner.net>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 19 June 2003 04:41, Anagha Joshi wrote:
> My client C++ front end is multi-threaded. The above 'transcation' block
> is in thread -y .
> I want to know the info. abt' last row inserted into table in this
> transcation block.
> Info contains the details like time of insertion of a row and data in
> that row.
>
> I think this sufficely explains what I want.
>

There are some things you can do at the application level to record what wa=
s=20
done in a seperate thread or even process. With threads, you can use shared=
=20
variables and semaphores. With processes, you can use some form of IPC or=
=20
shared memory.

If you decide to go at an application layer, it is beyond the scope of the=
=20
ADMIN list, and better suited for a discussion with your peers in that=20
language and environment.

If you go for a server-side solution (because the application doesn't know=
=20
what was last inserted and when), then you'll want to use triggers as I=20
described in a previous posting.

- --=20
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+8cOoWgwF3QvpWNwRAmGkAJ4pE8Eb9V/kiyBFqLCqr/2nNqA3HwCg0PE2
2TCK7YF50MKLwbUurS1aqlY=3D
=3DhvKY
-----END PGP SIGNATURE-----