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..)
Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..) |
Список | 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 по дате отправления: