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
