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

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: BUG #13841: Unable to set autocommit in psql
Дата
Msg-id CAECtzeXG+g_iLwdabKNatvFJrhemwGMUCgqNinANuQGPSP1eXg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #13841: Unable to set autocommit in psql  (floriparob@gmail.com)
Ответы Re: BUG #13841: Unable to set autocommit in psql  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: floriparob@gmail.com
Дата:
Сообщение: BUG #13841: Unable to set autocommit in psql
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #13841: Unable to set autocommit in psql