From: | George Kousi <george(at)albourne(dot)com> |
---|---|
To: | Jeroen Schaap <jeroen(at)rulffh(dot)medfac(dot)leidenuniv(dot)nl> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..) |
Date: | 1998-11-12 14:27:18 |
Message-ID: | 364AF046.5BA8C11F@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jeroen Schaap wrote:
> 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(at)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(at)rulgfu sql]$ ls -l test.sql
> -rw-r--r-- 1 jeroen postgres 53 Nov 12 15:48 test.sql
> [jeroen(at)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
Not sure, but try putting the file on the same machine that your backend runs,
e.g. the /tmp directory of the machine that the backend is installed.
Hope it helps.
George Kousi
From | Date | Subject | |
---|---|---|---|
Next Message | Jeroen Schaap | 1998-11-12 14:38:21 | Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..) |
Previous Message | Bob Dusek | 1998-11-12 08:47:01 | vacuum errors... ??!!!! |