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

I tried to do lo_import from psql... it worked under 6.3.2 but I couldn't
do a lo_export...

I'd love to be able to do this too... must be form psql though.... if
anyone could let me know if that's possible and give me the syntax I'd be
greatful.

Cheers....

On Thu, 12 Nov 1998, 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
>
>

James (james(at)linuxrocks(dot)co(dot)uk)
Vortex Internet
My Windows unders~1 long filena~1, and yours?