X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6E70A329E8F for ; Sun, 17 Oct 2004 22:25:16 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36867-08 for ; Sun, 17 Oct 2004 21:25:05 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 085F2329E8E for ; Sun, 17 Oct 2004 22:25:05 +0100 (BST) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id i9HLP44S011279 for ; Sun, 17 Oct 2004 17:25:04 -0400 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id i9HLP31d011276 for ; Sun, 17 Oct 2004 17:25:03 -0400 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Sun, 17 Oct 2004 17:25:03 -0400 (EDT) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: pgsql-admin@postgresql.org Subject: Re: set AUTOCOMMIT OFF in psqlrc not having affect In-Reply-To: <200410172107.i9HL7dS18932@candle.pha.pa.us> Message-ID: References: <200410172107.i9HL7dS18932@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/205 X-Sequence-Number: 15198 Thanks Tom, it appears that was the issue. Bruce, it would appear it was at some point? Glad to hear it's now insensitive. On Sun, 17 Oct 2004, Bruce Momjian wrote: > > FYI, it is not case-sensitive in current CVS. > > Tom Lane wrote: >> Christian Fowler writes: >>> I have \set AUTOCOMMIT OFF in my .psqlrc and it seems psql seems to not >>> have any effect. >> >> I think the value is case-sensitive. Try >> \set AUTOCOMMIT off > [ \ / [ >X< Christian Fowler | spider@viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org