Re: FW: Query execution failure - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: FW: Query execution failure
Date
Msg-id ZSWud549Aaw1o3l_@momjian.us
Whole thread Raw
In response to Re: FW: Query execution failure  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
On Thu, Sep 28, 2023 at 09:48:02AM -0400, Bruce Momjian wrote:
> On Wed, Sep 27, 2023 at 10:27:34PM -0400, Bruce Momjian wrote:
> > 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.
> 
> I now think the fdw docs are the wrong place for this since it is a user
> requirement, not a developer one.  I put it in CREATE SERVER, patch
> attached.

Patch applied back to PG 11.

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

  Only you can decide what is important to you.



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18152: Join condition is not pushed down to union all subquery
Next
From: PG Bug reporting form
Date:
Subject: BUG #18154: Corrupt DB: pg_dump segfaults or returns empty