In article <44F6C908.9080908@xxxxxxxxxxxxxxxxxxxxx>, Rafael Barrera Oro <rbarrera@xxxxxxxxxxxxxxxxxxxxx> 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 ptjm@xxxxxxxxxxxx
