Обсуждение: 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: <amitkush@yahoo.com>, <amitkush@rediffmail.com> <amitkush@datainfosys.net>, <akush@imtech.res.in> Web : <www.kush.i8.com>, <www2.imtech.res.in/akush> ##############################################################################
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: <amitkush@yahoo.com>, <amitkush@rediffmail.com> > <amitkush@datainfosys.net>, <akush@imtech.res.in> > 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
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" <akush@imtech.res.in> To: <pgsql-admin@postgresql.org> 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: <amitkush@yahoo.com>, <amitkush@rediffmail.com> > <amitkush@datainfosys.net>, <akush@imtech.res.in> > 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 >
On Sat, Mar 06, 2004 at 12:52:33 +0000, Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk> 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.
On Sat, 6 Mar 2004, Bruno Wolff III wrote: > On Sat, Mar 06, 2004 at 12:52:33 +0000, > Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk> 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
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: <amitkush@yahoo.com>, <amitkush@rediffmail.com> > > <amitkush@datainfosys.net>, <akush@imtech.res.in> > > 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 > ############################################################################## AMIT KUSH Bioinformatics Centre (BIC) Institute of Microbial Technology CHANDIGARH - 160 036 INDIA Phone : (0172) 2690279 (O) E-mail: <amitkush@yahoo.com>, <amitkush@rediffmail.com> <amitkush@datainfosys.net>, <akush@imtech.res.in> Web : <www.kush.i8.com>, <www2.imtech.res.in/akush> ##############################################################################