"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. You might want to look at src/test/examples/testlo.c in the PG distribution. regards, tom lane
