patch: BEGIN and autocommit(false)

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: patch: BEGIN and autocommit(false)
Date: 2006-01-20 13:22:57
Message-ID: 20060120132257.GA19840@soptik.pzkagis.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Thu, Jan 19, 2006 at 03:03:54PM +0100, Marc Herbert wrote:
> Ludek Finstrle <luf(at)pzkagis(dot)cz> writes:
> >> 1. set SQL_AUTOCOMMIT_OFF
> >
> > Yes you do ... When you use autocommit = off you have to start and end
> > transaction manually.
>
> Wrong: in ODBC, you just have to "end" transactions manually, you
> don't have to start them, they are implicitely started when the
> previous one ends.
>
> In ODBC (and JDBC), you are ALWAYS inside a transaction, there is no
> such thing as a transactional "no man's land" from an ODBC interface
> point of view (internal, hidden implementation details may differ).

I hope I solve this issue in psqlodbc driver. Thank you Marc for pointing
me the right way.
Patch attached (it's created againist 08.01.0107 development snapshot,
not againist CVS). This patch depend on psqlodbc-implicit_rollback.diff
one.

Please review and comment

Luf

Attachment Content-Type Size
psqlodbc-autocommit_off_begin.diff text/plain 2.9 KB

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message shriganesh shintre 2006-01-20 13:36:39 psqlodbc compilation and deployment on windows
Previous Message Ludek Finstrle 2006-01-20 12:31:59 patch: error messages?