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 Jeroen Schaap
Subject Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Date
Msg-id 364BF96D.6DBD0BCF@rulffk.medfac.leidenuniv.nl
Whole thread Raw
In response to Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)  (Jeroen Schaap <jeroen@rulffh.medfac.leidenuniv.nl>)
Responses Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
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.

Jeroen

pgsql-general by date:

Previous
From: Postgres DBA
Date:
Subject: Re: [GENERAL] alter table ?
Next
From: "Sergei Chernev"
Date:
Subject: PL/pgSQL