Re: timestamp goober - Mailing list pgsql-general

From Gregory Wood
Subject Re: timestamp goober
Date
Msg-id 002a01c091ec$8bffcb40$7889ffcc@comstock.com
Whole thread Raw
In response to timestamp goober  (Culley Harrelson <culleyharrelson@yahoo.com>)
Responses Re: Re: timestamp goober  (Alex Pilosov <alex@pilosoft.com>)
List 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 by date:

Previous
From: Culley Harrelson
Date:
Subject: timestamp goober
Next
From: Brice Ruth
Date:
Subject: Re: Query never returns ...