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/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
