Re: Timestamp of insertion of the row.

Поиск
Список
Период
Сортировка
От Mendola Gaetano
Тема Re: Timestamp of insertion of the row.
Дата
Msg-id 002601c33130$6febee30$10d4a8c0@mm.eutelsat.org
обсуждение исходный текст
Ответ на Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
Ответы Re: Timestamp of insertion of the row.  (Bruno Wolff III <bruno@wolff.to>)
Список 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 по дате отправления:

Предыдущее
От: argosz@fw.hu
Дата:
Сообщение: Data recovery - URGENT
Следующее
От: "Ramesh PAtel "
Дата:
Сообщение: Add user on old database with password