"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