Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)

Поиск
Список
Период
Сортировка
От Jeroen Schaap
Тема Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Дата
Msg-id Pine.LNX.3.91.981112152500.5971B-100000@rulffh.medfac.leidenuniv.nl
обсуждение исходный текст
Ответы 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>)
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>)
Список pgsql-general
Here is something I totally don't understand. And i need this one to be
fixed...

Here is a transcript of a session, with a test-table containing only
one oid-column....

    [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"

    EOF
    [jeroen@rulgfu sql]$ ls -l test.sql
    -rw-r--r--   1 jeroen  postgres       53 Nov 12 15:48 test.sql
    [jeroen@rulgfu sql]$ cat test.sql
    insert into testfile values (lo_import('test.sql'));

First I thought it was the permissions... but not at all... look above

Then I thought, well, on my old slackware box it ran beautifully... so
let's try that (self-compiled) version (6.3.3 i believe....)... but no
difference.

Does anybody have a clue (please???)

Thanks in advance!!!!!

(At CET 0900 to 1700 you can also call me if you like...)

Jeroen

Jeroen Schaap.............I was dreaming of guitarnotes that would irritate
Homepage: <http://rulffh.medfac.leidenuniv.nl>..| ^|^ |...an executive kind
Keywords: Guitars, Linux, Mac and SCN...........\_`-'_/..............of guy
Tel: (0)71-5276811................................| |...........Frank Zappa


В списке pgsql-general по дате отправления:

Предыдущее
От: Bob Dusek
Дата:
Сообщение: vacuum errors... ??!!!!
Следующее
От: George Kousi
Дата:
Сообщение: Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)