Thread: Invalid large object descriptor : 0 with autocommit

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

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/static/datatype-binary.html

Best Regards,
Michael Paesold