Re: There is acid without transactions ? - Mailing list pgsql-sql

From Jonah H. Harris
Subject Re: There is acid without transactions ?
Date
Msg-id 36e682920703111330o7d2da7fcqbb503c08566be1f1@mail.gmail.com
Whole thread Raw
In response to Re: There is acid without transactions ?  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
On 3/11/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> Perfect. I just don't know what drivers you are talking about (odbc maybe).

As the server no longer supports server-side autocommit, I believe all
of the drivers create an explicit transaction behind the scenes when
the user requests autocommit to be turned off.  That way, the drivers
can allow the user to control the transaction state.

The only mainstream driver I know of which doesn't act this way is
libpq, where there is no way to turn off "autocommit" unless you
explicitly create the transaction yourself with BEGIN.

However, I'm sure each of the driver authors will correct me if I'm wrong :)

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Alternative Serial
Next
From: chester c young
Date:
Subject: how to use a date range in a join