Help! Regarding Pg for posgreSQL

Discussion:

(too old to reply)

Sam Barnett-Cormack

2004-03-06 12:52:33 UTC

In my perl scripts, I have:

use DBI;
use DBD:Pg;

So maybe this is what you need?

Hi!
I came to ur e-mail address from one of the sites through google. Hope u
could help me please.
I am using red hat linux and running my perl programs with postgresql at
back end.
The follwing error occurs while using Pg.
--------------------------------------------
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .)
---------------------------------------------
Though on searching for Pg.pm it is found at the location
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/DBD/Pg.pm
If I copy it this Pg.pm file in
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/, it does not
give the above error but says connectdb() is an undefined subroutine.
Any help will be highly appreciated.
Regards
Thanks
##############################################################################
AMIT KUSH
Bioinformatics Centre (BIC)
Institute of Microbial Technology
CHANDIGARH - 160 036
INDIA
Phone : (0172) 2690279 (O)
Web : <www.kush.i8.com>, <www2.imtech.res.in/akush>
##############################################################################
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org

--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

VanderLeeden

2004-03-06 14:56:20 UTC

Permalink

Hi Amit,
you can check the pgperl Project -- pgperl
pgperl is a native Perl interface to PostgreSQL. It clearly follows libpq's
API.
HomePage= http://gborg.postgresql.org/project/pgperl/projdisplay.php
The most recent version is Pg-2.0.2 and if you install it on your node it
will provide Pg.pm.
A typical connect call served by this library looks like:
$masterConn = Pg::connectdb($connectString);
Good Luck!
Rudolf VanderLeeden

----- Original Message -----
From: "Amit Kush" <***@imtech.res.in>
To: <pgsql-***@postgresql.org>
Sent: Tuesday, March 02, 2004 12:00 AM
Subject: [ADMIN] Help! Regarding Pg for posgreSQL

############################################################################
##

AMIT KUSH
Bioinformatics Centre (BIC)
Institute of Microbial Technology
CHANDIGARH - 160 036
INDIA
Phone : (0172) 2690279 (O)
Web : <www.kush.i8.com>, <www2.imtech.res.in/akush>

############################################################################
##

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

Bruno Wolff III

2004-03-06 15:47:11 UTC

Permalink

On Sat, Mar 06, 2004 at 12:52:33 +0000,

Post by Sam Barnett-Cormack
use DBI;
use DBD:Pg;
So maybe this is what you need?

Pg.pm is an alternate perl module that is closer to libpq than DBD::Pg.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

Sam Barnett-Cormack

2004-03-06 18:32:24 UTC

Permalink

Post by Bruno Wolff III
On Sat, Mar 06, 2004 at 12:52:33 +0000,

Post by Sam Barnett-Cormack
use DBI;
use DBD:Pg;
So maybe this is what you need?

Pg.pm is an alternate perl module that is closer to libpq than DBD::Pg.

Well, that would explain why moving DBD/Pg.pm to the modules root didn't
help, wouldn't it?

--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)