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 ECB1CD1ED9E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 27 Mar 2004 03:23:22 +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 02136-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Mar 2004 23:23:29 -0400 (AST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 7AA22D1DCF6
	for <pgsql-sql@postgresql.org>; Fri, 26 Mar 2004 23:23:19 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2R3NRaS001226;
	Fri, 26 Mar 2004 22:23:28 -0500 (EST)
To: Kemin Zhou <kemin.zhou@ferring.com>
Cc: "pgsql-sql @ postgresql . org" <pgsql-sql@postgresql.org>
Subject: Re: autocommit 
In-reply-to: <4064850F.5000104@ferring.com> 
References: <4064850F.5000104@ferring.com>
Comments: In-reply-to Kemin Zhou <kemin.zhou@ferring.com>
	message dated "Fri, 26 Mar 2004 11:31:27 -0800"
Date: Fri, 26 Mar 2004 22:23:27 -0500
Message-ID: <1225.1080357807@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/259
X-Sequence-Number: 17358

Kemin Zhou <kemin.zhou@ferring.com> writes:
> Could we add one simple switch to psql (the client front end or the 
> library) --noautocommit?

psql already has this, see \set AUTOCOMMIT.

			regards, tom lane