Do you need to specify ....test_func.so not ...test_func or has that changed? --elein On Tue, Jun 20, 2006 at 05:13:32PM -0400, Jasbinder Bali wrote: > chmod 666 filename is something i've done to give permissions to all.. > still doesn't work. > > > On 6/20/06, Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx> wrote: > > In response to "Jasbinder Bali" <jsbali@xxxxxxxxx>: > > > 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. > >
