Bruce Momjian wrote:
>
> > Brook Milligan wrote:
> > >
> > > [jeroen(at)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