Re: Re: timestamp goober

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 clock time, use timenow()

> > 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.