Postgres Pro
Downloads
Home   >   mailing lists

BUG #12789: Views defined with VALUES lose their column names when dumped - Mailing list pgsql-bugs

From programble@gmail.com
Subject BUG #12789: Views defined with VALUES lose their column names when dumped
Date
Msg-id 20150220043045.8730.61379@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12789: Views defined with VALUES lose their column names when dumped  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #12788: host / peer auth works after pg_ctl reload, then blocks server startup
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #12789: Views defined with VALUES lose their column names when dumped