Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Regina Obe <lr(at)pcorp(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
Date: 2018-06-29 09:34:26
Message-ID: CAKJS1f9r9-u16wEkQT2sKh5wRf3DJVVPSwoNAoJnnyqhH39dDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 29 June 2018 at 21:06, Regina Obe <lr(at)pcorp(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2018-06-29 09:36:19 Re: CREATE TABLE .. LIKE .. EXCLUDING documentation
Previous Message David Rowley 2018-06-29 09:13:28 Re: pgsql: Clarify use of temporary tables within partition trees