From: | Christopher Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is xmin ? |
Date: | 2005-01-18 18:16:55 |
Message-ID: | m38y6q38mg.fsf@knuth.knuth.cbbrowne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In an attempt to throw the authorities off his trail, antonypaul24(at)gmail(dot)com (Antony Paul) transmitted:
> I read about xmin in a thread on optimistic concurrency control.
> Can you guys tell me how to interpret this value. I want to convert
> this to date format. Is it possible ?
xmin is a transaction ID number. There is no such conversion
possible.
http://www.faqs.org/docs/ppbook/x4636.htm
It would be kind of neat if there were some table into which
transactions were logged; in that case, there would presumably be a
couple of timestamps, namely the time at which the transaction began
and the time at which the transaction ended. There is no such table
by default.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www.ntlug.org/~cbbrowne/languages.html
We are in fact well and truly doomed.
-- Jamie Zawinski http://www.jwz.org/gruntle/nscpdorm.html
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Witney | 2005-01-18 18:23:23 | Backup strategy |
Previous Message | alexandre::aldeia digital | 2005-01-18 17:36:37 | Re: Error al Subir base de datos |