Reply-To: <mykarz@miyabara.com>
From: "Michael Miyabara-McCaskey" <mykarz@miyabara.com>
To: "'turing2000'" <turing2000@mail.ru>
Cc: "Michael Miyabara-McCaskey (E-mail)" <mykarz@miyabara.com>,
	<pgsql-interfaces@postgresql.org>
Subject: Re: Plperl make fails with Error1 at plperl.o (7.0.3) 
Date: Mon, 18 Dec 2000 23:04:24 -0800
Message-ID: <001601c06989$ec353580$c700a8c0@ncc1701e>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: 7bit
In-reply-to: <003501c064f4$92e2aa60$430aa8c0@kmz>
Importance: Normal

Turing,

Thank you for the advice, the "pollute=1" was an important step, that Tom
Lane also helped me out with... it did get me past the error, however, I
then got...

>ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: shared object
not open

For your own notes, if it's ever an issue.  This second error was actually
caused by the "libperl.so" not being in the LD_LIBRARY_PATH.  With for me
was fixed by adding "/usr/local/bin" to my "/etc/ld.so.conf" file, and then
running ldconfig.

Thank you again for the help.

-Michael

> -----Original Message-----
> From: turing2000 [mailto:turing2000@mail.ru]
> Sent: Wednesday, December 13, 2000 3:05 AM
> To: mykarz@miyabara.com
> Subject: Re: Plperl make fails with Error1 at plperl.o (7.0.3)
>
>
> cd /usr/src/perl_package # go into YOU directory
> ./configure -Duseshrplib -des # --------------important step
> !! ----------------
> make
> make test
> make install
> # now you get perl with shared libperl.so
>
> cd /usr/src/postgres_package # go into YOU directory
> cd ./pl/plperl # I don't remember exactly directory name,
> verify by bash or
> file maneger
> perl Makefile.PL POLLUTE=1 # --------------important step
> !! ----------------
> make
>
> # while "create function", "create language" use exactly name
> "plperl_call_handler" as sed in pg documentation
>
>
> ----- Original Message -----
> From: Michael Miyabara-McCaskey <mykarz@miyabara.com>
> To: <pgsql-admin@postgresql.org>; <pgsql-interfaces@postgresql.org>
> Cc: 'turing2000' <turing2000@mail.ru>
> Sent: Monday, December 11, 2000 1:25 AM
> Subject: Plperl make fails with Error1 at plperl.o (7.0.3)
>
>
> > Hello all, I'm resending the message sent by "turing2000"
> on November
> 16th.
> >
> > Because I'm having the exact same problem.
> >
> > My configuration is as follows: RedHat 7.0, originally
> installed the RPM
> > version of PostgreSQL 7.0.2, then downloaded source and upgraded to
> 7.0.3...
> > Now that I've gotten further along in my project I have need of a
> Procedural
> > Language, and I figured PL/Perl would be easy...
> >
> > I have been mistaken... as it refuses to compile despite my
> best efforts.
> > The error below is EXACTLY the same as what I am getting.
> >
> > Any help would be appreciated.
> >
> > -Michael Miyabara-McCaskey
> >
> > > -----Original Message-----
> > > From: pgsql-admin-owner@postgresql.org
> > > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of turing2000
> > > Sent: Thursday, November 16, 2000 8:25 AM
> > > To: pgsql-admin@postgresql.org
> > > Subject: [ADMIN]
> > >
> > >
> > >
> > > Deal ( question ) consist of:
> > >
> > > [plperl]# make
> > > mkdir blib
> > > mkdir blib/lib
> > > mkdir blib/arch
> > > mkdir blib/arch/auto
> > > mkdir blib/arch/auto/plperl
> > > mkdir blib/lib/auto
> > > mkdir blib/lib/auto/plperl
> > > gcc -c -I../../../src/include -I../../../src/backend
> > > -fno-strict-aliasing -D_LARGEFILE_SOURCE
> > > -D_FILE_OFFSET_BITS=64 -O2     -DVERSION=\"0.10\"
> > > -DXS_VERSION=\"0.10\" -fpic
> > > -I/usr/local/perl/lib/5.6.0/i686-linux/CORE  plperl.c
> > > In file included from plperl.c:76:
> > > /usr/local/perl/lib/5.6.0/i686-linux/CORE/perl.h:467:
> > > warning: `USE_LOCALE' redefined
> > > ../../../src/include/config.h:214: warning: this is the
> > > location of the previous definition
> > > In file included from plperl.c:76:
> > > /usr/local/perl/lib/5.6.0/i686-linux/CORE/perl.h:2027:
> > > warning: `DEBUG' redefined
> > > ../../../src/include/utils/elog.h:22: warning: this is the
> > > location of the previous definition
> > > plperl.c: In function `plperl_create_sub':
> > > plperl.c:328: `errgv' undeclared (first use in this function)
> > > plperl.c:328: (Each undeclared identifier is reported only once
> > > plperl.c:328: for each function it appears in.)
> > > plperl.c:334: `na' undeclared (first use in this function)
> > > plperl.c: In function `plperl_call_perl_func':
> > > plperl.c:444: `errgv' undeclared (first use in this function)
> > > plperl.c:450: `na' undeclared (first use in this function)
> > > plperl.c: In function `plperl_func_handler':
> > > plperl.c:654: `na' undeclared (first use in this function)
> > > plperl.c: In function `plperl_build_tuple_argument':
> > > plperl.c:2192: `na' undeclared (first use in this function)
> > > make: *** [plperl.o] Error 1
> > > >
> > >
> > > What is that may be?
> > >
> > >   turing2000
> > >
> >
> >
>