Re: [BUGS] BUG #14772: psql autocommit does not work - Mailing list pgsql-bugs

From alain bourgeois
Subject Re: [BUGS] BUG #14772: psql autocommit does not work
Date
Msg-id OF7E3F8105.BE9A375E-ONC1258176.0049767B-C1258176.004984A3@LocalDomain
Whole thread Raw
In response to Re: [BUGS] BUG #14772: psql autocommit does not work  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: [BUGS] BUG #14772: psql autocommit does not work
List pgsql-bugs
also, the semicolumn, needed for some statementds (sql) but not all.

Alain Bourgeois
Software Engineer
Tel: +32 (0)2 333 49 20

Mobile: +32 (0)496 51 85 75
skype: abozetes
ZETES PASS, division of ZETES SA/NV
Disclaimer : This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you receive this message in error, please contact the sender and delete the material from any computer.





From:        Fabien COELHO <coelho@cri.ensmp.fr>
To:        alain bourgeois <a.bourgeois@zetescards.be>
Cc:        abo@zetescards.be, PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
Date:        08-08-17 15:02
Subject:        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.



pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [BUGS] BUG #14772: psql autocommit does not work
Next
From: Fabien COELHO
Date:
Subject: Re: [BUGS] BUG #14772: psql autocommit does not work