Help! Regarding Pg for posgreSQL
Help! Regarding Pg for posgreSQL
От:
Amit Kush <akush@imtech.res.in>
Дата:
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. -------------------------------------------- Can't locate Pg.pm in @INC (@INC contains: /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) E-mail: , , Web : , ##############################################################################
Re: Help! Regarding Pg for posgreSQL
От:
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Дата:
In my perl scripts, I have: use DBI; use DBD:Pg; So maybe this is what you need? On Mon, 1 Mar 2004, Amit Kush wrote: > 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. > > -------------------------------------------- > Can't locate Pg.pm in @INC (@INC contains: > /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) > E-mail: , > , > Web : , > > ############################################################################## > > > > ---------------------------(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
Re: Help! Regarding Pg for posgreSQL
От:
"VanderLeeden" <vanderleeden@logicunited.com>
Дата:
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"
To:
Sent: Tuesday, March 02, 2004 12:00 AM
Subject: [ADMIN] Help! Regarding Pg for posgreSQL
> 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.
>
> --------------------------------------------
> Can't locate Pg.pm in @INC (@INC contains:
> /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)
> E-mail: ,
> ,
> Web : ,
>
>
############################################################################
##
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Re: Help! Regarding Pg for posgreSQL
От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Sat, Mar 06, 2004 at 12:52:33 +0000, Sam Barnett-Cormack wrote: > In my perl scripts, I have: > > 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.
Re: Help! Regarding Pg for posgreSQL
От:
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Дата:
On Sat, 6 Mar 2004, Bruno Wolff III wrote: > On Sat, Mar 06, 2004 at 12:52:33 +0000, > Sam Barnett-Cormack wrote: > > In my perl scripts, I have: > > > > 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
Re: Help! Regarding Pg for posgreSQL
От:
Amit Kush <akush@imtech.res.in>
Дата:
Thanks a lot to all of you. Downloaded and installed Pg-2.0.2. The problem was rectified. Thanks again. Amit On Sat, 6 Mar 2004, Sam Barnett-Cormack wrote: > In my perl scripts, I have: > > use DBI; > use DBD:Pg; > > So maybe this is what you need? > > On Mon, 1 Mar 2004, Amit Kush wrote: > > > 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. > > > > -------------------------------------------- > > Can't locate Pg.pm in @INC (@INC contains: > > /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) > > E-mail: , > > , > > Web : , > > > > ############################################################################## > > > > > > > > ---------------------------(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 > ############################################################################## AMIT KUSH Bioinformatics Centre (BIC) Institute of Microbial Technology CHANDIGARH - 160 036 INDIA Phone : (0172) 2690279 (O) E-mail: , , Web : , ##############################################################################