Re: CURRENT_TIMESTAMP not work correctly insinde a transaction.

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Nicolas Paymal <npaymal(at)instranet(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: CURRENT_TIMESTAMP not work correctly insinde a transaction.
Date: 2002-02-22 18:42:38
Message-ID: 3C76911E.35737258@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2002-02-22 22:04:44 Re: CURRENT_TIMESTAMP not work correctly insinde a transaction.
Previous Message Tom Lane 2002-02-22 15:59:37 Re: Patch pgsql-7.2 AuthBlockSig