In article <[EMAIL PROTECTED]>,
Rafael Barrera Oro <[EMAIL PROTECTED]> wrote:

% Hello everyone! i am checking a database due to some inconsintencies and 
% i was wandering if its possible to find out the creation date of a 
% record (using the oid, whatever...). Maybe i am saying something stupid 
% (since i am no DB expert) so if this is the case, please point it out 
% gently.

Whatever: xmin, xmax

These give the range of transaction ids over which the data in a row are
valid. If xmin is 2, it means the change was made long enough ago that
vacuum has frozen it to avoid transaction wrap-around (or that you ran
vacuum freeze). Otherwise, the xmin can be compared to the xmin of some
table with a timestamp to get the approximate time the record was last
changed.
-- 

Patrick TJ McPhee
North York  Canada
[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to