RE: [INTERFACES] 7.1 beta 3 Linux ODBC BEGIN Behaviour - Mailing list pgsql-odbc

From Hiroki Kataoka
Subject RE: [INTERFACES] 7.1 beta 3 Linux ODBC BEGIN Behaviour
Date
Msg-id NDBBIKCHILNJOAAPDPKMCEHBCCAA.kataoka@interwiz.koganei.tokyo.jp
Whole thread Raw
In response to Re: [INTERFACES] 7.1 beta 3 Linux ODBC BEGIN Behaviour  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-odbc
Hiroshi Inoue wrote
>
> Steve Wranovsky wrote:
> >
> > Hello,
> >
> > I found another slight behavior change with the Linux
> > client ODBC library between 7.0.3 and the 7.1 beta 3
> > release.  We are running under Redhat 6.0.
> >
> > We have set the ODBC driver in autocommit off mode.  With
> > the 7.0.3 driver, a BEGIN was automatically issued
> > before the driver encountered a INSERT/UPDATE/DELETE.  With
> > the 7.1 beta 3 ODBC driver, it now also issues a BEGIN when it
> > encounters a SELECT.
> >
> > Is this the expected behavior under 7.1?
>
> Probably not.
> I would put back the behabior in a few days.

  There must be "SELECT ~ FOR UPDATE" of inside of the transaction.

=====
Hiroki Kataoka


pgsql-odbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: RE: [PATCHES] Re: [HACKERS] 6.2 protocol
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] 6.2 protocol