Horton

Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.

Daniel Gustafsson <daniel@yesql.se>

View thread View on postgr.es
From: Daniel Gustafsson <daniel@yesql.se>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: n.lutic@loxodata.com, pgsql-bugs@lists.postgresql.org
Date: 2022-05-20T15:07:29Z
Lists: pgsql-bugs 
> On 20 May 2022, at 16:34, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Perhaps we should just tweak ruleutils so that the alias is always
> printed for non-Var columns, even when it's "?column?".  That's kind of
> ugly, but if you wanted non-ugly you should have selected a better column
> name to start with.

That might be the path of least confusion, and as you rightly say, if you don't
like the ugliness then there is a very easy way to fix it.

--
Daniel Gustafsson		https://vmware.com/

Commits

  1. Show 'AS "?column?"' explicitly when it's important.