From: | Aliomar Mariano Rego <aliomar(dot)rego(at)embrapa(dot)br> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Set autocommit to off |
Date: | 2005-08-18 10:12:55 |
Message-ID: | 43045F27.8010507@embrapa.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michael Fuhr escreveu:
>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."
>
>
>
Thanks for your help. I had to install Dspace release 1.3.1
(http://sourceforge.net/projects/dspace/) and during the installation
process I have had an error "SET AUTOCOMMIT TO OFF is no longer
supported" at Postgresql-7.4.8 and Postgresql-8.0.3. So I installed
Postgres-7.3.10 and everything worked well.
Thanks for your attention.
From | Date | Subject | |
---|---|---|---|
Next Message | Ronzani Dario | 2005-08-18 12:15:36 | R: Linux Postgres authentication against active directory |
Previous Message | WireSpot | 2005-08-18 09:03:59 | Same database, different query plans |