RE: PL/Perl in 7.1.1

Thanks for the helpful replies. Following Tom's suggestion, I upgraded to
perl 5.6.1 but still got the same result so I tried downgrading to 5.005,
which is the version that was installed originally by VALinux. I got the
source RPM and built a shared libperl.so version as required by plperl. This
fixed the problem. I'm still not certain if this means plperl is
incompatible with perl 5.6.x or if this is a VALinux oddity.

Jeff

-----Original Message-----
From: Peter Eisentraut [mailto:peter_e(at)gmx(dot)net]
Sent: Thursday, May 17, 2001 7:41 AM
To: Jeff Patterson
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PL/Perl in 7.1.1

Jeff Patterson writes:

> I recently upgraded from 7.0.3 to 7.1. Everything went fine until I went
to
> install plperl using createlang. It throws the following error message:
>
> ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed:
/usr/lib/perl5/5.6.0/i686-linux/auto/Opcode/Opcode.so: undefined symbol:
Perl_save_vptr

Here's a wildish guess: Get out your PostgreSQL sources, go to the
directory src/backend/port/dynloader, file linux.h and change

dlopen(f, 2)

to

dlopen(f, RTLD_LAZY | RTLD_GLOBAL)

and rebuild the backend. (If you don't have Linux you can still make a
similar change in the respective *.h file.)

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter