Re: v12.0: ERROR: could not find pathkey item to sort - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: v12.0: ERROR: could not find pathkey item to sort
Date
Msg-id 20191014143725.GD3599@telsasoft.com
Whole thread Raw
In response to v12.0: ERROR: could not find pathkey item to sort  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
On Sun, Oct 13, 2019 at 01:30:29PM -0500, Justin Pryzby wrote:
> BTW it probably should've been documented as an "Open Item" for v12.

https://commitfest.postgresql.org/25/2278/
I realized possibly people were thinking of that as a "feature" and not a
bugfix for backpatch (?)

But, my issue is a query which worked under v11 PWJ but fails under v12
(apparently broken by d25ea01275).

In my mind, if the planner doesn't support that query with PWJ, I think it
should run without PWJ rather than fail.

Justin



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Block level parallel vacuum
Next
From: Tom Lane
Date:
Subject: Re: v12.0: ERROR: could not find pathkey item to sort