Re: 9.3 beta and materialized views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.3 beta and materialized views
Дата
Msg-id 18099.1368725772@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 9.3 beta and materialized views  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: 9.3 beta and materialized views  (Thomas Kellerer <spam_eater@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Steven Schlansker
Дата:
Сообщение: Re: upsert functionality
Следующее
От: Fabio Rueda Carrascosa
Дата:
Сообщение: pg_upgrade link mode