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

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

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. +

On Fri, Sep 5, 2014 at 12:03 AM, Bruce Momjian <bruce@momjian.us> wrote:
> On Thu, Sep  4, 2014 at 09:04:43AM +0000, andreas.papst@univie.ac.at wrote:
>> ERROR:  SET AUTOCOMMIT TO OFF is no longer supported
> Autocommit is now set per-client application, not at the server level,
This modification of behavior has been done in 7.4. You can refer to
the release notes of this time for more details about the reason why
server-side autocommit has been removed:
http://www.postgresql.org/docs/devel/static/release-7-4.html
Regards,
--
Michael