BUG #11353: Documentation for SET AUTOCOMMIT is wrong

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs