Re: Dynamic loading of C functions

["Erin Sheldon" <erin(dot)sheldon(at)gmail(dot)com>]

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 <jsbali(at)gmail(dot)com> 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(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.
> >