Re: Help with adding C-Language Functions

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
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

In response to

Responses

Browse pgsql-interfaces by date

  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