Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id ABD189FB66A for ; Tue, 13 Mar 2007 12:15:40 -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 09696-05 for ; Tue, 13 Mar 2007 12:15:29 -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 E1A009FB407 for ; Tue, 13 Mar 2007 12:15:29 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x4so2565937nfb for ; Tue, 13 Mar 2007 08:15:28 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=QmdfNoWaoaxp/26yDeVrO7cdBmujmw13F8HZ49isglGfSqf6yZ+/PTQ4rhnLHikPlLA4YkZPuhs55jhi4BAn2d3i2Dr5pvrrLIZk/Trl61xUCGhXf+QdJaGORZSwJa0iZm6yPEidMVHpbQaI8bHrM1YCaYas1ENSHUoc+y8BFqw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=RdUSE1x/1th/MItc1jEkO03t3SprbtycstQu9IoTRm8xtDBEUFnVIMgx9b3yfL0wx2tJfNyGZgQp81TJUEnoNrXxVE7dDDh6xeNLjCZSILIVtAVPXPNdsqSJQJtbkyqrtprZUsfhgcuOwIbD2UQ8J4eCuJJ53u24qM89gpt7LAU= Received: by 10.82.167.5 with SMTP id p5mr1900114bue.1173798927659; Tue, 13 Mar 2007 08:15:27 -0700 (PDT) Received: from ?192.168.1.34? ( [82.3.248.145]) by mx.google.com with ESMTP id z40sm17973954ikz.2007.03.13.08.15.24; Tue, 13 Mar 2007 08:15:25 -0700 (PDT) Message-ID: <45F6C010.3000207@enterprisedb.com> Date: Tue, 13 Mar 2007 15:15:28 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: "Dengler, Michael" CC: pgsql-performance@postgresql.org Subject: Re: Autocommit in libpq References: <03C8E1672F290B44B20D46DB98ED36220588E19C@tvpmail.ad.liberate.com> In-Reply-To: <03C8E1672F290B44B20D46DB98ED36220588E19C@tvpmail.ad.liberate.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/228 X-Sequence-Number: 23633 Dengler, Michael wrote: > Please forgive me if I missed something (I have been searching for a definitive answer for this for 2 days). > > Is there any way to disable autocommit in libpq? (PG 7.4.1) Just call BEGIN to start a transaction, and COMMIT to commit it. Other than that, no. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com