Re: Timestamp of insertion of the row. - Mailing list pgsql-admin

From Mendola Gaetano
Subject Re: Timestamp of insertion of the row.
Date
Msg-id 002601c33130$6febee30$10d4a8c0@mm.eutelsat.org
Whole thread Raw
In response to Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
Responses Re: Timestamp of insertion of the row.  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
"Henry House" <hajhouse@houseag.uce-not-wanted-here.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





pgsql-admin by date:

Previous
From: argosz@fw.hu
Date:
Subject: Data recovery - URGENT
Next
From: "Ramesh PAtel "
Date:
Subject: Add user on old database with password