Re: timestamp goober

Поиск
Список
Период
Сортировка
От Gregory Wood
Тема Re: timestamp goober
Дата
Msg-id 002a01c091ec$8bffcb40$7889ffcc@comstock.com
обсуждение исходный текст
Ответ на timestamp goober  (Culley Harrelson <culleyharrelson@yahoo.com>)
Ответы Re: Re: timestamp goober  (Alex Pilosov <alex@pilosoft.com>)
Список pgsql-general
> columns with default timestamp('now') see to be
> defaulting to the time I started posgresql!

I noticed that timestamps (in my case CURRENT_TIMESTAMP) are taken from the
beginning of a transaction. You didn't mention how you were accessing the
database, but if you were updating everything inside the same transaction,
everything would be timestamped with the time that transaction began.

Greg



В списке pgsql-general по дате отправления:

Предыдущее
От: Culley Harrelson
Дата:
Сообщение: timestamp goober
Следующее
От: Brice Ruth
Дата:
Сообщение: Re: Query never returns ...