From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Seamus Thomas Carroll <carrolls(at)cpsc(dot)ucalgary(dot)ca> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: Help with adding C-Language Functions |
Date: | 2005-02-10 17:31:13 |
Message-ID: | 27779.1108056673@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Seamus Thomas Carroll | 2005-02-10 19:55:44 | Re: Help with adding C-Language Functions |
Previous Message | Francisco Figueiredo Jr. | 2005-02-10 16:51:46 | Re: Function return number of affected rows |