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

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: n(dot)lutic(at)loxodata(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.
Date: 2022-05-20 15:07:29
Message-ID: 310D60C6-5CF0-41C8-A814-3A3DE7ACF551@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 20 May 2022, at 16:34, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-05-20 15:19:33 Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.
Previous Message Tom Lane 2022-05-20 14:49:46 Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640