Re: Driver confused by explicit transactions - Mailing list pgsql-odbc

From Glen Parker
Subject Re: Driver confused by explicit transactions
Date
Msg-id 02d001c29e48$2a59b030$0b01a8c0@johnpark.net
Whole thread Raw
In response to Re: Driver confused by explicit transactions  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses Re: Driver confused by explicit transactions  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-odbc
> > It appears there is a somewhat on-going bug in the ODBC driver
> > (07.02.0005 in this case) concerning explicit transactions.  The
> > following sequence demonstrates it.
>
> What do you mean by explicit transactions ? i. e
>
> > Begin transaction   (OK)
>
>    How do you begin the transaction ?

By turning off auto-commit with a call to SQLSetConnectOption().

> > Execute update statement(s)   (OK, records hidden from other
> > transactions)
> > Commit transaction    (OK, records appear to other transactions)
>
>   And how do you commit the transaction ?

With a call to SQLTransact() to either commit or abort transaction.

Glen


pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: [GENERAL] Drop column and Access
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: Driver confused by explicit transactions