Re: CURRENT_DATE and CURRENT_TIME return incorrect values

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CURRENT_DATE and CURRENT_TIME return incorrect values
Дата
Msg-id 10670.1054317223@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CURRENT_DATE and CURRENT_TIME return incorrect values  (valerian <valerian2@hotpop.com>)
Список pgsql-general
Дерево обсуждения 
valerian <valerian2@hotpop.com> writes:
> The only thing I can think of is that pgsql cached an old date and time,
> for some reason, and used that for the first record, and then actually
> queried the system's date/time after that.

Is it possible that the entry was made from a transaction that had been
sitting open for two days?  now() and related functions return
transaction start time.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: CURRENT_DATE and CURRENT_TIME return incorrect values
Следующее
От: greg@turnstep.com
Дата:
Сообщение: Re: fomatting an interval (resend)