X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 63B16D1ECFB for ; Fri, 26 Mar 2004 08:59:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 93527-06 for ; Fri, 26 Mar 2004 04:59:56 -0400 (AST) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id 8745ED1ECB9 for ; Fri, 26 Mar 2004 04:59:57 -0400 (AST) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 1B6nC2-000LEk-0X for pgsql-sql@postgresql.org; Fri, 26 Mar 2004 08:59:58 +0000 Date: Fri, 26 Mar 2004 08:59:56 +0000 From: Paul Thomas To: "pgsql-sql @ postgresql . org" Subject: Re: how to turn off autocommit in psql Message-ID: <20040326085956.A31033@bacon> References: <4063867B.10600@ferring.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <4063867B.10600@ferring.com>; from kemin.zhou@ferring.com on Fri, Mar 26, 2004 at 01:25:15 +0000 X-Mailer: Balsa 1.2.3 Lines: 19 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/246 X-Sequence-Number: 17345 On 26/03/2004 01:25 Kemin Zhou wrote: > I search far and wide and found a lot of disscussions about the > autocommit, but none about how to do it. After reading 50 pages, my > brain is numb. Could any one give me a simple help? > Thanks > > Kemin Use tranactions. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+