Thread: Perl DBI Module fails to install correctly from RPM

Perl DBI Module fails to install correctly from RPM

From
pgsql-bugs@postgresql.org
Date:
Chris Carkner (almohada@hotmail.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Perl DBI Module fails to install correctly from RPM

Long Description
I installed version 7.1.2 from RPMs from your FTP site specifically with the following files (not necessarily in this
order):

postgresql-7.1.2-4PGDG.i386.rpm
postgresql-docs-7.1.2-4PGDG.i386.rpm
postgresql-libs-7.1.2-4PGDG.i386.rpm
postgresql-perl-7.1.2-4PGDG.i386.rpm
postgresql-server-7.1.2-4PGDG.i386.rpm

After copying the Pg.pm file to the appropriate DBD subdirectory (which it wasn't in with the rest of the drivers)
whichI assumed was the problem I tried to run a perl script which is trying to connect.  This script worked on Red Hat
6.2just fine, but when I tried to bring it to 7.1 and connect, I got the following (spelling errors and typos are not
mine):

DBD::Pg initialisation failed: Can't locate object method "driver" via package "DBD::Pg" at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pmline 511. 
Perhaps the capitalisation of DBD 'Pg' isn't right. at perlfile.pl line 141.

The line it is complaining about it a straight copy of the test.pl file contained with the module.  And yes, the
databasedoes exist, I double checked.  

I included the snippet of perl to which the above error belongs.

Sample Code
use DBI;
use Cwd;

$dir = cwd();

$connect_string = "dbi:Pg:dbname=foo";

my $dbh = DBI->connect($connect_string, '', '', {AutoCOmmit => 1})
          or die "Couldn't connect to database: " . DBI->errstr;

No file was uploaded with this report

Re: Perl DBI Module fails to install correctly from RPM

From
Peter Eisentraut
Date:
> Perl DBI Module fails to install correctly from RPM

We don't maintain or distribute the Perl DBI/DBD module.  Don't confuse it
with the Pg module in the PostgreSQL distribution, which is something
different.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter