Re: BUG #5191: now() returns same value from Perl.

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: BUG #5191: now() returns same value from Perl.
Дата
Msg-id
6268.1258404863@sss.pgh.pa.us
Ответ на
BUG #5191: now() returns same value from Perl. (Clark Pearson)
Список
Дерево обсуждения
BUG #5191: now() returns same value from Perl. "Clark Pearson" <cloink_friggson@ntlworld.com>
Re: BUG #5191: now() returns same value from Perl. Robert Haas <robertmhaas@gmail.com>
Re: BUG #5191: now() returns same value from Perl. Tom Lane <tgl@sss.pgh.pa.us> 
"Clark Pearson"  writes:
> If I 'SELECT now()' repeatedly from a perl script connected to the database
> via DBD::Pg, the returned value does not get updated to the new system
> time.

This is the correct behavior if you're inside the same transaction all
along, which is to be expected if you set autocommit off and then don't
issue any commits.  now() is defined as transaction start time.

			regards, tom lane
В списке pgsql-bugs по дате отправления
Предыдущее
От: Robert Haas
Дата:
Следующее
От: Tom Lane
Дата:
FAQ