Re: Invalid large object descriptor : 0 with autocommit

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
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-09-18 13:39:03 Re: Mail delivery failed: returning message to sender
Previous Message Russell Smith 2004-09-18 08:57:11 Re: Mail delivery failed: returning message to sender