Re: [BUGS] BUG #14772: psql autocommit does not work

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