Subject: DBI connect returning an empty hash
From: Scott Cain <cain@cshl.edu>
To: pgsql-interfaces@postgresql.org
Content-Type: text/plain
Date: Thu, 06 Apr 2006 12:34:22 -0400
Message-Id: <1144341262.28535.162.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

Hi all,

I am developing a perl module that, when it is created, establishes a
DBI connection to my postgresql database.  The problem I am having is
that when I issue a DBI->connect command, the database handle it returns
is empty (Data::Dumper shows it as an empty hash).  Here is my code:

sub new {
    my $class = shift;
    my %arg   = @_;

    my $self  = bless {}, ref($class) || $class;


    my $dbname = $arg{dbname};
    my $dbport = $arg{dbport};
    my $dbhost = $arg{dbhost};
    my $dbuser = $arg{dbuser};
    my $dbpass = $arg{dbpass};
    my $notrans= $arg{notransact};

    warn $dbname,$dbport,$dbhost;
    warn $dbuser,$notrans;

    my $dbh = DBI->connect(
        "dbi:Pg:dbname=$dbname;port=$dbport;host=$dbhost",
        $dbuser,
        $dbpass,
        {AutoCommit => $notrans,
         TraceLevel => 4}
    ) or die;

    warn Dumper($dbh);

    ...etc...

The trace output doesn't show anything strange, and DBI.pm at least
seems to think things went OK, because it doesn't `die` on that line.

I wrote a simple test script that does exactly the same thing, and it
works.  Does anyone have any suggestions for what might be going on
here?

Thanks,
Scott

-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                         cain@cshl.edu
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory