Was the object compiled on the same architecture as postgres?
Sometimes when one is compiled on a 64-bit, the other on 32-bit,
or two wildly different versions of gcc, I have seen this cryptic "No such
file or directory".
Erin
On 6/20/06, Jasbinder Bali <[EMAIL PROTECTED]> wrote:
chmod 666 filename is something i've done to give permissions to all..
still doesn't work.
On 6/20/06, Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to "Jasbinder Bali" <[EMAIL PROTECTED]>:
>
> > 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.
>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
