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