Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qlgkg-003wTV-NB
	for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Sep 2023 02:27:42 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qlgke-007m3C-Rt
	for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Sep 2023 02:27:41 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1qlgke-007m30-Im
	for pgsql-bugs@lists.postgresql.org; Thu, 28 Sep 2023 02:27:41 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1qlgkb-0080QF-SD
	for pgsql-bugs@lists.postgresql.org; Thu, 28 Sep 2023 02:27:40 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us;
	s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID:
	Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID:
	Content-Description; bh=POWrty+zLybb09zcAcCZHmJpdZJc+WgzjEdIFMNxftI=; b=b7xfM
	106AZmSILRD41y4nfir4IvsbTl7soSEMXCJcSkMB3C0WIsCzqe4EPug0OfcMpGshKCecINAJsiQcq
	dfjx+0R9Qh2LSlCMhTS1rMk97RspwZAjSj/Wog6rHRVaySE/H2sdtr8Ld//Iteuzuis4PrRyJQYc5
	y7ljULiBf8Ylj7OyULRk6mHXP/R6E75b8e+2YW4FU7p6WNo4Nmy/AIaQoxThE0yuyu/1IfvvTy2LK
	am5anGqa/dPq727SnUpM2UJJk/cSXxuSW/GI/PKjgTzdRtT0fFGOA13JuSDVdUujIhUUDn23Qia1g
	uX2ZAW0bFacLtZCyC0QftVqyP7Xsw==;
Received: from bruce by momjian.us with local (Exim 4.96)
	(envelope-from <bruce@momjian.us>)
	id 1qlgkY-007SO0-17;
	Wed, 27 Sep 2023 22:27:34 -0400
Date: Wed, 27 Sep 2023 22:27:34 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pete Storer <Pete.Storer@sas.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: FW: Query execution failure
Message-ID: <ZRTklpZCVC0Hy/jp@momjian.us>
References: 
 <BL0PR05MB66282A9070EE621D031C27C7F3CE9@BL0PR05MB6628.namprd05.prod.outlook.com>
 <BL0PR05MB66283C57D72E321591AE4EB1F3CE9@BL0PR05MB6628.namprd05.prod.outlook.com>
 <2957101.1674746628@sss.pgh.pa.us>
 <BL0PR05MB66282D22D96AB745FBBD521FF3CF9@BL0PR05MB6628.namprd05.prod.outlook.com>
 <2961799.1674749201@sss.pgh.pa.us>
 <Y9fjfNpP7HZh1YX9@momjian.us>
 <ZRTQHKRhSLndfB5z@momjian.us>
 <802119.1695863173@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <802119.1695863173@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/ZRTklpZCVC0Hy/jp%40momjian.us>
Precedence: bulk

On Wed, Sep 27, 2023 at 09:06:13PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > The attached patch documents this remote sort order requirement.
> 
> That seems like quite a random place to insert the documentation.
> I doubt that the requirement applies only to upper paths -- FDWs
> are allowed to return sorted paths for base relations too,
> comparable to indexscan paths.

That is the only section of the docs that mentions sort pushdown.
I don't see another reasonable location.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.