BUG #8542: Materialized View with another column_name does not work?

From: t(dot)katsumata1122(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8542: Materialized View with another column_name does not work?
Date: 2013-10-21 09:41:17
Message-ID: E1VYBzB-0004BW-K6@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

The following bug has been logged on the website:

Bug reference: 8542
Logged by: Tomonari Katsumata
Email address: t(dot)katsumata1122(at)gmail(dot)com
PostgreSQL version: 9.3.1
Operating system: RHEL5 x86_64
Description:

Hi,

I'm testing the Materialized View.
When I've tried to create materialized view with specified column_name, I
got an ERROR.

example:
- Creating original table
CREATE TABLE t ( i int );

- Creating materialized view with column_name
CREATE MATERIALIZED VIEW mv_t(ii) AS SELECT * FROM t;

And then, I got a bellow ERROR.
----
ERROR: SELECT rule's target entry 1 has different column name from "ii"
----

I did not get any ERROR with non materialized view.
CREATE VIEW mv_t(ii) AS SELECT * FROM t;

Is this a bug or restriction for Materialized View?

regards,
-----------
Tomonari Katsumata

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2013-10-21 10:02:23 Re: BUG #8542: Materialized View with another column_name does not work?
Previous Message warren 2013-10-21 02:54:46 BUG #8541: PGXS build fails due to 'include common/fe_memutils.h' which is not present

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2013-10-21 10:02:23 Re: BUG #8542: Materialized View with another column_name does not work?
Previous Message Andres Freund 2013-10-21 05:31:55 Re: Commitfest II CLosed