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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)