Re: BUG #13841: Unable to set autocommit in psql - Mailing list pgsql-bugs

Hi,

2016-01-01 16:10 GMT+01:00 <floriparob@gmail.com>:

> The following bug has been logged on the website:
>
> Bug reference:      13841
> Logged by:          ROBERT
> Email address:      floriparob@gmail.com
> PostgreSQL version: 9.5rc1
> Operating system:   Debian stretch/sid
> Description:
>
> O/S
>
> Linux roblaptop 4.3.0-1-amd64 #1 SMP Debian 4.3.3-2 (2015-12-17) x86_64
> GNU/Linux
>
>
> psql session
>
> psql (9.5rc1)
> Type "help" for help.
>
> timemanager=> set autocommit off;
> ERROR:  syntax error at or near "off"
> LINE 1: set autocommit off;
>                        ^
> timemanager=> set autocommit 'off';
> ERROR:  syntax error at or near "'off'"
> LINE 1: set autocommit 'off';
>                        ^
> timemanager=> set autocommit to off;
> ERROR:  unrecognized configuration parameter "autocommit"
> timemanager=> SET AUTOCOMMIT TO OFF;
> ERROR:  unrecognized configuration parameter "autocommit"
> timemanager=>
>
> Thought that I'd made a typo but entered as per doco.
>
>
There's no autocommit GUC. You probably want to use the AUTOCOMMIT internal
variable of psql. In which case, you should do :

\set AUTOCOMMIT off

Definitely not a bug.


--
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com