Re: Set autocommit to off - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Set autocommit to off
Date
Msg-id 20050817130048.GB19186@winnie.fuhr.org
Whole thread Raw
In response to Set autocommit to off  (Aliomar Mariano Rego <aliomar.rego@embrapa.br>)
Responses Re: Set autocommit to off  (Aliomar Mariano Rego <aliomar.rego@embrapa.br>)
List pgsql-general
On Wed, Aug 17, 2005 at 08:24:00AM +0000, Aliomar Mariano Rego wrote:
> Does somebody knows why the Postgresql 7.4.8 or later doesn't supports
> the option "SET AUTOCOMMIT TO OFF"?

Because server-side autocommit was a bad idea.  See the 7.4 Release Notes.

http://www.postgresql.org/docs/7.4/static/release-7-4.html

"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."

--
Michael Fuhr

pgsql-general by date:

Previous
From: Poul Møller Hansen
Date:
Subject: Finding nearest numeric value
Next
From: Tino Wildenhain
Date:
Subject: Re: Set autocommit to off