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

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