Обсуждение: Wrong statement on the materialized views page
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/rules-materializedviews.html Description: There might be an issue on this page: https://www.postgresql.org/docs/current/rules-materializedviews.html I think the statement CREATE TABLE mymatview AS SELECT * FROM mytab; should actuall be CREATE VIEW mymatview AS SELECT * FROM mytab; kind regards, Mark
> On 21/08/2023 09:02 CEST PG Doc comments form <noreply@postgresql.org> wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/rules-materializedviews.html > Description: > > There might be an issue on this page: > https://www.postgresql.org/docs/current/rules-materializedviews.html > > I think the statement > CREATE TABLE mymatview AS SELECT * FROM mytab; > should actuall be > CREATE VIEW mymatview AS SELECT * FROM mytab; No, CREATE TABLE is correct in this case because that section is about the persistence of matview results like a table. -- Erik
Ah yes, I understand it now. The surrounding text had me confused. Thanks.
Mark
On Mon, Aug 21, 2023 at 10:37 AM Erik Wienhold <ewie@ewie.name> wrote:
> On 21/08/2023 09:02 CEST PG Doc comments form <noreply@postgresql.org> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/15/rules-materializedviews.html
> Description:
>
> There might be an issue on this page:
> https://www.postgresql.org/docs/current/rules-materializedviews.html
>
> I think the statement
> CREATE TABLE mymatview AS SELECT * FROM mytab;
> should actuall be
> CREATE VIEW mymatview AS SELECT * FROM mytab;
No, CREATE TABLE is correct in this case because that section is about the
persistence of matview results like a table.
--
Erik