Re: Help with adding C-Language Functions

Thinking back I think i tried g++ first which caused the error to occur.
When i then tried cc the .so was already loaded.

I have c++ classes i want to use but when i complile using g++ i get the
error (cant find function x in file.so). Does anyone have experience
compiling c++ and loading the function?

Seamus

On Thu, 10 Feb 2005, Tom Lane wrote:

> Seamus Thomas Carroll <carrolls(at)cpsc(dot)ucalgary(dot)ca> writes:
>> I changed my file from BlackboardFunctions.c to all lowercase,
>> blackboardfunctions.c, and the database now finds the add_one function.
>
> I'm betting that the actual sequence of events was more like this:
>
> CREATE FUNCTION f1(...) as '/home/.../BlackboardFunctions' ...;
> [ test f1, it works, cool ]
> [ add add_one to C source file, recompile ]
> CREATE FUNCTION add_one(...) as '/home/.../BlackboardFunctions' ...;
> [ fails ]
> [ rename file ]
> CREATE FUNCTION add_one(...) as '/home/.../blackboardfunctions' ...;
> [ works ]
>
> The reason the second try didn't work is that an existing backend will
> not re-load an already loaded .so file, unless you force it to with the
> LOAD command. It doesn't notice that you've modified the file. Had you
> started a fresh session, things would have worked, too.
>
> regards, tom lane
>