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

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.
Дата
Msg-id 310D60C6-5CF0-41C8-A814-3A3DE7ACF551@yesql.se
обсуждение исходный текст
Ответ на Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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/




В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unable to connect to PostgreSQL DB as root user when private key is owned by root with permission 640
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name.