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 Brook Milligan
Subject Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Date
Msg-id 199811121750.KAA21884@trillium.nmsu.edu
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>)
List pgsql-general
       [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.

Cheers,
Brook

pgsql-general by date:

Previous
From: A James Lewis
Date:
Subject: Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Next
From: Edmund Mergl
Date:
Subject: [Fwd: A trouble with postgres]