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 12:35:50 -0400
Message-ID: <36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com> (raw)
In-Reply-To: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com>
References: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com>
On 3/11/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> Insert into foo values (1,'Brazil');
Assuming you're in psql or using the drivers in autocommit mode, then
yes, it's ACID compliant. Individual statements are treated as an
implicit transaction unless you create an explicit transaction with
BEGIN ... (ROLLBACK | COMMIT).
Some of the drivers, however, will create an explicit transaction
behind-the-scenes if you have autocommit mode disabled.
Did that help or was it more confusing?
--
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: <36e682920703110935j689a760aw477a5d2b132a3487@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