Hello Alain,
> testdb=# \set autocommit off;
Hmmm.
The special variable name is "AUTOCOMMIT", and you are creating an
unrelated "autocommit" lower case variable instead. Client-side variable
names are case sensitive. Maybe that was not a good idea, especially given
than SQL is case insensitive, but it is probably too late to change
that...
With the right name you would get a clear error message.
psql> \set AUTOCOMMIT off; unrecognized value "off;" for "AUTOCOMMIT": boolean expected
I'm not sure what to do. Maybe generate a warning if a special variable
name is used uncapitalized...
> OK I found : \set AUTOCOMMIT false
> (without any semicolumn)
Yep.
--
Fabien.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs