BUG #12789: Views defined with VALUES lose their column names when dumped

Поиск
Список
Период
Сортировка
От programble@gmail.com
Тема BUG #12789: Views defined with VALUES lose their column names when dumped
Дата
Msg-id 20150220043045.8730.61379@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12789: Views defined with VALUES lose their column names when dumped
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      12789
Logged by:          Curtis McEnroe
Email address:      programble@gmail.com
PostgreSQL version: 9.4.1
Operating system:   Mac OS X 10.10.1
Description:

A view created with explicit column names and defined as a VALUES statement
will lose its column names when dumped. When the dump is restored, the
view's columns are named "column1", "column2", etc.

I wrote a short repro script here:
https://gist.github.com/programble/a416df496bfb41259c86

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12788: host / peer auth works after pg_ctl reload, then blocks server startup
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #12789: Views defined with VALUES lose their column names when dumped