Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Timestamp field

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: Byron Nikolaidis <byronn(at)insightdist(dot)com>
Cc: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Timestamp field
Date: 1998-06-11 10:56:07
Message-ID: Pine.LNX.3.96.980611105440.3123A-100000@proxy (view raw or flat)
Thread:
Lists: 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'


In response to

pgsql-hackers by date

Next:From: David GouldDate: 1998-06-11 18:07:52
Subject: Re: [HACKERS] maximum of postgres ?
Previous:From: Jose' Soares Da SilvaDate: 1998-06-11 10:15:56
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group