"sandhya" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org