Re: puzzling perl DBI vs psql problem

From: Rodrigo Gonzalez <rjgonzale(dot)lists(at)gmail(dot)com>
To: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>
Cc: Steve Atkins <steve(at)blighty(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: puzzling perl DBI vs psql problem
Date: 2014-03-13 20:54:31
Message-ID: 20140313175431.1c120b25@rjgonzale
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 13 Mar 2014 13:44:48 -0700
Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com> wrote:

> No, I don't have 2 instances running. I default the port on the psql
> command line, and the perl program is using 5432, as normal.
>
> Now, I'm discovering that syslog is no longer logging anything. I
> bounced it, but to no avail.

That is other problem....try changing pgsql to use stderr (or fix
syslog of course)...then check both queries again and see the
differences...

Other good point by other user is that maybe you are using persistent
connections from apache and it is using an old snapshot?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2014-03-13 20:55:28 Re: puzzling perl DBI vs psql problem
Previous Message Dennis Jenkins 2014-03-13 20:53:58 Re: puzzling perl DBI vs psql problem