> From: Glyn Astill <glynast...@yahoo.co.uk>
> To: "ascot.m...@gmail.com" <ascot.m...@gmail.com>; PostgreSQL general 
> <pgsql-general@postgresql.org>
> Cc: 
> Sent: Thursday, 8 August 2013, 15:20
> Subject: Re: [GENERAL] How to find transaction ID
> 
> 
> 
>>  From: "ascot.m...@gmail.com" <ascot.m...@gmail.com>
>>  To: PostgreSQL general <pgsql-general@postgresql.org>
>>  Cc: ascot.m...@gmail.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.



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to