Re: BUG #15795: ERROR: could not find pathkey item to sort

Suresh Kumar R <suresh.arsenal29@gmail.com>

From: Suresh Kumar R <suresh.arsenal29@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2019-05-08T07:18:16Z
Lists: pgsql-bugs
I tried in the latest 10.7 release too. I still get the same error.

Suresh.

On Wed, May 8, 2019 at 12:40 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Tuesday, May 7, 2019, PG Bug reporting form <noreply@postgresql.org>
> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference:      15795
>> Logged by:          Suresh Kumar R
>> Email address:      suresh.arsenal29@gmail.com
>> PostgreSQL version: 10.3
>> Operating system:   Ubuntu 16.04
>> Description:
>>
>> I have a table 'person' with properties _id, _actual_type_name and name
>> when
>> I tried the below query, I got an error saying 'could not find pathkey
>> item
>> to sort'.
>>
>>
> Upgrade to the latest release (10.7)
>
> David J.
>

Commits

  1. Repair issues with faulty generation of merge-append plans.

  2. Reduce "X = X" to "X IS NOT NULL", if it's easy to do so.