Re: Reg:lo_open error..pls help me - Mailing list pgsql-admin

From Tom Lane
Subject Re: Reg:lo_open error..pls help me
Date
Msg-id 11079.1141228992@sss.pgh.pa.us
Whole thread Raw
In response to Reg:lo_open error..pls help me  ("sandhya" <sandhyar@amiindia.co.in>)
Responses Re: Reg:lo_open error..pls help me  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
"sandhya" <sandhyar@amiindia.co.in> writes:
>   But lo_open is returning -1(-ve value).

Are you sure that's where it's failing?  The fragment you showed looks
fine as far as it goes.  The most likely bet is you forgot to wrap it in
a transaction (BEGIN/COMMIT commands), but that would result in a
failure at the seek/write commands because the object wouldn't be open
anymore.

You might want to look at src/test/examples/testlo.c in the PG distribution.

            regards, tom lane

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Reg:lo_open error..pls help me
Next
From: Michael Fuhr
Date:
Subject: Re: Reg:lo_open error..pls help me