PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15795
PG Version10.3
OSUbuntu 16.04
Opened2019-05-08 06:51:32+00
Reported bySuresh Kumar R
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15795
Logged by:          Suresh Kumar R
Email address:      (redacted)
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'.

Here is query:
SELECT  DISTINCT  A._id0 as _id0, A._actual_type_name0 as _actual_type_name0
 FROM  ( (   SELECT  DISTINCT _id as _id0, _actual_type_name as
_actual_type_name0, name as name0  FROM  hello_world.person  ) union all  ( 
SELECT  DISTINCT  _id as _id0, _actual_type_name as _actual_type_name0, name
as name0  FROM  hello_world.person)) as A WHERE ( A.name0  =  A.name0 );

Messages

DateAuthorSubject
2019-05-08 06:51:32+00PG Bug reporting formBUG #15795: ERROR: could not find pathkey item to sort
2019-05-08 07:10:36+00"David G(dot) Johnston"Re: BUG #15795: ERROR: could not find pathkey item to sort
2019-05-08 07:18:16+00Suresh Kumar RRe: BUG #15795: ERROR: could not find pathkey item to sort
2019-05-08 10:33:18+00Tom LaneRe: BUG #15795: ERROR: could not find pathkey item to sort
2019-05-09 05:52:34+00Amit LangoteRe: BUG #15795: ERROR: could not find pathkey item to sort
2019-05-09 16:06:18+00Tom LaneRe: BUG #15795: ERROR: could not find pathkey item to sort
2019-05-09 19:24:20+00Tom LaneRe: BUG #15795: ERROR: could not find pathkey item to sort