X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E403752A80 for ; Tue, 12 Jul 2005 23:08:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72325-07 for ; Wed, 13 Jul 2005 02:08:52 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 8543E52A8C for ; Tue, 12 Jul 2005 23:08:50 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j6D28m9x005457 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 12 Jul 2005 20:08:50 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j6D28l2k088408; Tue, 12 Jul 2005 20:08:47 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j6D28lJM088407; Tue, 12 Jul 2005 20:08:47 -0600 (MDT) (envelope-from mfuhr) Date: Tue, 12 Jul 2005 20:08:47 -0600 From: Michael Fuhr To: "TJ O'Donnell" Cc: pgsql-sql@postgresql.org Subject: Re: dynamically loaded functions Message-ID: <20050713020847.GA87716@winnie.fuhr.org> References: <42D33601.5080605@acm.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <42D33601.5080605@acm.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/106 X-Sequence-Number: 22084 On Mon, Jul 11, 2005 at 08:16:17PM -0700, TJ O'Donnell wrote: > > CREATE or REPLACE FUNCTION cansmiles(varchar) RETURNS varchar > AS 'gnova', 'oe_cansmiles' LANGUAGE 'c' IMMUTABLE STRICT; > requires preloading of oe_chem.so to work. > > Is there any way I can associate oe_cansmiles with 2 .so's without > preloading? It sounds like you need to link gnova.so against the other shared objects so the runtime linker can find them. For examples, see the Makefiles used by contributed modules like dblink, xml2, and a few others that link against external libraries. -- Michael Fuhr http://www.fuhr.org/~mfuhr/