Horton

Re: magical eref alias names

Peter Eisentraut <peter@eisentraut.org>

View thread View on postgr.es
From: Peter Eisentraut <peter@eisentraut.org>
To: Robert Haas <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2024-11-07T07:05:47Z
Lists: pgsql-hackers 
On 06.11.24 20:06, Robert Haas wrote:
> I can make nothing of*TLOCRN* or*TROCRN*, even
> after looking at the relevant source code,

These are from the SQL standard text.  So they are more guidance to the 
implementer than anything else.  I think something had to be put there, 
because erefs are required.  I'm also interested in the discussion you 
raise about that.

(I think they are meant to be something like "table {left|right} operand 
cycle reference name".)

Commits

  1. Don't generate fake "*TLOCRN*" or "*TROCRN*" aliases, either.

  2. Don't generate fake "ANY_subquery" aliases, either.

  3. Don't generate fake "*SELECT*" or "*SELECT* %d" subquery aliases.

  4. Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias.