Thread: Re: [INTERFACES] Compiling a function

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

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

That's probably because you are still looking in the object file. If
you did not tweak the filenames, the linker should create a shared
object file with the .so suffix, and it's likely that it did. Use
'file' to find out, like this (real example):

file /home/wit/pgsql/ExtendedTypes/seg/seg.o
/home/wit/pgsql/ExtendedTypes/seg/seg.o: ELF 32-bit LSB relocatable, Intel 80386, version 1, not stripped

file /home/wit/pgsql/ExtendedTypes/seg/seg.so
/home/wit/pgsql/ExtendedTypes/seg/seg.so: ELF 32-bit LSB shared object, Intel 80386, version 1, not stripped

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

Object files and shared libraries have different symbol tables, let
alone the code.

I remember building things painlessly in FreeBSD, but that was a
couple years back, so I am not sure now. In any event, I would start
with tutorial examples because these are almost guaranteed to
work. Also, here's a complete code for a user-defined function -- you
will only need to adjust the paths in the Makefile and in the sql
script:

http://wit.mcs.anl.gov/~selkovjr/foldit.tgz

--Gene

        It also seems possible that you forgot to change the SQL
statement that you used to add the function(s) into the database.
Somewhere, you ran a SQL statement of the form:

create function bool2int(opaque) returns int4
  as '/usr/local/pgsql/procs/bool2int.o'
  language 'c';

        So make sure you change that ".o" to ".so". BTW, this is
true on most Unix flavors, if not all. If you have to pass parameters
to the 'bool2int()' function, then describe them rather than using
the "opaque" description.

regards,

----------------------------------
Date: 20-Apr-99  Time: 13:00:02

Craig Orsinger                  (email: <orsingerc@epg.lewis.army.mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------


On 20-Apr-99 Gene Selkov, Jr. wrote:
>> ERROR:  Can't find function bool2int in file
>> /usr/local/pgsql/procs/bool2int.o
>>
>
> That's probably because you are still looking in the object file. If
> you did not tweak the filenames, the linker should create a shared
> object file with the .so suffix, and it's likely that it did. Use
> 'file' to find out, like this (real example):
>
> file /home/wit/pgsql/ExtendedTypes/seg/seg.o
> /home/wit/pgsql/ExtendedTypes/seg/seg.o: ELF 32-bit LSB relocatable, Intel
> 80386, version 1, not stripped
>
> file /home/wit/pgsql/ExtendedTypes/seg/seg.so
> /home/wit/pgsql/ExtendedTypes/seg/seg.so: ELF 32-bit LSB shared object, Intel
> 80386, version 1, not stripped
>
>> I have tried every linker flag possible, nothing helps.  Seems funny that a
>> function cannot be located in a library file?!?!
>
> Object files and shared libraries have different symbol tables, let
> alone the code.
>
> I remember building things painlessly in FreeBSD, but that was a
> couple years back, so I am not sure now. In any event, I would start
> with tutorial examples because these are almost guaranteed to
> work. Also, here's a complete code for a user-defined function -- you
> will only need to adjust the paths in the Makefile and in the sql
> script:
>
> http://wit.mcs.anl.gov/~selkovjr/foldit.tgz
>
> --Gene
>