plperl building problem on FreeBSD 4.10 port - Mailing list pgsql-bugs

From Ferruccio Zamuner
Subject plperl building problem on FreeBSD 4.10 port
Date
Msg-id 41A85D51.5000708@diff.org
Whole thread Raw
List pgsql-bugs
Hi,

I was installing a brand new PostgreSQL 7.4.6 on FreeBSD 4.10 using ports:

portinstall postgresql7
portinstall postgresql-pltcl
portinstall p5-postgresql-plperl

but when I was going to install the plperl, I've found following error:

Nov 27 11:06:51 biblio postgres[93190]: [1-1] ERROR:  could not load
library "/usr/local/lib/postgresql/plperl.so": dlopen
'/usr/local/lib/postgresql/plperl.so' failed.
Nov 27 11:06:51 biblio postgres[93190]: [1-2]
(/usr/local/lib/postgresql/plperl.so: Undefined symbol "Perl_sv_2pv_flags")
bash-2.05b$ createlang plperlu template1
createlang: language installation failed: ERROR:  could not load library
"/usr/local/lib/postgresql/plperl.so": dlopen
'/usr/local/lib/postgresql/plperl.so' failed.
(/usr/local/lib/postgresql/plperl.so: Undefined symbol "Perl_sv_2pv_flags")


On IRC I've found AndrewSN that helped me:

: that's a known build problem
: ok, reinstall as follows: in the port dir, do "make patch"  (which
will unpack and patch the tree)
: then modify configure (in the work dir) as follows:
: can you find the main "configure" file it should have extracted
: about 4300 lines down is this line:
: perl_embed_ldflags=`echo X"$pgac_tmp1" | sed "s/^X//;s%$pgac_tmp2%%"`
: change that to:
: perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
: then going back to the port dir and doing make; make install should work

In this way it works fine.

It should be usefull if that simple patch was available for BSD port users.

Bye,                   \fer

pgsql-bugs by date:

Previous
From: Neil Conway
Date:
Subject: Re: BUG #1329: Bug in IF-ELSEIF-ELSE construct
Next
From: Neil Conway
Date:
Subject: plpgsql unreachable code (was BUG #1329: Bug in IF-ELSEIF-ELSE construct)