From: Bruce Momjian <bruce@momjian.us>
To: apraveen@pivotal.io
To: pgsql-docs@lists.postgresql.org
Subject: Re: Typo on Refresh Materialized View page
Date: Wed, 23 Oct 2019 20:30:11 -0400
Message-ID: <20191024003011.GC8650@momjian.us> (raw)
In-Reply-To: <157076828181.26165.15231292023740913543@wrigleys.postgresql.org>
References: <157076828181.26165.15231292023740913543@wrigleys.postgresql.org>
On Fri, Oct 11, 2019 at 04:31:21AM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html
> Description:
>
> Hello
>
> There appears to be a typo on this page:
> https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html
>
> In the description of CONCURRENTLY clause, one sentence reads "it must not
> index on any expressions nor include a WHERE clause". This should be
> changed to "it must be *be* an index on an expression nor include a WHERE
> clause".
Yes, you are right that the wording is awkward, and has been that way at
least back to 9.4, so I have patched it back through that release;
patch attached. Thanks for the report.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Attachments:refresh.diff (text/x-diff, 1.1K) downloaddiff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgmlnew file mode 100644index fd06f1f..8ae6267
*** a/doc/src/sgml/ref/refresh_materialized_view.sgml
--- b/doc/src/sgml/ref/refresh_materialized_view.sgml
*************** REFRESH MATERIALIZED VIEW [ CONCURRENTLY
*** 63,70 ****
<para>
This option is only allowed if there is at least one
<literal>UNIQUE</literal> index on the materialized view which uses only
! column names and includes all rows; that is, it must not index on any
! expressions nor include a <literal>WHERE</literal> clause.
</para>
<para>
This option may not be used when the materialized view is not already
--- 63,70 ----
<para>
This option is only allowed if there is at least one
<literal>UNIQUE</literal> index on the materialized view which uses only
! column names and includes all rows; that is, it must not be an
! expression index or include a <literal>WHERE</literal> clause.
</para>
<para>
This option may not be used when the materialized view is not already
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: bruce@momjian.us, apraveen@pivotal.io, pgsql-docs@lists.postgresql.org
Subject: Re: Typo on Refresh Materialized View page
In-Reply-To: <20191024003011.GC8650@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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