Thread

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

   S.Balaji <balajisundar@midascomm.com> — 2006-11-20T12:07:25Z

   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
   
   

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

   Bruno Wolff III <bruno@wolff.to> — 2006-11-22T19:28:42Z

   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.
   
   

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

   Ragnar <gnari@hive.is> — 2006-11-22T21:26:27Z

   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