Error in Installing pgsql_perl5 - Mailing list pgsql-interfaces

From Sitaram_Pamarthi
Subject Error in Installing pgsql_perl5
Date
Msg-id 27B993528DFED411956700B0D0AA8C950DFCE8DF@hot.satyam.com
Whole thread Raw
List pgsql-interfaces
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I am getting a problem while installing the module <b><span
style="font-weight:bold">pgsql_perl5</span></b></span></font><pclass="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Please find the information that you requested.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">[root@teacup /]# <b><span style="font-weight:bold">perl -v</span></b></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">This is perl, v5.8.0 built for i386-linux-thread-multi</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">(with 1 registered patch, see perl -V for more detail)</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Copyright 1987-2002, Larry Wall</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Perl may be copied only under the terms of either the Artistic License or the</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">GNU General Public License, which may be found in the Perl 5 source kit.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Complete documentation for Perl, including FAQ lists, should be found on</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">this system using `man perl' or `perldoc perl'.  If you have access to the</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Internet, point your browser at http://www.perl.com/, the Perl Home Page.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">[root@teacup /]# <b><span style="font-weight:bold">perl -V</span></b></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">  Platform:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    osname=linux, osvers=2.4.20-2.48smp, archname=i386-linux-thread-multi</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    uname='linux str'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    config_args='-des -Doptimize=-O2 -march=i386 -mcpu=i686 -g -Dmyhostname=localhost
-Dperladmin=root@localhost-Dcc=gcc -Dcf_by=Red Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
-Dvendorprefix=/usr-Dsiteprefix=/usr -Dotherlibdirs=/usr/lib/perl5/5.8.0 -Duseshrplib -Dusethreads -Duseithreads
-Duselargefiles-Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio
-Dinstallusrbinperl-Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr'</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    hint=recommended, useposix=true, d_sigaction=define</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    usethreads=define use5005threads=undef'</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> useithreads=define usemultiplicity=</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">    useperlio= d_sfio=undef uselargefiles=define usesocks=undef</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    use64bitint=undef use64bitall=un uselongdouble=</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    usemymalloc=, bincompat5005=undef</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">  Compiler:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
-fno-strict-aliasing-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm',</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    optimize='',</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing
-I/usr/local/include-I/usr/include/gdbm'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    ccversion='', gccversion='3.2.2 20030213 (Red Hat Linux 8.0 3.2.2-1)',
gccosandvers=''</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">gccversion='3.2.2 200302'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    intsize=e, longsize= , ptrsize=p, doublesize=8, byteorder=1234</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    ivtype='long'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">k', ivsize=4'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">ivtype='long'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">known_ext, nvtype='double'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">o_nonbl', nvsize=, Off_t='', lseeksize=8</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">    alignbytes=4, prototype=define</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">  Linker and Libraries:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    ld='gcc'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">l', ldflags =' -L/usr/local/lib'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">ldf'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">    libpth=/usr/local/lib /lib /usr/lib</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">    libs=-lnsl -lgdbm -ldb -ldl -lm -lpthread -lc -lcrypt -lutil</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    perllibs=</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    libc=/lib/libc-2.3.1.so, so=so, useshrplib=true, libperl=libper</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">    gnulibc_version='2.3.1'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">  Dynamic Linking:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    dlsrc=dl_dlopen.xs, dlext=so', d_dlsymun=undef, ccdlflags='-rdynamic
-Wl,-rpath,/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE'</span></font><pclass="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">    cccdlflags='-fPIC'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">ccdlflags='-rdynamic -Wl,-rpath,/usr/lib/perl5', lddlflags='s Unicode/Normalize
XS/A'</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Characteristics of this binary (from libperl): </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">  Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">  Locally applied patches:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">        MAINT18379</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">  Built under linux</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">  Compiled at Feb 18 2003 22:19:53</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">  @INC:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">    /usr/lib/perl5/5.8.0/i386-linux-thread-multi</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    /usr/lib/perl5/5.8.0</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    /usr/lib/perl5/site_perl/5.8.0</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">    /usr/lib/perl5/site_perl</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    /usr/lib/perl5/vendor_perl/5.8.0</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">    /usr/lib/perl5/vendor_perl</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    /usr/lib/perl5/5.8.0/i386-linux-thread-multi</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">    /usr/lib/perl5/5.8.0</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    .</span></font><p class="MsoNormal"><b><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial;font-weight:bold">POSTGRESQL</span></font></b><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">:  <b><span
style="font-weight:bold">postgresql-7.3.6.tar.gz</span></b></span></font><pclass="MsoNormal"><b><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial;font-weight:bold">Pgsql_perl5: pgsql_perl5-1.9.0.tar.gz</span></font></b><p
class="MsoNormal"><b><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial;font-weight:bold">And when I am trying to run the Makefile.PL of pgsql_perl5, I am getting the
followingerror</span></font></b><p class="MsoNormal"><b><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">[root@teacup pgsql_perl5-1.9.0]# perl Makefile.PL</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">Configuring Pg</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Remember to actually read the README file !</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">[root@teacup pgsql_perl5-1.9.0]#</span></font><p class="MsoNormal"><b><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial;font-weight:bold">Request you to resolve my problem ASAP.</span></font></b><p
class="MsoNormal"><b><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><em><i><font face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt">Thanks and Regards,</span></font></i></em><p class="MsoNormal"><em><b><i><font
face="TimesNew Roman" size="3"><span style="font-size:12.0pt;font-weight:bold">Sitaram
Pamarthi</span></font></i></b></em><pclass="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font></div><p><font face="Arial"
size="2">**************************************************************************</font><p><font face="Arial"
size="2">Thisemail (including any attachments) is intended for the sole use of the intended recipient/s and may contain
materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the
intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is
appreciated.</font><p><fontface="Arial"
size="2">**************************************************************************</font>

pgsql-interfaces by date:

Previous
From: Rich Cullingford
Date:
Subject: Re: Problems creating indexes with IMMUTABLE functions
Next
From: L J Bayuk
Date:
Subject: Released updated Tcl interfaces: pgin.tcl-2.1.0, pgtclng-1.5.1