Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: v12.0: ERROR: could not find pathkey item to sort
Date
Msg-id 16802.1570989962@sss.pgh.pa.us
Whole thread Raw
In response to Re: v12.0: ERROR: could not find pathkey item to sort  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: v12.0: ERROR: could not find pathkey item to sort
List pgsql-hackers
Tree view 
Justin Pryzby <pryzby@telsasoft.com> writes:
> On Fri, Oct 11, 2019 at 10:48:37AM -0400, Tom Lane wrote:
>> Could you provide a self-contained test case please?

> [ test case ]

Oh, this is the same issue Amit described in


https://www.postgresql.org/message-id/flat/CA%2BHiwqG2WVUGmLJqtR0tPFhniO%3DH%3D9qQ%2BZ3L_ZC%2BY3-EVQHFGg%40mail.gmail.com

namely that we're not generating EquivalenceClass members corresponding
to sub-joins of a partitionwise join.

Are you interested in helping to test the patches proposed there?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: v12.0: segfault in reindex CONCURRENTLY
Next
From: Alvaro Herrera
Date:
Subject: Re: v12.0: segfault in reindex CONCURRENTLY