Postgres Pro
Downloads
Home   >   mailing lists

Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: CURRENT_TIMESTAMP not work correctly insinde a transaction.
Date
Msg-id 3C76911E.35737258@fourpalms.org
Whole thread Raw
In response to CURRENT_TIMESTAMP not work correctly insinde a transaction.  ("Nicolas Paymal" <npaymal@instranet.com>)
Responses Re: CURRENT_TIMESTAMP not work correctly insinde a transaction.
List pgsql-bugs
Tree view 
> In a transaction until you commit your transaction through a jdbc
> connection, each time you use the Current_timestamp (or 'now'), the
> timestamps is always the same, and when your transaction is very long you
> have undesirable effect.

This is not a bug, but the behavior required by SQL9x afaicr.

There is another function (timeofday()?) which returns the current clock
time.

hth

                    - Thomas

pgsql-bugs by date:

Previous
From: "Nicolas Paymal"
Date:
Subject: CURRENT_TIMESTAMP not work correctly insinde a transaction.
Next
From: Peter Eisentraut
Date:
Subject: Re: CURRENT_TIMESTAMP not work correctly insinde a transaction.