Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 91DFF9FB3E2 for ; Sun, 11 Mar 2007 13:35:55 -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 44999-03 for ; Sun, 11 Mar 2007 13:35:53 -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.173]) by postgresql.org (Postfix) with ESMTP id 628E39FA2C4 for ; Sun, 11 Mar 2007 13:35:52 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so1838897ugf for ; Sun, 11 Mar 2007 09:35:51 -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:content-transfer-encoding:content-disposition:references; b=sjygT15hMv8JNIvw7PeliBS+wE1xeQIv8K/y2hwzOnR+u1C6AbyGQDRnR6r6Bv4OgWe0wJv/T8Ytb6J/6JVyHfxl7PazVlykeGvMIMybr+AAFhAN6Gz88DHQUhcsx1rm8Cvkij4lNjTxFIpD6jLcEKRj4NjhsqEehCTc9pSyFwE= 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:content-transfer-encoding:content-disposition:references; b=rerzeH+xZAPtB29pYpWxsANWsAV4MpZVlmJNrTDuJ9rhK36WSjLFl6C7Eycl0YGXNoCB1xJfYXIZjONIIM7hPKEgvfBiccUCvhQrMoPUzb+91gBu/uAtJ763/pBL0KBn/zkEggxVE6CPjhUpgSSgbJE/JxhFl08Q5y6FyXIIHdg= Received: by 10.114.25.3 with SMTP id 3mr939185way.1173630950219; Sun, 11 Mar 2007 09:35:50 -0700 (PDT) Received: by 10.114.181.14 with HTTP; Sun, 11 Mar 2007 09:35:50 -0700 (PDT) Message-ID: <36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com> Date: Sun, 11 Mar 2007 12:35:50 -0400 From: "Jonah H. Harris" To: "Ezequias Rodrigues da Rocha" Subject: Re: There is acid without transactions ? Cc: PostgreSQL In-Reply-To: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <55c095e90703110905u2fc29639v6b205ee806a3ba22@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/137 X-Sequence-Number: 27775 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 | 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/