On Sunday, October 17, 2021, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
There might be an opportunity here to improve the error message's hint:
regression=# SELECT CTID
regression-# FROM tmp1
regression-# INNER JOIN tmp2 ON tmp1.id = tmp2.id;
ERROR: column "ctid" does not exist
LINE 1: SELECT CTID
^
HINT: There is a column named "ctid" in table "tmp1", but it cannot be referenced from this part of the query.
"cannot be referenced" is probably a shade misleading, given the
availability of the qualified-name alternative.
I was actually wondering why the error wasn’t an ambiguous column name error. For a pure select query we already allow duplicate column names in the result.
David J.