Re: [GENERAL] Set autocommit to off

2005-08-18 Thread Aliomar Mariano Rego
Michael Fuhr escreveu: On Wed, Aug 17, 2005 at 08:24:00AM +, 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://ww

Re: [GENERAL] Set autocommit to off

2005-08-17 Thread Tino Wildenhain
Andreas Kretschmer schrieb: Aliomar Mariano Rego <[EMAIL PROTECTED]> schrieb: Does somebody knows why the Postgresql 7.4.8 or later doesn't supports the option "SET AUTOCOMMIT TO OFF"? \set AUTOCOMMIT off works fine in 8.0.3 yes, buts psql, not the backend :-) --

Re: [GENERAL] Set autocommit to off

2005-08-17 Thread Michael Fuhr
On Wed, Aug 17, 2005 at 08:24:00AM +, 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

Re: [GENERAL] Set autocommit to off

2005-08-17 Thread Andreas Kretschmer
Aliomar Mariano Rego <[EMAIL PROTECTED]> schrieb: > Does somebody knows why the Postgresql 7.4.8 or later doesn't supports > the option "SET AUTOCOMMIT TO OFF"? \set AUTOCOMMIT off works fine in 8.0.3 Regards, Andreas -- Diese Message wurde erstellt mit freundlicher Unterstützung eines freila

Re: [GENERAL] Set autocommit to off

2005-08-17 Thread Sean Davis
On 8/17/05 4:24 AM, "Aliomar Mariano Rego" <[EMAIL PROTECTED]> wrote: > Does somebody knows why the Postgresql 7.4.8 or later doesn't supports > the option "SET AUTOCOMMIT TO OFF"? See this message: http://archives.postgresql.org/pgsql-general/2005-07/msg00064.php In short, server-side autocomm

[GENERAL] Set autocommit to off

2005-08-17 Thread Aliomar Mariano Rego
Does somebody knows why the Postgresql 7.4.8 or later doesn't supports the option "SET AUTOCOMMIT TO OFF"? Thanks. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] SET AUTOCOMMIT TO OFF is no longer supported

2005-07-03 Thread Michael Fuhr
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 longe

[GENERAL] SET AUTOCOMMIT TO OFF is no longer supported

2005-07-03 Thread Jamie Deppeler
Hi, 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. I have tried using 2 drivers 7.4 and 8 jdbc driver st