Yes, and that's a feature :)
If you want a wall clock time, use timenow()
-alex
On Thu, 8 Feb 2001, Gregory Wood wrote:
> > 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
>
>
>
