On Fri, Oct 18, 2002 at 07:23:29 -0400,
> Bhuvan A (bhuvansql(at)myrealbox(dot)com) reports a bug with a severity of 2
> The lower the number the more severe it is.
> Short Description
> now() in transaction
> Long Description
> I am using 7.2.1. now() returns same value ever, within transaction. If we use now() say 10 times in the same transaction, all 10 times we are getting the same value, irrespect of the interval. 7.2 too behaves similar.
This is how it is supposed to work. If you need the current time, rather
than transaction start time, use timeofday().
This is covered in the documentation.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-10-18 13:27:34|
|Subject: Re: Pg 7.2.3 int8 value out of range |
|Previous:||From: pgsql-bugs||Date: 2002-10-18 11:23:29|
|Subject: Bug #801: now() in transaction|