Re: A bad behavior under autocommit off mode

Tom Lane wrote:
> 
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I think our SET functionality is easy to understand and use.  I don't
> > see pushing it into the client as greatly improving things, and could
> > make things worse.  If we can't get it right in the backend, how many
> > clients are going to do it wrong?
> 
> This argument overlooks the fact that most of the client libraries
> already have notions of autocommit on/off semantics that they need to
> adhere to.  libpq is too simple to have heard of the concept, but I
> believe that JDBC, ODBC, and DBI/DBD all need to deal with it anyway.
> I doubt that managing a server-side facility makes their lives any
> easier ... especially not if its semantics don't quite match what
> they need to do, which seems very possible.
> 
> But it'd be interesting to hear what the JDBC and ODBC maintainers
> think about it. 

The current ODBC driver doesn't work well under autocommit
off mode at server side. However, it's not on my (at least
ASAP) TODO item.

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/