Re: 9.3 beta and materialized views - Mailing list pgsql-general

From Tom Lane
Subject Re: 9.3 beta and materialized views
Date
Msg-id 18099.1368725772@sss.pgh.pa.us
Whole thread Raw
In response to 9.3 beta and materialized views  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: 9.3 beta and materialized views  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Thomas Kellerer <spam_eater@gmx.net> writes:
> I'm currently adding the support for materialized views to my SQL tool, and noticed that when creating a materialized
view,a rewrite rule is also created that looks just like a rewrite rule for a "normal" view. 

Yup.

> As the materialized view should be a "table" that can be selected from, I wonder what the purpose of the rewrite rule
is?

To store the matview's definition for use in REFRESH.

            regards, tom lane


pgsql-general by date:

Previous
From: Steven Schlansker
Date:
Subject: Re: upsert functionality
Next
From: Fabio Rueda Carrascosa
Date:
Subject: pg_upgrade link mode