Re: [HACKERS] Timestamp field - Mailing list pgsql-hackers

From Jose' Soares Da Silva
Subject Re: [HACKERS] Timestamp field
Date
Msg-id Pine.LNX.3.96.980611105440.3123A-100000@proxy
Whole thread Raw
In response to Timestamp field  (Byron Nikolaidis <byronn@insightdist.com>)
List pgsql-hackers
On Wed, 10 Jun 1998, Byron Nikolaidis wrote:

> Am I right in my thinking that Postgres does not have a pseudo timestamp
> field that is updated whenever a row is added or updated?   Did it used
> to have one before time travel was removed?
>
> If no timestamp field, are there any other pseudo fields that are
> updated every time?  I noticed that the 'ctid' field seems to qualify,
> but what does something like (1,54) mean?
>
> Thanks for any help.
>
> Byron

Seems that XMIN field is updated whenever a row is inserted or updated.
see man sql.
                                                            Jose'


pgsql-hackers by date:

Previous
From: Peter Mount
Date:
Subject: Re: FW: [HACKERS] now 6.4
Next
From: dg@illustra.com (David Gould)
Date:
Subject: Re: [HACKERS] maximum of postgres ?