"Clark Pearson" <cloink_friggson@ntlworld.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
