pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp! Regarding Pg for posgreSQL
6+ messages / 4 participants
[nested] [flat]
* Help! Regarding Pg for posgreSQL
@ 2004-03-01 23:00 Amit Kush <akush@imtech.res.in>
0 siblings, 2 replies; 6+ messages in thread
From: Amit Kush @ 2004-03-01 23:00 UTC (permalink / raw)
To: pgsql-admin
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>
##############################################################################
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help! Regarding Pg for posgreSQL
@ 2004-03-06 12:52 Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
parent: Amit Kush <akush@imtech.res.in>
1 sibling, 2 replies; 6+ messages in thread
From: Sam Barnett-Cormack @ 2004-03-06 12:52 UTC (permalink / raw)
To: Amit Kush <akush@imtech.res.in>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help! Regarding Pg for posgreSQL
@ 2004-03-06 14:56 VanderLeeden <vanderleeden@logicunited.com>
parent: Amit Kush <akush@imtech.res.in>
1 sibling, 0 replies; 6+ messages in thread
From: VanderLeeden @ 2004-03-06 14:56 UTC (permalink / raw)
To: Amit Kush <akush@imtech.res.in>; pgsql-admin; +Cc: rvdl <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" <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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help! Regarding Pg for posgreSQL
@ 2004-03-06 15:47 Bruno Wolff III <bruno@wolff.to>
parent: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
1 sibling, 1 reply; 6+ messages in thread
From: Bruno Wolff III @ 2004-03-06 15:47 UTC (permalink / raw)
To: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>; +Cc: Amit Kush <akush@imtech.res.in>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help! Regarding Pg for posgreSQL
@ 2004-03-06 18:32 Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 6+ messages in thread
From: Sam Barnett-Cormack @ 2004-03-06 18:32 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>; Amit Kush <akush@imtech.res.in>; pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help! Regarding Pg for posgreSQL
@ 2004-03-08 10:12 Amit Kush <akush@imtech.res.in>
parent: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
1 sibling, 0 replies; 6+ messages in thread
From: Amit Kush @ 2004-03-08 10:12 UTC (permalink / raw)
To: Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>; +Cc: pgsql-admin
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>
##############################################################################
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-03-08 10:12 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-01 23:00 Help! Regarding Pg for posgreSQL Amit Kush <akush@imtech.res.in>
2004-03-06 12:52 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-03-06 15:47 ` Bruno Wolff III <bruno@wolff.to>
2004-03-06 18:32 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-03-08 10:12 ` Amit Kush <akush@imtech.res.in>
2004-03-06 14:56 ` VanderLeeden <vanderleeden@logicunited.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox