> Reason of this problem is that PsqlODBC handles the large object
> transaction. Since PostgreSQL 6.5, the large object must be handled
> To solve, we should insert source code to begin transaction into
> source before calling lo_create and lo_open functions. Also should
> transaction after calling lo_close too.
What is the possible side effects of not committing after lo_close? I'm
just wondering, incase I have to do anything to the JDBC driver's lo
Whilst on the subject, what is the prospect of nested transactions for
7.0? My number 1 question I get asked is caused by having to use
transactions for lo's, and it would be nice to wrap the JDBC standard lo
calls in their own transactions, but if autoCommit is false (ie, already
in a transaction), then this is a problem.
Nestable transactions (even only 1 extra level) would solve this
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 1999-12-08 09:07:17|
|Subject: Re: [INTERFACES] Transaction support in 6.5.3/JDBC |
|Previous:||From: Christian Hang||Date: 1999-12-08 08:47:05|
|Subject: Re: ODBC and Large Objects, FAQ not working|