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

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "suresh.arsenal29@gmail.com" <suresh.arsenal29@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2019-05-08T07:10:36Z
Lists: pgsql-bugs
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.