| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Anagha Joshi <ajoshi(at)nulinkinc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Latest transcation |
| Date: | 2003-06-19 10:30:29 |
| Message-ID: | 20030619103029.GA10782@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Jun 19, 2003 at 10:46:22 +0530,
Anagha Joshi <ajoshi(at)nulinkinc(dot)com> wrote:
> Hi All,
> 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?
That depends on what you really are trying to do. It sounds like
using a sequnce, nextval and currval might work. That could be
used to track the latest change in one session.
If you try to look at the latest change to a table accross all sessions,
things get a bit murky.
A more precise description of what you are trying to do might result in
some other suggestions.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anagha Joshi | 2003-06-19 11:41:12 | Re: Latest transcation |
| Previous Message | Sriharsha | 2003-06-19 10:13:52 | Connection reset by peer problem |