Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eANF6JA56515 for ; Thu, 23 Nov 2000 10:06:19 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mx8.port.ru (mx8.port.ru [194.67.23.80]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAGB7Ls64978 for ; Thu, 16 Nov 2000 06:07:21 -0500 (EST) (envelope-from turing2000@mail.ru) Received: from f9.int ([10.0.0.77] helo=f9.mail.ru) by mx8.port.ru with esmtp (Exim 3.14 #2) id 13wMrY-0000Gq-00 for pgsql-sql@postgresql.org; Thu, 16 Nov 2000 14:05:52 +0300 Received: from mail by f9.mail.ru with local (Exim 3.14 #30) id 13wMrT-000J42-00 for pgsql-sql@postgresql.org; Thu, 16 Nov 2000 14:05:51 +0300 Received: from [213.24.90.42] by win.mail.port.ru with HTTP; Thu, 16 Nov 2000 11:05:51 +0000 (GMT) From: "turing2000" To: pgsql-sql@postgresql.org Mime-Version: 1.0 X-Mailer: mPOP Web-Mail 2.19 X-Originating-IP: [213.24.90.42] Reply-To: "turing2000" Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 8bit Message-Id: Date: Thu, 16 Nov 2000 14:05:51 +0300 X-Archive-Number: 200011/192 X-Sequence-Number: 223 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