Re: Dynamic loading of C functions

["Jasbinder Bali" <jsbali(at)gmail(dot)com>]

chmod 666 filename is something i've done to give permissions to all..

still doesn't work.

 

On 6/20/06, Bill Moran <wmoran(at)collaborativefusion(dot)com> wrote:

In response to "Jasbinder Bali" <jsbali(at)gmail(dot)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.