Re: BUG #2198: Now returns always same date and time during a session

On Mon, Jan 23, 2006 at 11:40:43AM +0000, Jacques Gollion wrote:
> The following functions returns the first time the right date and time but
> when called at several date and time returns the date that was returned at
> the first call.

See "Current Date/Time" in the documentation:

http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

"It is important to know that CURRENT_TIMESTAMP and related functions
return the start time of the current transaction; their values do
not change during the transaction. This is considered a feature:
the intent is to allow a single transaction to have a consistent
notion of the 'current' time, so that multiple modifications within
the same transaction bear the same time stamp."

"There is also the function timeofday() which returns the wall-clock
time and advances during transactions."

> To get again the right date, it is necessary do disconnect and reconnect.

Do you have autocommit disabled? I'd guess all of your function
calls are happening in the same transaction. You shouldn't have
to reconnect; starting a new transaction should work.

--
Michael Fuhr