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
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 |
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 |