Skip site navigation (1) Skip section navigation (2)

Re: Materialized views WIP patch

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 (view raw or flat)
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


Responses

pgsql-hackers by date

Next:From: Thom BrownDate: 2013-01-16 17:25:29
Subject: Re: Materialized views WIP patch
Previous:From: Bruce MomjianDate: 2013-01-16 17:20:24
Subject: Re: Parallel query execution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group