From: TJ O'Donnell <tjo@acm.org>
To: Michael Fuhr <mike@fuhr.org>
To: pgsql-general@postgresql.org
Subject: Re: [SQL] dynamically loaded functions
Date: Wed, 13 Jul 2005 10:24:01 -0700
Message-ID: <42D54E31.1040508@acm.org> (raw)
In-Reply-To: <20050713020847.GA87716@winnie.fuhr.org>
References: <42D33601.5080605@acm.org>
<20050713020847.GA87716@winnie.fuhr.org>
>
> 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.
>
That approach is working, but only after much troubles.
I have several 3rd party libraries, some of which call each other.
It appears I need to carefully order the libraries in the
link step, or some needed functions do not get included in the
final .so.
This problem used to crop up all the time way back 20 years ago
with linkers. I thought all this name resolution stuff was all worked
out with modern linkers. I'm "linking" with (linux redhat)
gcc -shared -o my.so my.o my2.o their.a their2.a their3.a
When function x() in their2.a calls something in their.a
(or is it the other way around?)
I get an error from postmaster that my.so cannot be loaded because
function x cannot be found.
If I reverse their.a their2.a in the link command, all is well.
Note: I never use, nor even knew about the exitence of function x() - "they" do.
Any help on how to make this more pain-free?
TJ
Michael Fuhr wrote:
> 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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tjo@acm.org, mike@fuhr.org, pgsql-general@postgresql.org
Subject: Re: [SQL] dynamically loaded functions
In-Reply-To: <42D54E31.1040508@acm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox