Re: psql - add SHOW_ALL_RESULTS option
От
Fabien COELHO
Тема
Re: psql - add SHOW_ALL_RESULTS option
Дата
Msg-id
alpine.DEB.2.21.1907260738240.13195@lancre
Ответ на
Re: psql - add SHOW_ALL_RESULTS option (Kyotaro Horiguchi)
Список
Дерево обсуждения
psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
RE: psql - add SHOW_ALL_RESULTS option "Iwata, Aya" <iwata.aya@jp.fujitsu.com>
RE: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
RE: psql - add SHOW_ALL_RESULTS option "Daniel Verite" <daniel@manitou-mail.org>
Re: psql - add SHOW_ALL_RESULTS option Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option "Daniel Verite" <daniel@manitou-mail.org>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option "Daniel Verite" <daniel@manitou-mail.org>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option "Daniel Verite" <daniel@manitou-mail.org>
Re: psql - add SHOW_ALL_RESULTS option Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Alvaro Herrera <alvherre@2ndquadrant.com>
Re: psql - add SHOW_ALL_RESULTS option vignesh C <vignesh21@gmail.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option vignesh C <vignesh21@gmail.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: psql - add SHOW_ALL_RESULTS option Tom Lane <tgl@sss.pgh.pa.us>
Re: psql - add SHOW_ALL_RESULTS option Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: psql - add SHOW_ALL_RESULTS option Alvaro Herrera <alvherre@2ndquadrant.com>
Re: psql - add SHOW_ALL_RESULTS option "Daniel Verite" <daniel@manitou-mail.org>
Re: psql - add SHOW_ALL_RESULTS option Tom Lane <tgl@sss.pgh.pa.us>
Re: psql - add SHOW_ALL_RESULTS option "Daniel Verite" <daniel@manitou-mail.org>
Re: psql - add SHOW_ALL_RESULTS option Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Thomas Munro <thomas.munro@gmail.com>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Michael Paquier <michael@paquier.xyz>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
RE: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
RE: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
RE: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
RE: psql - add SHOW_ALL_RESULTS option Fabien COELHO <coelho@cri.ensmp.fr>
Hello Kyotaro-san, >> Attached a v2 for the always-show-all-results variant. Thanks for the >> debug! > > I have some comments on this patch. > > I'm +1 for always output all results without having knobs. That makes 4 opinions expressed towards this change of behavior, and none against. > Documentation (psql-ref.sgml) has another place that needs the > same amendment. Indeed. > Looking the output for -t, -0, -A or something like, we might need > to introduce result-set separator. Yep, possibly. I'm not sure this is material for this patch, though. > # -eH looks broken for me but it would be another issue. It seems to work for me. Could you be more precise about how it is broken? > Valid setting of FETCH_COUNT disables this feature. I think it is > unwanted behavior. Yes and no: this behavior (bug, really) is pre-existing, FETCH_COUNT does not work with combined queries: sh> /usr/bin/psql psql (12beta2 ...) fabien=# \set FETCH_COUNT 2 fabien=# SELECT 1234 \; SELECT 5432 ; fabien=# same thing with pg 11.4, and probably down to every version of postgres since the feature was implemented... I think that fixing this should be a separate bug report and patch. I'll try to look at it. Thanks for the feedback. Attached v3 with further documentation updates. -- Fabien.
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Kyotaro Horiguchi
Дата: