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

From Bruce Momjian
Subject Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Date
Msg-id 199811131052.FAA05913@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)  (Jeroen Schaap <jeroen@rulffk.medfac.leidenuniv.nl>)
List pgsql-general
> 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.
>
> Good guess. Nevertheless, didn't work.

I think it is broken, but we will have a patch soon.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Kevin Heflin
Date:
Subject: Re: [GENERAL] alter table ?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] PL/pgSQL