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/