Skip site navigation (1) Skip section navigation (2)

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$ (view raw, whole thread or download thread mbox)
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.


In response to


pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group