Oh, I just made sure that I started a new transaction :)
I actually prefer that timestamps are handled that way... once I realized
*why* I had triggered INSERTs that were stamped 45 minutes earlier than I
thought they should have been.
Greg
> Yes, and that's a feature :)
>
> If you want a wall
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 fr
> 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 insid