Postgres Pro
Downloads
Home   >   mailing lists

Re: puzzling perl DBI vs psql problem - Mailing list pgsql-general

From Susan Cassidy
Subject Re: puzzling perl DBI vs psql problem
Date
Msg-id CAE3Q8okwDjJd3tA4LMqyKOrmXmOZqCFT9TyiH4a1ZK9n8i-iJA@mail.gmail.com
Whole thread Raw
In response to Re: puzzling perl DBI vs psql problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
No, I am connecting to the right database, as my log info shows.  No duplicate table names, except in different databases.  Those tables show all the data I expect, oddly enough, if I connect the perl program to that database.  It is only this database that is giving me trouble.  Which is another oddity.  The identical test database is working fine.  Only this database is giving me trouble.  Naturally the "live" database is causing problems.

Susan


On Thu, Mar 13, 2014 at 12:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Susan Cassidy <susan.cassidy@decisionsciencescorp.com> writes:
> I have a weird issue that I can't figure out.
> If I run the exact same query through psql as through perl DBI, I get
> different results.  I get far fewer results with DBI than through the psql
> command line.

Any possibility that the perl program is connecting to a different
database, with similar-but-not-identical data in it?

I've seen variants on that theme involving different users with different
search_path settings finding different-but-similarly-named tables in
different schemas of the same database.

                        regards, tom lane

pgsql-general by date:

Previous
From: Susan Cassidy
Date:
Subject: Re: puzzling perl DBI vs psql problem
Next
From: Steve Atkins
Date:
Subject: Re: puzzling perl DBI vs psql problem