| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | alain bourgeois <a(dot)bourgeois(at)zetescards(dot)be> |
| Cc: | abo(at)zetescards(dot)be, PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #14772: psql autocommit does not work |
| Date: | 2017-08-08 13:02:05 |
| Message-ID: | alpine.DEB.2.20.1708081456470.10425@lancre |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | alain bourgeois | 2017-08-08 13:23:00 | Re: BUG #14772: psql autocommit does not work |
| Previous Message | Hillel Eilat | 2017-08-08 08:34:22 | Re: BUG #14771: "Logical decoding" does not cover the impact of "TRUNCATE TABLE" command |