Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1n2Tc3-00021y-BG
	for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Dec 2021 07:43:07 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1n2Tc2-0005NS-64
	for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Dec 2021 07:43:06 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <coelho@cri.ensmp.fr>)
	id 1n2Tc1-0005NJ-To
	for pgsql-hackers@lists.postgresql.org; Wed, 29 Dec 2021 07:43:05 +0000
Received: from sfr-1.cri.mines-paristech.fr ([77.158.180.225]
 helo=smtp.cri.ensmp.fr)
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <coelho@cri.ensmp.fr>)
	id 1n2Tby-0006Uq-Ey
	for pgsql-hackers@lists.postgresql.org; Wed, 29 Dec 2021 07:43:04 +0000
Received: from pc32.home (alyon-553-1-20-29.w92-129.abo.wanadoo.fr
 [92.129.118.29])
	by smtp.cri.ensmp.fr (Postfix) with ESMTPSA id EF29EC0220;
	Wed, 29 Dec 2021 08:45:54 +0100 (CET)
Date: Wed, 29 Dec 2021 08:42:53 +0100 (CET)
From: Fabien COELHO <coelho@cri.ensmp.fr>
X-X-Sender: fabien@pseudo
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Subject: Re: psql - add SHOW_ALL_RESULTS option
In-Reply-To: <10906444-d995-0a34-bb22-faf6d9f07f92@enterprisedb.com>
Message-ID: <alpine.DEB.2.22.394.2112290832290.1019176@pseudo>
References: <69C0B369-570C-4524-8EE4-BCCACECB6BEE@amazon.com>
 <20210412193301.GA11204@alvherre.pgsql> <YHeVHH0wVcRwdogL@paquier.xyz>
 <3738387.1618451507@sss.pgh.pa.us>
 <alpine.DEB.2.22.394.2104151336060.191178@pseudo>
 <451a2111-3757-c511-9413-8f8af531a167@enterprisedb.com>
 <alpine.DEB.2.22.394.2106121130400.4105466@pseudo>
 <CALDaNm0+pzGgp-M1mAoUVYRtjadbWYuB96J8RaV9iH3+HA8FTA@mail.gmail.com>
 <alpine.DEB.2.22.394.2107151742300.1705285@pseudo>
 <18c78a01-4a34-9dd4-f78b-6860f1420c8e@enterprisedb.com>
 <alpine.DEB.2.22.394.2107221655020.25741@pseudo>
 <6954328d-96f2-77f7-735f-7ce493a40949@enterprisedb.com>
 <alpine.DEB.2.22.394.2109251058000.3216312@pseudo>
 <alpine.DEB.2.22.394.2110021622530.2817726@pseudo>
 <2570e2ae-fa0f-aac9-f72f-bb59a9983a20@enterprisedb.com>
 <alpine.DEB.2.22.394.2112230703530.2668598@pseudo>
 <10906444-d995-0a34-bb22-faf6d9f07f92@enterprisedb.com>
User-Agent: Alpine 2.22 (DEB 394 2020-01-19)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/alpine.DEB.2.22.394.2112290832290.1019176%40pseudo>
Precedence: bulk


>> [...]
>
> I agree that these two behaviors in libpq are dubious, especially the 
> second one.  I want to spend some time analyzing this more and see if 
> fixes in libpq might be appropriate.

Ok.

My analysis is that fixing libpq behavior is not in the scope of a psql 
patch, and that if I was to do that it was sure delay the patch even 
further. Also these issues/features are corner cases that provably very 
few people bumped into.

-- 
Fabien.