On Wed, Mar 01, 2006 at 11:03:12AM -0500, Tom Lane wrote: > "sandhya" <sandhyar@xxxxxxxxxxxxxx> 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. lo_open() fails if it's not in a transaction. The error from PQerrorMessage is: ERROR: invalid large-object descriptor: 0 -- Michael Fuhr
