[BUGS] BUG #14658: psql set autocommit in command line

Поиск
Список
Период
Сортировка
Искать
От
lindner@visionet.de
Тема
[BUGS] BUG #14658: psql set autocommit in command line
Дата
в 11:31:15
Msg-id
20170518083115.1451.52294@wrigleys.postgresql.org
Список
Дерево обсуждения
[BUGS] BUG #14658: psql set autocommit in command line lindner@visionet.de
Re: [BUGS] BUG #14658: psql set autocommit in command line Tom Lane <tgl@sss.pgh.pa.us>
The following bug has been logged on the website:

Bug reference:      14658
Logged by:          Stefan Lindner
Email address:      lindner@visionet.de
PostgreSQL version: 9.6.3
Operating system:   CentOS 7.2
Description:        

We have set AUTOCOMMIT to off in our global psqlrc file.

If I do the following, I can set it to on:
> psql
# \set AUTOCOMMIT on
# \echo :AUTOCOMMIT
on

Now I start psql with command line parameters

> psql --set AUTOCOMMIT on
# \echo :AUTOCOMMIT
off

I expected that the command line --set overrides the global setting in
psqlrc file.

Am I wrong?

And how can I set AUTOCOMMIT to ON per command line if I was wrong?


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
В списке pgsql-bugs по дате отправления
От: Dilip Kumar
Дата:
От: Sveinn Sveinsson
Дата:
FAQ