Re: Timestamp of insertion of the row.

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: "Henry House" <hajhouse(at)houseag(dot)uce-not-wanted-here(dot)com>, "Anagha Joshi" <ajoshi(at)nulinkinc(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timestamp of insertion of the row.
Date: 2003-06-12 22:17:38
Message-ID: 002601c33130$6febee30$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Henry House" <hajhouse(at)houseag(dot)uce-not-wanted-here(dot)com> wrote:
> Yes. Easy answer: use a column of type 'timestamp default now()'.

With that default value you store the time
stamp of transaction where the row was inserted. Immagine to insert
inside the same transaction a lot of rows and this operation will take long
1 minute, you'll have all rows with the same time stamp instead of time
stamp spreaded inside that minute, use timeofday instead.

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ramesh PAtel 2003-06-13 05:18:45 Add user on old database with password
Previous Message argosz 2003-06-12 20:50:35 Data recovery - URGENT