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 <br...@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 +
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
