| From: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>, PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to find transaction ID |
| Date: | 2013-08-08 14:20:27 |
| Message-ID: | 1375971627.86078.YahooMailNeo@web133204.mail.ir2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> From: "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>
> To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
> Cc: ascot(dot)moss(at)gmail(dot)com
> Sent: Thursday, 8 August 2013, 14:52
> Subject: [GENERAL] How to find transaction ID
>
> Hi,
>
> I am trying some restore tools, can you advise how to find the latest
> transaction ID in PostgreSQL and the transaction ID at a particular
> "Point-In-Time"?
>
Hmm, it's not clear entirely what you want. Afaik "select txid_current()" should get you the current transaction id. The column xmin for a row from any table will get you the inserting transaction id, and xmax will get you the deleting (or attempted delete) transaction id.
See http://www.postgresql.org/docs/9.0/static/functions-info.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dafNi zaf | 2013-08-08 14:33:33 | DB transactions when browser freezes |
| Previous Message | ascot.moss@gmail.com | 2013-08-08 13:52:05 | How to find transaction ID |