Re: psql - add special variable to reflect the last query status
Fabien COELHO <coelho@cri.ensmp.fr>
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Developers <pgsql-hackers@postgresql.org>
Date: 2017-06-28T07:25:52Z
Lists: pgsql-hackers
Attachments
- psql-result-status-5.patch (text/x-diff) patch
Hello Pavel, >> I agree that the existing "SetVariableBool" function is a misnommer, it >> should be "SetVariableOn" given what it does, and it is not what we >> need. > > switching default setting from ON to TRUE requires wider discussion - Yep. > in this moment I like to have special function "SetVariableON". I'm fine with this, but this make it a change totally unrelated to this patch as it would not use the function... Moreover, this function would not use an hypothetical "set var bool" function because of the debatable on/off vs true/false change. Also, a "set var bool" function would be called only twice, which is not very beneficial for a oneliner, so I left it out. >> I agree that there is some common structure, but ISTM that the >> AcceptResult function is called in a variety of situation where variables >> are not to be set (eg "internal" queries, not user provided queries), so I >> thought it best to keep the two apart. > > I understand, but It is not nice, really - maybe only switch can be moved > to some inlining function like IsSuccess() - more .. with this function, > the SetResultVariables function will be more cleaner Indeed. Attached v5 does that. -- Fabien.
Commits
-
Add psql variables to track success/failure of SQL queries.
- 69835bc89888 11.0 landed