Received: from mail-int.msro.detemobil.de (pollux.MSRO.DeTeMobil.de [193.254.159.3]) by hub.org (8.8.8/8.8.8) with ESMTP id KAA13381 for ; Thu, 17 Sep 1998 10:13:32 -0400 (EDT) (envelope-from ajoppich@usa.net) Received: from dxca22.bn.DeTeMobil.de (localhost [127.0.0.1]) by mail-int.msro.detemobil.de (8.8.8/8.8.8/DTM-ZENTRALE-2.1) with ESMTP id QAA09942 for ; Thu, 17 Sep 1998 16:12:50 +0200 (MET DST) Received: from dxcl01.bn.DeTeMobil.de (root@dxcl01.bn.DeTeMobil.de [192.108.75.153]) by dxca22.bn.DeTeMobil.de (8.8.8/8.8.8) with SMTP id QAA30467 for ; Thu, 17 Sep 1998 16:12:49 +0200 (MET DST) Received: by dxcl01.bn.DeTeMobil.de (5.65/DEC-Ultrix/4.3) id AA28862; Thu, 17 Sep 1998 16:12:48 +0200 Message-Id: <360118DF.37BC@usa.net> Date: Thu, 17 Sep 1998 16:12:47 +0200 From: Andreas Joppich Reply-To: ajoppich@usa.net X-Mailer: Mozilla 3.01 [de] (WinNT; I) Mime-Version: 1.0 To: pgsql-sql Subject: Turn autocommit off ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi there ! It has now happened several times that I wanted to rollback some changes (like update, delete,...) I made to some tables. And since I always forget to start a transaction, a simple ROLLBACK doesn't work because of that quiet annoying autocommit in psql. I'd like to have automatically started a transaction which explicitly must be termintated with commit or rollback. Is there a way to turn autocommit off ? If not, perhaps it could be a feature for the todo list ? I'm currently using the cvs from last sunday on linux 2.1.119. Thanks for any hints. Andreas