Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 03EE59FB5AF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 11 Mar 2007 13:39:42 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 46180-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 11 Mar 2007 13:39:39 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171])
	by postgresql.org (Postfix) with ESMTP id AF5E59FB544
	for <pgsql-sql@postgresql.org>; Sun, 11 Mar 2007 13:39:37 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id k3so1839600ugf
	for <pgsql-sql@postgresql.org>; Sun, 11 Mar 2007 09:39:36 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=l5mA79guBKJ/VaOnfS1tnLy9oe/uu4KLaHjiPFU1f9Mu99dy+uNNv+IdGRHU80NOB8KSyIKz7bG1fUELaUiev3l8Nk2FLSR1F+PLVY8JJqJ7zjs5lJk0fICcSkuS926qIXLDiGDCZNY+tJ9ro+DzgLjCqwepqHjDbzFxu9fkJHg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=qe4BTxScpzjx5fsIIYFqSuLStIKjFIbhLrvq91mLZcCc+l60tpebYKei21YOyMSrybOZwxt/fJ/DJXZLdeNgMKVNOvytpK/zWgjhugKxWyTZtycnZDKXbK1HR2iSIFHEITUYDBCquMoUgjw+9mXp90eyqte0B4U3k5HHfpvW4VM=
Received: by 10.67.99.1 with SMTP id b1mr15191383ugm.1173631176457;
	Sun, 11 Mar 2007 09:39:36 -0700 (PDT)
Received: by 10.67.94.13 with HTTP; Sun, 11 Mar 2007 09:39:36 -0700 (PDT)
Message-ID: <55c095e90703110939i7c414c48g1c14c3dc6e56ba30@mail.gmail.com>
Date: Sun, 11 Mar 2007 13:39:36 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "Jonah H. Harris" <jonah.harris@gmail.com>
Subject: Re: There is acid without transactions ?
Cc: PostgreSQL <pgsql-sql@postgresql.org>
In-Reply-To: <36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_11203_23949374.1173631176405"
References: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com>
	<36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/138
X-Sequence-Number: 27776

------=_Part_11203_23949374.1173631176405
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Perfect. I just don't know what drivers you are talking about (odbc maybe).

More perfect is becouse you answare me in only 1 minute. What community
don't is ?

Ezequias

2007/3/11, Jonah H. Harris <jonah.harris@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 | 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/
>



-- 
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

------=_Part_11203_23949374.1173631176405
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Perfect. I just don&#39;t know what drivers you are talking about (odbc maybe).<br><br>More perfect is becouse you answare me in only 1 minute. What community don&#39;t is ?<br><br>Ezequias<br><br><div><span class="gmail_quote">
2007/3/11, Jonah H. Harris &lt;<a href="mailto:jonah.harris@gmail.com">jonah.harris@gmail.com</a>&gt;:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 3/11/07, Ezequias Rodrigues da Rocha &lt;<a href="mailto:ezequias.rocha@gmail.com">ezequias.rocha@gmail.com</a>&gt; wrote:<br>&gt; Insert into foo values (1,&#39;Brazil&#39;);<br><br>Assuming you&#39;re in psql or using the drivers in autocommit mode, then
<br>yes, it&#39;s ACID compliant.&nbsp;&nbsp;Individual statements are treated as an<br>implicit transaction unless you create an explicit transaction with<br>BEGIN ... (ROLLBACK | COMIT).<br><br>Some of the drivers, however, will create an explicit transaction
<br>behind-the-scenes if you have autocommit mode disabled.<br><br>Did that help or was it more confusing?<br><br>--<br>Jonah H. Harris, Software Architect | phone: 732.331.1324<br>EnterpriseDB Corporation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| fax: 
732.331.1301<br>33 Wood Ave S, 3rd Floor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| <a href="mailto:jharris@enterprisedb.com">jharris@enterprisedb.com</a><br>Iselin, New Jersey 08830&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| <a href="http://www.enterprisedb.com/">http://www.enterprisedb.com/
</a><br></blockquote></div><br><br clear="all"><br>-- <br>Ezequias Rodrigues da Rocha<br><a href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a><br>use Mozilla Firefox:<a href="http://br.mozdev.org/firefox/">
http://br.mozdev.org/firefox/</a>

------=_Part_11203_23949374.1173631176405--