Re: connect from perl: error in Carp.pm - Mailing list pgsql-novice

From Brad Nicholson
Subject Re: connect from perl: error in Carp.pm
Date
Msg-id 427B9454.5060701@ca.afilias.info
Whole thread Raw
In response to Re: connect from perl: error in Carp.pm  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-novice
Greg Sabino Mullane wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>
>
>
>>When I try to connect as following, I get an error in Carp.pm:
>>
>>$dbh = DBI->connect("DBI:Pg:dbname=my_db", $username, $password,{AutoCommit
>>=> 1, RaiseError => }) || die "Unable to connect to database $DBI::errstr";
>>
>>=> Not a CODE reference at /usr/lib/perl5/5.8.3/Carp.pm line 178.
>>
>>
>
>
>
>>Maybe there are some right issue; I installed DBI and DBD as root, I'm
>>calling the script as root, but postgres runs under its own user.
>>
>>
>
>I doubt that's it, but I am not sure what is going on. Can you tell us more
>about the circumstances: is this a standalone script. Perhaps an Apache
>cgi script? What version of DBI, DBD::Pg, PostgreSQL, and (if applicable)
>Apache?
>
>

I'm going to go out on a limb here and guess that the problem is the
missing value for RaiseError in your connect statement.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Execute function without execute privilege
Next
From: "Keith Worthington"
Date:
Subject: returned row number