Thread: Help! Regarding Pg for posgreSQL

Help! Regarding Pg for posgreSQL

From
Amit Kush
Date:
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>

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



Re: Help! Regarding Pg for posgreSQL

From
Sam Barnett-Cormack
Date:
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

Re: Help! Regarding Pg for posgreSQL

From
"VanderLeeden"
Date:
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
>


Re: Help! Regarding Pg for posgreSQL

From
Bruno Wolff III
Date:
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.

Re: Help! Regarding Pg for posgreSQL

From
Sam Barnett-Cormack
Date:
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

Re: Help! Regarding Pg for posgreSQL

From
Amit Kush
Date:
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>

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