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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Clark Pearson" <cloink_friggson(at)ntlworld(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5191: now() returns same value from Perl.
Date: 2009-11-16 20:54:23
Message-ID: 6268.1258404863@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Clark Pearson" <cloink_friggson(at)ntlworld(dot)com> 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-11-16 20:59:18 Re: BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior
Previous Message Robert Haas 2009-11-16 20:50:24 Re: BUG #5191: now() returns same value from Perl.