From: Jonah H. Harris <jonah.harris@gmail.com>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: There is acid without transactions ?
Date: Sun, 11 Mar 2007 16:30:49 -0400
Message-ID: <36e682920703111330o7d2da7fcqbb503c08566be1f1@mail.gmail.com> (raw)
In-Reply-To: <55c095e90703110939i7c414c48g1c14c3dc6e56ba30@mail.gmail.com>
References: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com>
<36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com>
<55c095e90703110939i7c414c48g1c14c3dc6e56ba30@mail.gmail.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jonah.harris@gmail.com, ezequias.rocha@gmail.com
Subject: Re: There is acid without transactions ?
In-Reply-To: <36e682920703111330o7d2da7fcqbb503c08566be1f1@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox