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$0b01a8c0@johnpark.net (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group