Thread: Re: BUG #2772: Undefined Subroutine Pg::connectdb (" ");

Re: BUG #2772: Undefined Subroutine Pg::connectdb (" ");

From
Bruno Wolff III
Date:
This isn't a bug and you should have asked on a different list. I am going
to move this over to pgsql-general.

On Mon, Nov 20, 2006 at 12:07:25 +0000,
  "S.Balaji" <balajisundar@midascomm.com> wrote:
>
> In Redhat 7.2 use Pg; command in perl Scripts will working with out any
> Problem.But in CentOS use Pg command will not Working it shows error is
> cannot Locate Pg.pm in Include Directory.After I am Solved this Problem by
> export PERLLIB=/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/DBD/
> command.After it shows error is undefined subroutine Pg::connectdb
> command.how can i solve this Problem without changing the use Pg command or
> any other equivalent command is there.Please help me to solve this Problem

The Pg perl module is not getting much support, but you can get a copy of
the source from ftp://gborg.postgresql.org/pub/pgperl/stable/Pg-2.1.1.tar.gz
and build it yourself.

Re: BUG #2772: Undefined Subroutine Pg::connectdb (" ");

From
Ragnar
Date:
On mið, 2006-11-22 at 13:28 -0600, Bruno Wolff III wrote:
> This isn't a bug and you should have asked on a different list. I am going
> to move this over to pgsql-general.
>
> On Mon, Nov 20, 2006 at 12:07:25 +0000,
>   "S.Balaji" <balajisundar@midascomm.com> wrote:
> >
> > In Redhat 7.2 use Pg; command in perl Scripts will working with out any
> > Problem.But in CentOS use Pg command will not Working it shows error is
> > cannot Locate Pg.pm in Include Directory.

this probably means that the package containing the
old Pg module has not been installed. have you checked
if such a CentOS package exists ?

for example in debian, this modules comes with the
package libpg-perl

> After I am Solved this Problem by
> > export PERLLIB=/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/DBD/
> > command.

this certainly does not Solve any problem, as this would fool perl into
loading the module DBD::Pg instead of Pg.

you should not do this, as this may well interfere with
the operation of the correct Pg module if you manage to
install it from a rpm ,or by source as suggested by
Bruno below.

> After it shows error is undefined subroutine Pg::connectdb

unfortunately DBD::Pg does not define connectdb()  :-)
> > command.how can i solve this Problem without changing the use Pg command or
> > any other equivalent command is there.Please help me to solve this Problem
>
> The Pg perl module is not getting much support, but you can get a copy of
> the source from ftp://gborg.postgresql.org/pub/pgperl/stable/Pg-2.1.1.tar.gz
> and build it yourself.

yep

gnari