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

From: programble(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12789: Views defined with VALUES lose their column names when dumped
Date: 2015-02-20 04:30:45
Message-ID: 20150220043045.8730.61379@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12789
Logged by: Curtis McEnroe
Email address: programble(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2015-02-20 04:48:49 Re: BUG #12789: Views defined with VALUES lose their column names when dumped
Previous Message Tom Lane 2015-02-20 01:01:26 Re: BUG #12788: host / peer auth works after pg_ctl reload, then blocks server startup