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

Started by Balaji.Sover 19 years ago3 messagesbugsgeneral
Jump to latest
#1Balaji.S
balajisundar@midascomm.com
bugsgeneral

The following bug has been logged online:

Bug reference: 2772
Logged by: S.Balaji
Email address: balajisundar@midascomm.com
PostgreSQL version: 7.4
Operating system: CentOS 4.4
Description: Undefined Subroutine Pg::connectdb (" ");
Details:

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

#2Bruno Wolff III
bruno@wolff.to
In reply to: Balaji.S (#1)
bugsgeneral
Re: BUG #2772: Undefined Subroutine Pg::connectdb (" ");

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.

#3Ragnar
gnari@hive.is
In reply to: Bruno Wolff III (#2)
bugsgeneral
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