X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DE1CFD1B46E for ; Fri, 9 Jan 2004 21:32:37 +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 88689-07 for ; Fri, 9 Jan 2004 17:32:08 -0400 (AST) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id 9E5F3D1B42F for ; Fri, 9 Jan 2004 17:32:05 -0400 (AST) Received: (qmail 14154 invoked by uid 506); 9 Jan 2004 21:32:06 -0000 Received: from thampton@limacorp.com by garbanzo.limacorp.com by uid 506 with qmail-scanner-1.16 (spamassassin: 2.55. Clear:. Processed in 0.025968 secs); 09 Jan 2004 21:32:06 -0000 Received: from unknown (HELO limacorp.com) (24.123.167.82) by garbanzo.limacorp.com with SMTP; 9 Jan 2004 21:32:05 -0000 Message-ID: <3FFF1D99.9090402@limacorp.com> Date: Fri, 09 Jan 2004 16:31:05 -0500 From: Terry Hampton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Default Transaction Mode Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/75 X-Sequence-Number: 11938 Is it possible to configure Postgres, or to start PG daemons so that it operates in a transaction mode by default ? We do a lot of work at the PG prompt, and I'd like to have one additional "safety net" - to manual commit all SQL's. Sure - I can "begin work" etc. but I'd like that to be automatic. Thanks, Terry -- Terry L. Hampton Program Manager LimaCorp, LLC. www.limacorp.com 513.587.1874