Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
От
Michael Paquier
Тема
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
Дата
Msg-id
Yql3sc3cvYvLlEHu@paquier.xyz
Ответ на
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error (Michael Paquier)
Список
Дерево обсуждения
BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error PG Bug reporting form <noreply@postgresql.org>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Christoph Berg <christoph.berg@credativ.de>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Robert Haas <robertmhaas@gmail.com>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error "David G. Johnston" <david.g.johnston@gmail.com>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
psql --on-error-stop (Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still) commits after client-side error Christoph Berg <christoph.berg@credativ.de>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Christoph Berg <christoph.berg@credativ.de>
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier <michael@paquier.xyz>
On Tue, Jun 14, 2022 at 10:31:21AM +0900, Michael Paquier wrote: > Okay, let's do so then on HEAD. I'll wait a bit more, in case others > have an opinion to offer on the matter. Well, done. One thing that I find a bit surprising in all that is the lack of consistency in the handling of the return code of psql when the last switch fails when not using ON_ERROR_STOP. For example, psql fails if the last switch is a slash command from -c, but succeeds if the last switch is a slash command in a file from -f that exists. This comes down to the way failures are passed down from MainLoop() so I am not sure if this is worth worrying about and nobody has complained about that AFAIK, but I have added some extra tests to at least document everything I could think about to track changes, in case somebody plays with this code in the future. -- Michael
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: Christoph Berg
Дата: