| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Aliomar Mariano Rego <aliomar(dot)rego(at)embrapa(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Set autocommit to off |
| Date: | 2005-08-17 13:00:48 |
| Message-ID: | 20050817130048.GB19186@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2005-08-17 13:09:42 | Re: Postgresql server "crash" after some day |
| Previous Message | Stefano B. | 2005-08-17 12:55:31 | Postgresql server "crash" after some day |