Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0DA329FB2E8 for ; Sun, 11 Mar 2007 17:30:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 01165-04 for ; Sun, 11 Mar 2007 17:30:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 74B189FB2AC for ; Sun, 11 Mar 2007 17:30:52 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x4so1754015nfb for ; Sun, 11 Mar 2007 13:30: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=SD0LBN8d5lAbqM8cQ8CMLo0PVzUrroSiADzLMTRNaBCxjD3qWAZrF3kA7/UKQ3W2UTM77jNWbS1etm4Fl2R3knwt+SPL0Qhi+h6WLKHJHa2Aq9p4fmB+3G/Hwgx3GY6QMetZZkH9GFH2ae/yWZYqJXuUf0D3IU5NKFjUteWGZ6Y= 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=HJI7Ww6wTaxnY/oZAhUmDk4jsA0HoeQemK10aSeogLMUUV1i8h7pKDMa7zNJwbB0guDsoudqpEo9RkVwf4t703YbYi9dP5fqR1KPfPV+ymCPZQn/8aUewD1SrxTSuxYRIfurIH5yFmsPyVQQyLoKniNx/ojiY/PAKGyqFFro0bE= Received: by 10.114.148.1 with SMTP id v1mr987952wad.1173645049682; Sun, 11 Mar 2007 13:30:49 -0700 (PDT) Received: by 10.114.181.14 with HTTP; Sun, 11 Mar 2007 13:30:49 -0700 (PDT) Message-ID: <36e682920703111330o7d2da7fcqbb503c08566be1f1@mail.gmail.com> Date: Sun, 11 Mar 2007 16:30:49 -0400 From: "Jonah H. Harris" To: "Ezequias Rodrigues da Rocha" Subject: Re: There is acid without transactions ? Cc: PostgreSQL In-Reply-To: <55c095e90703110939i7c414c48g1c14c3dc6e56ba30@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> <36e682920703110935j689a760aw477a5d2b132a3487@mail.gmail.com> <55c095e90703110939i7c414c48g1c14c3dc6e56ba30@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/142 X-Sequence-Number: 27780 On 3/11/07, Ezequias Rodrigues da Rocha wrote: > Perfect. I just don't know what drivers you are talking about (odbc maybe). As the server no longer supports server-side autocommit, I believe all of the drivers create an explicit transaction behind the scenes when the user requests autocommit to be turned off. That way, the drivers can allow the user to control the transaction state. The only mainstream driver I know of which doesn't act this way is libpq, where there is no way to turn off "autocommit" unless you explicitly create the transaction yourself with BEGIN. However, I'm sure each of the driver authors will correct me if I'm wrong :) -- 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/