X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 424D9475D3B
	for <pgsql-sql@postgresql.org>; Thu,  3 Apr 2003 12:09:25 -0500 (EST)
Received: from web12707.mail.yahoo.com (web12707.mail.yahoo.com
	[216.136.173.244])
	by postgresql.org (Postfix) with SMTP id 6FAE3475CEE
	for <pgsql-sql@postgresql.org>; Thu,  3 Apr 2003 12:09:20 -0500 (EST)
Message-ID: <20030403170925.22850.qmail@web12707.mail.yahoo.com>
Received: from [68.35.166.87] by web12707.mail.yahoo.com via HTTP;
	Thu, 03 Apr 2003 09:09:25 PST
Date: Thu, 3 Apr 2003 09:09:25 -0800 (PST)
From: chester c young <chestercyoung@yahoo.com>
Subject: Re: auto-commit
To: pgsql-sql@postgresql.org
In-Reply-To: <3e8be17a_1@news.iprimus.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Spam-Status: No,
 hits=-5.1 required=5.0 tests=BAYES_20,IN_REP_TO,RCVD_IN_RFCI
	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/42
X-Sequence-Number: 12743

> I have a need to turn auto-commit off.
> 
> Thank  you
> 
> Hubert Krenske

bracket your transaction with:

begin
<dml>
end;


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com