Re: BUG #13841: Unable to set autocommit in psql

Hi,

2016-01-01 16:10 GMT+01:00 <floriparob(at)gmail(dot)com>:

> The following bug has been logged on the website:
>
> Bug reference: 13841
> Logged by: ROBERT
> Email address: floriparob(at)gmail(dot)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