| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | "Anagha Joshi" <ajoshi(at)nulinkinc(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Latest transcation |
| Date: | 2003-06-19 13:56:06 |
| Message-ID: | 200306190656.08040.jgardner@jonathangardner.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 18 June 2003 22:16, Anagha Joshi wrote:
> Is there any way to know programatically which is the latest
> insert/update occured to a particular table?
> What are the values which are inserted/updated to that table?
>
If you want to record transaction history on a table, you'll need to use
triggers and a separate table to store the history in. When the transaction
that modified the table commits, the modification to the history table from
the trigger will commit also, in the order they committed.
- --
Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
(was jgardn(at)alumni(dot)washington(dot)edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+8cD2WgwF3QvpWNwRAnoAAJ4j/gaXd2V748O2M/8pNvY9IYhGkgCeNhe2
KjXh8NwRMtMtfYFvPX69wWE=
=8Aa3
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Gardner | 2003-06-19 14:07:36 | Re: Latest transcation |
| Previous Message | Anagha Joshi | 2003-06-19 11:41:12 | Re: Latest transcation |