Re: There is acid without transactions ?

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 | COMIT).

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/