Re: BUG #11353: Documentation for SET AUTOCOMMIT is wrong

On Thu, Sep 4, 2014 at 09:04:43AM +0000, andreas(dot)papst(at)univie(dot)ac(dot)at wrote:
> The following bug has been logged on the website:
>
> Bug reference: 11353
> Logged by: Andreas Papst
> Email address: andreas(dot)papst(at)univie(dot)ac(dot)at
> PostgreSQL version: 9.1.14
> Operating system: Debian 7
> Description:
>
> db=> SET AUTOCOMMIT = OFF
> db=> ;
>
> ERROR: SET AUTOCOMMIT TO OFF is no longer supported

Autocommit is now set per-client application, not at the server level,
so it is \set in psql:

test=> \set AUTOCOMMIT off
test=> select 1 ;
?column?
----------
1
(1 row)

test=> commit;

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +