Received: from fido.inet-interactif.com (fido.inet-interactif.com [216.218.2.225]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26Ngnx00194; Tue, 6 Mar 2001 18:42:49 -0500 (EST) (envelope-from boulat@inet-interactif.com) Received: from inet-interactif.com ([216.218.2.229]) by fido.inet-interactif.com (8.9.3/8.9.3) with ESMTP id SAA53262; Tue, 6 Mar 2001 18:42:42 -0500 (EST) (envelope-from boulat@inet-interactif.com) Message-ID: <3AA5765F.75350FEA@inet-interactif.com> Date: Tue, 06 Mar 2001 18:44:31 -0500 From: Boulat Khakimov Organization: Inet Interactif Inc. X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.18 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Undefined symbol Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/307 X-Sequence-Number: 5791 Hi, Im writing a function in C (encode) for PG that uses blowfish encryption here is how I compile it. gcc -I/usr/src/postgresql-7.0.3/src/include -I/usr/src/postgresql-7.0.3/src/backend -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -lcrypt -I/usr/src/postgresql-7.0.3/src/interfaces/libpq -I/usr/src/postgresql-7.0.3/src/include -fpic -I/home/boulat/Funio.com/database/libblowfish.a -c -o encode.o encode.c it compiles nicely with 0 error or warnings, then i do gcc -shared -o encode.so encode.o rm encode.o so now im left we a ready to go encode.so , So now I add that function to DB testdb=# CREATE FUNCTION encode(text,text) testdb-# RETURNS text testdb-# AS '/home/boulat/Funio.com/database/encode.so' testdb-# LANGUAGE 'C'; CREATE no problems there either, BUT ... testdb=# select encode('bob','bob'); ERROR: Load of file /home/boulat/Funio.com/database/encode.so failed: /home/boulat/Funio.com/database/encode.so: undefined symbol: BF_cfb64_encrypt thats the function that I call from inside my c code... but Why??? It compiled with no errors or warning, and I have all the right includes in my source code. Im confused! Any help would be appreciated. Regards, Boulat Khakimov -- Nothing Like the Sun