Обсуждение: create plperlu langage fails
hi,
i get an exception while trying to create plperlu langage :
CREATE OR REPLACE FUNCTION plperl_call_handler()
RETURNS language_handler
AS '/home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so', 'plperl_call_handler' LANGUAGE 'c' VOLATILE;
CREATE LANGUAGE 'plperlu' HANDLER plperl_call_handler LANCOMPILER 'PL/perl';
the error :
ERROR: could not load library "/home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so": ld.so.1:
/opt/pgsql/bin/postgres:fatal: relocation error: file /home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so: symbol
perl_call_pv:referenced symbol not found
thanks
Will
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.
On Thu, Jan 19, 2006 at 05:22:23PM +0100, FERREIRA, William (VALTECH) wrote: > ERROR: could not load library "/home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so": ld.so.1: /opt/pgsql/bin/postgres:fatal: relocation error: file /home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so: symbol perl_call_pv:referenced symbol not found Was your libplperl.so built against an older version of Perl than your libperl.so was? In recent versions of Perl perl_call_pv is a macro that ultimately expands to Perl_call_pv, but in older versions perl_call_pv was a symbol itself. How did you obtain libplperl.so -- did you built it yourself or install it from a package? Do you have multiple versions of Perl installed? What platform are you using? -- Michael Fuhr
"FERREIRA, William (VALTECH)" <william.ferreira@airbus.com> writes:
> This e-mail is intended only for the above addressee. It may contain
> privileged information. If you are not the addressee you must not copy,
> distribute, disclose or use any of the information in it. If you have
> received it in error please delete it and immediately notify the sender.
> Security Notice: all e-mail, sent to or from this address, may be
> accessed by someone other than the recipient, for system management and
> security reasons. This access is controlled under Regulation of
> Investigatory Powers Act 2000, Lawful Business Practises.
I don't think I'm allowed to read your question, let alone answer it...
regards, tom lane
Tom Lane schrieb: ... >>Investigatory Powers Act 2000, Lawful Business Practises. > > > I don't think I'm allowed to read your question, let alone answer it... > "Awful Business Practices"? SCNR ;)
i have 2 versions of perl installed : 5.00 and 5.8.7 i added perl 5.8.7 executable in the PATH environnement variable. During postgresql configure, the good version of perl is found. does I need to add in the path some libraries (like libperl.so) or does it find it using the perl executable ? i'm working on sun-solaris 2.8 regards -----Message d'origine----- De : Michael Fuhr [mailto:mike@fuhr.org] Envoyé : jeudi 19 janvier 2006 18:30 À : FERREIRA, William (VALTECH) Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] create plperlu langage fails On Thu, Jan 19, 2006 at 05:22:23PM +0100, FERREIRA, William (VALTECH) wrote: > ERROR: could not load library "/home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so": ld.so.1: /opt/pgsql/bin/postgres:fatal: relocation error: file /home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so: symbol perl_call_pv:referenced symbol not found Was your libplperl.so built against an older version of Perl than your libperl.so was? In recent versions of Perl perl_call_pv is a macro that ultimately expands to Perl_call_pv, but in older versions perl_call_pv was a symbol itself. How did you obtain libplperl.so -- did you built it yourself or install it from a package? Do you have multiple versions of Perl installed? What platform are you using? -- Michael Fuhr This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message. This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. Security Notice: all e-mail, sent to or from this address, may be accessed by someone other than the recipient, for system management and security reasons. This access is controlled under Regulation of Investigatory Powers Act 2000, Lawful Business Practises.
yes !
i found my problem
i added libperl.so (from perl 5.5.7) in LD_LIBRARY_PATH and now it works
thanks
Will
-----Message d'origine-----
De : Michael Fuhr [mailto:mike@fuhr.org]
Envoyé : jeudi 19 janvier 2006 18:30
À : FERREIRA, William (VALTECH)
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] create plperlu langage fails
On Thu, Jan 19, 2006 at 05:22:23PM +0100, FERREIRA, William (VALTECH) wrote:
> ERROR: could not load library "/home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so": ld.so.1:
/opt/pgsql/bin/postgres:fatal: relocation error: file /home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so: symbol
perl_call_pv:referenced symbol not found
Was your libplperl.so built against an older version of Perl than
your libperl.so was? In recent versions of Perl perl_call_pv is a
macro that ultimately expands to Perl_call_pv, but in older versions
perl_call_pv was a symbol itself.
How did you obtain libplperl.so -- did you built it yourself or
install it from a package? Do you have multiple versions of Perl
installed? What platform are you using?
--
Michael Fuhr
This mail has originated outside your organization,
either from an external partner or the Global Internet.
Keep this in mind if you answer this message.
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.