X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 17F083A4DCF for ; Mon, 29 Nov 2004 09:47:32 +0000 (GMT) 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 43157-08 for ; Mon, 29 Nov 2004 09:47:28 +0000 (GMT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 705B53A4D51 for ; Mon, 29 Nov 2004 09:47:28 +0000 (GMT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Mon Nov 29 10:47:23 2004 +0100 Received: from rodos.fzk.de (resy6.fzk.de [141.52.68.10]) by resy5.fzk.de (8.12.7/8.12.7/SuSE Linux 0.6) with ESMTP id iAT9lMsG026379 for ; Mon, 29 Nov 2004 10:47:22 +0100 Message-ID: <41AAF028.E8DCF9AB@rodos.fzk.de> Date: Mon, 29 Nov 2004 10:47:21 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: version 7.4 autocommit removed Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS - amavis-milter (http://www.amavis.org/) 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: 200411/283 X-Sequence-Number: 19601 The Release Notes on 7.4 state Observe the following incompatibilities: The server-side autocommit setting was removed and reimplemented in client applications and languages. Server-side autocommit was causing too many problems with languages and applications that wanted to control their own autocommit behavior, so autocommit was removed from the server and added to individual client APIs as appropriate. So I tried set autocommit to off after connecting to my database and expected a session-wide autocommit off. It failed saying SET AUTOCOMMIT TO OFF is no longer supported Could someone please enlighten me how this first sentence should be understood: The server-side autocommit setting was removed and reimplemented in client applications and languages. Regards, Christoph