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