Thread: Typo on Refresh Materialized View page

Typo on Refresh Materialized View page

From
PG Doc comments form
Date:
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".

Asim

Re: Typo on Refresh Materialized View page

From
Bruce Momjian
Date:
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 +

Attachment