perl 5.6.1 and PostgreSQL7.3.2
perl 5.6.1 and PostgreSQL7.3.2
От:
Jie Liang <jliang@ipinc.com>
Дата:
I tried to use perl 5.6.1+ on PL/Perl, even though I successfully created libperl.so file and get compile done(gmake no complaint), but I still failed at load. Following is my steps: (OS: FreeBSD-4.7, PostgreSQL 7.3.2, Perl 5.6.1) cd /usr/ports/lang/perl5 make cd work/perl-5.6.1 LD_LIBRARY_PATH=`pwd` export LD_LIBRARY_PATH sh Configure -Duseshrplib For every question, I take the default, except: Build a shared libperl.so (y/n) [n] y What name do you want to give to the shared libperl? [libperl.a] libperl.so.5.6.1 after that make make test make install (perl 5.6.1 executable is installed at /usr/local/bin/) make a symbolic like with libperl.so->libperl.so.5.6.1 which is under /usr/local/lib/perl5/5.6.1/mach/CORE/ then install postgresql gmake gmake install (no complaint at all) initdb start postmaster createlang plperl template1 (compliant) EERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: dlopen '/usr/local/pgsql/lib/plperl.so' failed. (/usr/local/pgsql/lib/plperl.so: Undefined symbol "Perl_sv_2pv_flags") ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: dlopen '/usr/local/pgsql/lib/plperl.so' failed. (/usr/local/pgsql/lib/plperl.so: Undefined symbol "Perl_sv_2pv_flags") createlang: language installation failed What's wrong? -- Jie LIANG Software Engineer St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@stbernard.com www.stbernard.com
Re: perl 5.6.1 and PostgreSQL7.3.2
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jie Liang writes: > EERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: dlopen > '/usr/local/pgsql/lib/plperl.so' failed. > (/usr/local/pgsql/lib/plperl.so: Undefined symbol "Perl_sv_2pv_flags") You sure plperl was compiled against the same version of Perl you're using? The Perl binary API does vary depending on your version and compilation options ... regards, tom lane