Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6BEEA9FB608 for ; Sun, 11 Mar 2007 13:42:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 15919-09 for ; Sun, 11 Mar 2007 13:42:37 -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.172]) by postgresql.org (Postfix) with ESMTP id B2BEA9FB5FC for ; Sun, 11 Mar 2007 13:42:37 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so1840147ugf for ; Sun, 11 Mar 2007 09:42: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=qCRbRZvq2i21/+YxarEgxQJnaDKstDc21QQcEfuE8UyD56k7Zh/3tHU8cxGpK5NxVGtFDz42PAVAVODAqYyl4FaYwb+Jy5a82baxgZIhp1Clb5CAUdXlGbuDvQ1tXzOKPxmPlZO2lKikhTc18B1HRu2XWTXiBVFRQ5Ra724tbcQ= 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=IaaRj7GRfiLLkjp0JXNkEGqUzVdVYav5O+7LrFverlVe3Yb4jQQl+SLIyJ5iB/DYaB/959VTREbcKsOvf6WgKar+xJkcnbMtxiz4hGHBjNmddHZIH2j9lhEdM135ALeimlbyXnbC+xbR8y11DX/ZuLGPG9XpZWaoCxQr9c88ob4= Received: by 10.67.19.17 with SMTP id w17mr15239447ugi.1173631356437; Sun, 11 Mar 2007 09:42:36 -0700 (PDT) Received: by 10.67.94.13 with HTTP; Sun, 11 Mar 2007 09:42:36 -0700 (PDT) Message-ID: <55c095e90703110942p1b38eeeeo26ede2d09ee40a0@mail.gmail.com> Date: Sun, 11 Mar 2007 13:42:36 -0300 From: "Ezequias Rodrigues da Rocha" To: "Jonah H. Harris" Subject: Re: There is acid without transactions ? Cc: PostgreSQL In-Reply-To: <55c095e90703110939i7c414c48g1c14c3dc6e56ba30@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11243_12705339.1173631356383" References: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com> <36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com> <55c095e90703110939i7c414c48g1c14c3dc6e56ba30@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/140 X-Sequence-Number: 27778 ------=_Part_11243_12705339.1173631356383 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry my mistake it was 32 minutes. I am confusing with gmail here. Anyway today is sunday and it is more difficult to have a reply from community. Anyway thanks. Ezequias 2007/3/11, Ezequias Rodrigues da Rocha : > > 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 : > > > > On 3/11/07, Ezequias Rodrigues da Rocha > > 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/ > -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/ use Mozilla Firefox:http://br.mozdev.org/firefox/ ------=_Part_11243_12705339.1173631356383 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry my mistake it was 32 minutes. I am confusing with gmail here.

Anyway today is sunday and it is more difficult to have a reply from community. Anyway thanks.

Ezequias

2007/3/11, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>:
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/



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