agora inbox for pgsql-docs@postgresql.org  

help / color / mirror / Atom feed

From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: forsberg@efod.se
Subject: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
Date: Thu, 21 Aug 2025 14:07:01 +0000
Message-ID: <175578522105.806.9299577429321382358@wrigleys.postgresql.org> (raw)

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/rules-materializedviews.html
Description:

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;

(I.e, create a VIEW, not a TABLE).

Could also be debated if the view name should be the same in both examples.
I.e the second example might be even better as below:

CREATE VIEW myview AS SELECT * from mytab;

view thread (4+ messages)  latest in thread

Message-ID: <175578522105.806.9299577429321382358@wrigleys.postgresql.org>
Permalink:  ../175578522105.806.9299577429321382358@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/175578522105.806.9299577429321382358@wrigleys.postgresql.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, forsberg@efod.se
  Subject: Re: Example on difference between CREATE MATERIALIZED VIEW and standard VIEW has typo
  In-Reply-To: <175578522105.806.9299577429321382358@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox