Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not foundin targetlist - Mailing list pgsql-hackers

From David Rowley
Subject Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not foundin targetlist
Date
Msg-id CAKJS1f9r9-u16wEkQT2sKh5wRf3DJVVPSwoNAoJnnyqhH39dDg@mail.gmail.com
Whole thread Raw
In response to Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist  ("Regina Obe" <lr@pcorp.us>)
Responses RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
List pgsql-hackers
On 29 June 2018 at 21:06, Regina Obe <lr@pcorp.us> wrote:
> I think the exact query that is triggering it is this one though I don't
> have PostgreSQL 10 head installed locally to confirm.
>
> SELECT 't3280', 'L1b' || topology.TopoGeo_AddLinestring('bug3280', geom)
>  FROM bug3280.edge where edge_id = 1
>  ORDER BY 1;

Can you try in REL_10_STABLE? There was a fix committed [1] for
something very similar just a week ago.

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=a4c95b0b80c70677c09c0d5c82a6fba875160288

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Юрий Соколов
Date:
Subject: Re: [WIP] [B-Tree] Retail IndexTuple deletion
Next
From: Daniel Gustafsson
Date:
Subject: Re: CREATE TABLE .. LIKE .. EXCLUDING documentation