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.htmlI 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:
Show quoted text
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.htmlI 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