Re: Driver confused by explicit transactions

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Driver confused by explicit transactions
Date: 2002-12-07 23:27:08
Message-ID: 02d001c29e48$2a59b030$0b01a8c0@johnpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-12-08 00:51:31 Re: Driver confused by explicit transactions
Previous Message Hiroshi Inoue 2002-12-07 14:57:35 Re: [ODBC] Drop column and Access