Re: a: queries across databases b: plperl

I did make deinstall, make clean, then make and captured output to
file.  createlang still bombed.  Here's the relevant lines.

Thanks again,
Wayne

===>  Building for p5-postgresql-plperl-7.3.3
gmake: Entering directory
`/usr/ports/databases/p5-postgresql-plperl/work/postgresql-7.3.3/src/pl/plperl'
cc -O -pipe -fpic -DPIC -I. -I/usr/local/lib/perl5/5.8.0/mach/CORE
-I../../../src/include   -c -o plperl.o plperl.c
cc -O -pipe -fpic -DPIC -I. -I/usr/local/lib/perl5/5.8.0/mach/CORE
-I../../../src/include   -c -o eloglvl.o eloglvl.c
/usr/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.0/ExtUtils/typemap SPI.xs >SPI.c
cc -O -pipe -fpic -DPIC -I. -I/usr/local/lib/perl5/5.8.0/mach/CORE
-I../../../src/include   -c -o SPI.o SPI.c
ar cr libplperl.a `lorder plperl.o eloglvl.o SPI.o | tsort`
ranlib libplperl.a
cc -O -pipe -fpic -DPIC -shared -Wl,-x,-soname,libplperl.so.0 plperl.o
eloglvl.o SPI.o  -pthread -Wl,-E  -L/usr/local/lib
/usr/local/lib/perl5/5.8.0/mach/auto/DynaLoader/DynaLoader.a
-L/usr/local/lib/perl5/5.8.0/mach/CORE -lperl -lm -lc_r -lcrypt -lutil
-R/usr/local/lib -o libplperl.so.0
rm -f libplperl.so
ln -s libplperl.so.0 libplperl.so
gmake: Leaving directory
`/usr/ports/databases/p5-postgresql-plperl/work/postgresql-7.3.3/src/pl/plperl'

On Sun, 2003-08-17 at 18:59, Tom Lane wrote:
> "Wayne M. Syvinski" <matthew@techcelsior.com> writes:
> > Compiled PostgreSQL 7.3.3. from ports. I didn't know that shared
> > libraries were required from Perl to use plperl.
>
> > So I recompiled Perl 5.8.0 from ports - amended Makefile to allow
> > threads and shared libraries
> > (-Dusethreads=y -Duseithreads=y -Duseshrplib=y) (I enabled threads
> > because I needed them to try something in MySQL)
>
> > Then I compiled plperl from ports.
>
> > I logged in as root and su to pgsql (postgres user) and type:
>
> > CREATE FUNCTION plperl_call_handler() RETURNS opaque AS
> > '/usr/local/lib/postgresql/plperl.so' LANGUAGE 'C';
>
> > This didn't work. I get back <deletia> Undefined symbol
> > "Perl_sv_2pv_flags".
>
> I'm wondering whether you compiled plperl against the Perl include files
> that match the Perl library you were using.  This is an easy mistake to
> make if you build/install Perl in a nonstandard place (and "the standard
> place" isn't very well-defined, either).  Check the -I arguments that
> were used at compile time for plperl, and check the dynamic link search
> path used at runtime.
>
>             regards, tom lane
>
>