Received: from redbox.venux.net (redbox.venux.net [216.47.238.10])
	by hub.org (8.9.3/8.9.1) with ESMTP id EAA76563
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 20 Apr 1999 04:20:16 -0400 (EDT)
	(envelope-from matthew@venux.net)
Received: from thunder (net177138.hcv.com [209.153.177.138])
	by redbox.venux.net (Postfix) with SMTP
	id AA63E2E22A; Tue, 20 Apr 1999 04:19:19 -0400 (EDT)
Message-Id: <4.1.19990420041438.00bea910@mail.venux.net>
X-Sender: mhagerty@mail.venux.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 
Date: Tue, 20 Apr 1999 04:19:00 -0400
To: "Gene Selkov, Jr." <selkovjr@mcs.anl.gov>
From: Matthew Hagerty <matthew@venux.net>
Subject: Re: [INTERFACES] Compiling a function
Cc: pgsql-interfaces@postgreSQL.org
In-Reply-To: <199904200655.BAA21841@antares.mcs.anl.gov>
References: <Your message of "Tue, 20 Apr 1999 02:41:36 EDT."
	<4.1.19990420023358.00b5c340@mail.venux.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 01:55 AM 4/20/99 -0400, you wrote:
>> ERROR:  Load of file /usr/local/pgsql/procs/bool2int.o failed: dlopen
>> (/usr/local/pgsql/procs/bool2int.o) failed
>
>3 points:
>
>Make sure /usr/local/pgsql/procs/bool2int.o exists and is accessible to 
>postgres
>
>Even though you are running FreeBSD, I believe you need to build a shared 
>object (bool2int.so), not just an object file
>
>Start with examples in src/tutorial/. Watch what their Makefile is doing.
>
>
>--Gene

Thanks!  I linked with -shared and that fixed the LOAD problem.  Now I get
an error saying the function cannot be found in the file...

ERROR:  Can't find function bool2int in file /usr/local/pgsql/procs/bool2int.o

I have tried every linker flag possible, nothing helps.  Seems funny that a
function cannot be located in a library file?!?!

Any *more* insight whould be greatly appreciated.

Thanks,
Matthew