Обсуждение: 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 >