Re: SET AUTOCOMMIT TO OFF is no longer supported

On Mon, Jul 04, 2005 at 08:59:25AM +1000, Jamie Deppeler wrote:
>
> I am application that we have built using postgresql 8.0.3 and tomcat
> 5.0.28.  In the java code i have put  a state set autocomit to false
> which should be fine but comes up with the error SET AUTOCOMMIT TO OFF
> is no longer supported.

Server-side AUTOCOMMIT was removed in 7.4 for having been a Bad Idea.

http://www.postgresql.org/docs/7.4/static/release-7-4.html
http://archives.postgresql.org/pgsql-committers/2003-05/msg00080.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/