[SQL]

2000-11-23 Thread turing2000

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]

2000-11-23 Thread turing2000

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