Invalid large object descriptor : 0 with autocommit

[aditya Kulkarni]

Hi ,

I have an application that ran on Oracle, and the application, for
some reason requires autocommit to be true. Now, when we moved this
application to postgres, we moved the blob column to LargeObjects.

But PostgreSQL doesn't seem to be able to use Large Objects with
autoCommit = true. Is there any other way to work around this problem
?

Thanks in advance !!

--
Aditya Kulkarni

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Michael Paesold]

Aditya Kulkarni wrote:

I have an application that ran on Oracle, and the application, for
some reason requires autocommit to be true. Now, when we moved this
application to postgres, we moved the blob column to LargeObjects.

But PostgreSQL doesn't seem to be able to use Large Objects with
autoCommit = true. Is there any other way to work around this problem
?

Large objects access only works inside transactions.

Workaround: use bytea datatype for blob instead of large objects

http://www.postgresql.org/docs/7.4/s...pe-binary.html

Best Regards,
Michael Paesold

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org