From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Regina Obe" <lr@pcorp.us>
cc: "'David Rowley'" <david.rowley@2ndquadrant.com>,
        "'PostgreSQL-development'" <pgsql-hackers@postgresql.org>
Subject: Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found
 in targetlist
In-reply-to: <000701d40fce$d1098a50$731c9ef0$@pcorp.us>
References: <001501d40f88$75186950$5f493bf0$@pcorp.us>
 <CAKJS1f9r9-u16wEkQT2sKh5wRf3DJVVPSwoNAoJnnyqhH39dDg@mail.gmail.com>
 <000701d40fce$d1098a50$731c9ef0$@pcorp.us>
Comments: In-reply-to "Regina Obe" <lr@pcorp.us>
	message dated "Fri, 29 Jun 2018 13:30:03 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <26932.1530295340.1@sss.pgh.pa.us>
Date: Fri, 29 Jun 2018 14:02:20 -0400
Message-ID: <26933.1530295340@sss.pgh.pa.us>
Precedence: bulk

"Regina Obe" <lr@pcorp.us> writes:
> Here is a trivial example to exercise that doesn't involve PostGIS.

> CREATE TABLE edge AS SELECT 1 AS edge_id;
> SELECT 't3280', 'L1b' || generate_series(1,10) 
> FROM edge
> ORDER BY 1;

That's odd.  It works fine in HEAD but not the v10 branch.  I suspect
that the fix David mentioned failed to cover some case related to the
issue we saw last week ... but why the cross-version difference?

Don't have time to investigate further right now.

			regards, tom lane