Re: BUG #11353: Documentation for SET AUTOCOMMIT is wrong - Mailing list pgsql-bugs

On Thu, Sep  4, 2014 at 09:04:43AM +0000, andreas.papst@univie.ac.at wrote:
> The following bug has been logged on the website:
>
> Bug reference:      11353
> Logged by:          Andreas Papst
> Email address:      andreas.papst@univie.ac.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +