Solved...Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)

Bruce Momjian wrote:
>
> > Brook Milligan wrote:
> > >
> > >            [jeroen@rulgfu sql]$ psql -f test.sql
> > >            insert into testfile values (lo_import('test.sql'));
> > >            ERROR:  be_lo_import: can't open unix file"test.sql"
> > >
> > > Isn't the problem that the backend expects test.sql to be in the data
> > > directories somewhere?  Try a full path.

> Try this patch.


I found the problem:
RH 5.1 sets the home directories unsearchable by others.
Setting chmod ag+x <home-dir> helped
Full paths are needed.

Thanks a lot everyone!!

And oh... I've applied the patch. Anyone interested in the regression
results?

Jeroen