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

Поиск
Список
Период
Сортировка
Искать
От
Jeroen Schaap
Тема
Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Дата
Msg-id
364BF96D.6DBD0BCF@rulffk.medfac.leidenuniv.nl
Список
Дерево обсуждения
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>
Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..) Brook Milligan <brook@trillium.NMSU.Edu>
Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..) A James Lewis <james@vrtx.net>
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 по дате отправления
От: Postgres DBA
Дата:
Сообщение: Re: [GENERAL] alter table ?
От: Sergei Chernev
Дата:
Сообщение: PL/pgSQL
FAQ