Re: [GENERAL] 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.
Re: [GENERAL] Re: timestamp goober
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 > > >