Re: Help with adding C-Language Functions

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