Re: current_timestamp wrong - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: current_timestamp wrong
Date
Msg-id Pine.LNX.4.30.0108230031320.679-100000@peter.localdomain
Whole thread Raw
In response to current_timestamp wrong  (Peter Pilsl <pilsl@goldfisch.at>)
List pgsql-general
Peter Pilsl writes:

> In a bigger perl-project I had to hunt down a bug and it turned out that on
> very rare occassions the time delivered by 'current_timestamp'
> is wrong by a noticeable amount of time. (up to hours sometimes)

current_timestamp returns the time when the transaction started.  This is
wrong, but some developers seem to want to keep it that way.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: roypgsqlgen@xemaps.com
Date:
Subject: nested transactions
Next
From: will trillich
Date:
Subject: Re: Newbie: Solution?