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.
Seems that XMIN field is updated whenever a row is inserted or updated.
see man sql.
In response to
pgsql-hackers by date
|Next:||From: David Gould||Date: 1998-06-11 18:07:52|
|Subject: Re: [HACKERS] maximum of postgres ?|
|Previous:||From: Jose' Soares Da Silva||Date: 1998-06-11 10:15:56|
|Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs|