Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
Дата
Msg-id CAKFQuwZ8pXZ1tBLRn6HXEaK9Gd6JvHk-HzowNGMZ2JPFBO2CzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
Список pgsql-docs
Дерево обсуждения
On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form <noreply@postgresql.org> wrote:
Unless I'm completely mistaken, the second code example on
https://www.postgresql.org/docs/current/rules-materializedviews.html, i.e
this:

CREATE TABLE mymatview AS SELECT * FROM mytab;

Should instead by

CREATE VIEW mymatview AS SELECT * FROM mytab;

No, the example's intent is to compare a true "materialized view" with a table that is simply populated from a query.  The comment "the materialized view cannot subsequently be directly updated" only makes sense as a counterpoint to a physical table.

David J.

В списке pgsql-docs по дате отправления: