From: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
---|---|
To: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, "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:36:38 |
Message-ID: | 1375972598.43915.YahooMailNeo@web133205.mail.ir2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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>
> Cc:
> Sent: Thursday, 8 August 2013, 15:20
> Subject: Re: [GENERAL] How to find transaction ID
>
>
>
>> 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
>
I guess I shouldn't have said that about xmin and xmax; you can't rely on those columns in various circumstances i.e. after a vacuum.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-08-08 14:40:14 | Re: DB transactions when browser freezes |
Previous Message | dafNi zaf | 2013-08-08 14:33:33 | DB transactions when browser freezes |