Re: Dynamic loading of C functions

In response to "Jasbinder Bali" <jsbali@gmail.com>:

> I've written a function in C, compiled it and trying to use the same
> function in one of my postgres functions like this:
>
> CREATE FUNCTION add_one(integer) RETURNS integer
>      AS '/usr/include/pgsql/server/test_func, 'add_one'
>      LANGUAGE C STRICT
>
> test_func is the name of my object file and add_one is the name of
> the function i want to call from test_func.c  C file.
>
> I get the follwing error
> ERROR:  could not access file "/usr/include/pgsql/server/test_func": No such
> file or directory
>
> /usr/include/pgsql/server/ is exactly the path where test_func object file
> resides.
> Don't know why isn't postgres able to find it there.
>
> Any kind of help would be appreciated.

Check the permissions.  Can the Postgres user read the file?

I don't remember if it has to be marked executable or not, but that's
something to check.

--
Bill Moran
Collaborative Fusion Inc.