Re: Typo on Refresh Materialized View page

Bruce Momjian <[email protected]> Wed, 23 Oct 2019 20:30:11 -0400

Newsgroups	gmane.comp.db.postgresql.devel.documentation
Message-ID	<[email protected]>

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  <[email protected]>        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 +

refresh.diff (text/x-diff, 1.1 KB)

diff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgml
new file mode 100644
index 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