[BUGS] BUG #14658: psql set autocommit in command line - Mailing list pgsql-bugs

From lindner@visionet.de
Subject [BUGS] BUG #14658: psql set autocommit in command line
Date
Msg-id 20170518083115.1451.52294@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14658: psql set autocommit in command line  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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 by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: [BUGS] BUG #14657: Server process segmentation fault in v10, May10th dev snapshot
Next
From: Sveinn Sveinsson
Date:
Subject: Re: [BUGS] BUG #14657: Server process segmentation fault in v10, May10th dev snapshot