Re: Issue with now() within a transaction in pg74.213.jdbc.jar

From: Kris Jurka <books(at)ejurka(dot)com>
To: John Pagakis <thebfh(at)toolsmythe(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Issue with now() within a transaction in pg74.213.jdbc.jar
Date: 2004-07-01 23:57:57
Message-ID: Pine.BSO.4.56.0407011856190.3674@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 1 Jul 2004, John Pagakis wrote:

> Most of my tables have a last update date and during some testing in
> Postgres 7.4.1 I noticed that the last_update date was slightly in the past
> for anything updated within a transaction. The amount it is off by seems to
> vary: as little as 30 seconds; as much as a couple of minutes.
>

This is not a JDBC issue. now() always returns the time from the start of
the transaction. If you want current wall clock time use timeofday().

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-07-02 00:30:36 Re: Issue with now() within a transaction in
Previous Message John Pagakis 2004-07-01 21:47:02 Issue with now() within a transaction in pg74.213.jdbc.jar