The following bug has been logged on the website:
Bug reference: 14658
Logged by: Stefan Lindner
Email address: lindner(at)visionet(dot)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?