[SQL]
Sorry for my previos letter, it was wrong. Deal ( question ) are consist of: [plperl]# make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/plperl mkdir blib/lib/auto mkdir blib/lib/auto/plperl gcc -c -I../../../src/include -I../../../src/backend -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"0.10\" -DXS_VERSION=\"0.10\" -fpic -I/usr/local/perl/lib/5.6.0/i686-linux/CORE plperl.c In file included from plperl.c:76: /usr/local/perl/lib/5.6.0/i686-linux/CORE/perl.h:467: warning: `USE_LOCALE' redefined ../../../src/include/config.h:214: warning: this is the location of the previous definition In file included from plperl.c:76: /usr/local/perl/lib/5.6.0/i686-linux/CORE/perl.h:2027: warning: `DEBUG' redefined ../../../src/include/utils/elog.h:22: warning: this is the location of the previous definition plperl.c: In function `plperl_create_sub': plperl.c:328: `errgv' undeclared (first use in this function) plperl.c:328: (Each undeclared identifier is reported only once plperl.c:328: for each function it appears in.) plperl.c:334: `na' undeclared (first use in this function) plperl.c: In function `plperl_call_perl_func': plperl.c:444: `errgv' undeclared (first use in this function) plperl.c:450: `na' undeclared (first use in this function) plperl.c: In function `plperl_func_handler': plperl.c:654: `na' undeclared (first use in this function) plperl.c: In function `plperl_build_tuple_argument': plperl.c:2192: `na' undeclared (first use in this function) make: *** [plperl.o] Error 1 What's that may be? turing2000
[SQL]
Please, help me. I configure/compile perl with option ( other options stay default ): ./Configure -Dprefix=/usr/local/perl -Duseshrplib make make install I add string '/usr/local/perl/lib/5.6.0/i686-linux/CORE' in file /etc/ld.so.conf and call program 'ldconfig'. Environment: LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/perl/lib/5.6.0/i686-linux/CORE All is OK for perl. But in psql: \c db_name create function perl_hnd() returns opaque as' /usr/local/perl/lib/5.6.0/i686-linux/CORE/libperl.so' language 'C'; create trusted procedural language 'perl' handler perl_hnd lancompiler 'perlcompiler'; create function f( int4, int4 ) returns int4 as' return $_[0] + $_[1]; 'language 'perl'; db_name=> select f(2,2); ERROR: Can't find function perl_hnd in file /usr/local/perl/lib/5.6.0/i686-linux/CORE/libperl.so Please, help me! turing2000