From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
---|---|
To: | "Thom Brown" <thom(at)linux(dot)com> |
Cc: | "Marko Tiikkaja" <pgmail(at)joh(dot)to>,"Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Materialized views WIP patch |
Date: | 2013-01-16 17:20:50 |
Message-ID: | 20130116172050.162420@gmx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thom Brown wrote:
> Some weirdness:
>
> postgres=# CREATE VIEW v_test2 AS SELECT 1 moo;
> CREATE VIEW
> postgres=# CREATE MATERIALIZED VIEW mv_test2 AS SELECT moo, 2*moo FROM
> v_test2 UNION ALL SELECT moo, 3*moo FROM v_test2;
> SELECT 2
> postgres=# \d+ mv_test2
> Materialized view "public.mv_test2"
> Column | Type | Modifiers | Storage | Stats target | Description
> ----------+---------+-----------+---------+--------------+-------------
> moo | integer | | plain | |
> ?column? | integer | | plain | |
> View definition:
> SELECT "*SELECT* 1".moo, "*SELECT* 1"."?column?";
You are very good at coming up with these, Thom!
Will investigate.
Can you confirm that *selecting* from the MV works as you would
expect; it is just the presentation in \d+ that's a problem?
Thanks,
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2013-01-16 17:25:29 | Re: Materialized views WIP patch |
Previous Message | Bruce Momjian | 2013-01-16 17:20:24 | Re: Parallel query execution |