| Lists: | pgsql-general |
|---|
| From: | aditya Kulkarni <adityapk(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Invalid large object descriptor : 0 with autocommit |
| Date: | 2004-09-16 08:07:09 |
| Message-ID: | ade10d4204091601071cd22a9@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | "Michael Paesold" <mpaesold(at)gmx(dot)at> |
|---|---|
| To: | "aditya Kulkarni" <adityapk(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Invalid large object descriptor : 0 with autocommit |
| Date: | 2004-09-18 12:50:21 |
| Message-ID: | 002701c49d7e$0f059240$d604460a@zaphod |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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