Re: problem with set autocommit to off

On Mon, Mar 28, 2005 at 06:09:22PM +0530, Rajarshi Mukherjee wrote:
>
> i am not being able to set the default autocommit feature of PG to off.
> i am using PG 8.0 Windows version and the following command :
> SET AUTOCOMMIT TO OFF
> throwing an error:
> ERROR:  SET AUTOCOMMIT TO OFF is no longer supported

Server-side autocommit was removed in 7.4 so now it's just a
client-side behavior.  In psql you can use "\set AUTOCOMMIT off";
otherwise see the documentation for your client interface.

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