Skip site navigation (1) Skip section navigation (2)

Re: Bug #801: now() in transaction

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: bhuvansql(at)myrealbox(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #801: now() in transaction
Date: 2002-10-18 13:06:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Fri, Oct 18, 2002 at 07:23:29 -0400,
  pgsql-bugs(at)postgresql(dot)org wrote:
> 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 LaneDate: 2002-10-18 13:27:34
Subject: Re: Pg 7.2.3 int8 value out of range
Previous:From: pgsql-bugsDate: 2002-10-18 11:23:29
Subject: Bug #801: now() in transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group