pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedWrong statement on the materialized views page
3+ messages / 3 participants
[nested] [flat]
* Wrong statement on the materialized views page
@ 2023-08-21 07:02 PG Doc comments form <noreply@postgresql.org>
2023-08-21 08:37 ` Re: Wrong statement on the materialized views page Erik Wienhold <ewie@ewie.name>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2023-08-21 07:02 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: mark.meeus@gmail.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Wrong statement on the materialized views page
2023-08-21 07:02 Wrong statement on the materialized views page PG Doc comments form <noreply@postgresql.org>
@ 2023-08-21 08:37 ` Erik Wienhold <ewie@ewie.name>
2023-08-21 09:29 ` Re: Wrong statement on the materialized views page Mark Meeus <mark.meeus@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Erik Wienhold @ 2023-08-21 08:37 UTC (permalink / raw)
To: mark.meeus@gmail.com; pgsql-docs@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Wrong statement on the materialized views page
2023-08-21 07:02 Wrong statement on the materialized views page PG Doc comments form <noreply@postgresql.org>
2023-08-21 08:37 ` Re: Wrong statement on the materialized views page Erik Wienhold <ewie@ewie.name>
@ 2023-08-21 09:29 ` Mark Meeus <mark.meeus@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Mark Meeus @ 2023-08-21 09:29 UTC (permalink / raw)
To: Erik Wienhold <ewie@ewie.name>; +Cc: pgsql-docs@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-08-21 09:29 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-21 07:02 Wrong statement on the materialized views page PG Doc comments form <noreply@postgresql.org>
2023-08-21 08:37 ` Erik Wienhold <ewie@ewie.name>
2023-08-21 09:29 ` Mark Meeus <mark.meeus@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox