pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Typo on Refresh Materialized View page 2+ messages / 2 participants [nested] [flat]
Commits from this thread: 2019-10-24 59c2617af3 56a459be51 2930f163f6 9a573e1fd4 4e3be56984 7db3651090 84d1c5c45f docs: fix wording of REFRESH CONCURRENTLY manual page
* Typo on Refresh Materialized View page @ 2019-10-11 04:31 PG Doc comments form <noreply@postgresql.org> 2019-10-24 00:30 ` Re: Typo on Refresh Materialized View page Bruce Momjian <bruce@momjian.us> 0 siblings, 1 reply; 2+ messages in thread From: PG Doc comments form @ 2019-10-11 04:31 UTC (permalink / raw) To: pgsql-docs@lists.postgresql.org; +Cc: apraveen@pivotal.io 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Typo on Refresh Materialized View page 2019-10-11 04:31 Typo on Refresh Materialized View page PG Doc comments form <noreply@postgresql.org> @ 2019-10-24 00:30 ` Bruce Momjian <bruce@momjian.us> 0 siblings, 0 replies; 2+ messages in thread From: Bruce Momjian @ 2019-10-24 00:30 UTC (permalink / raw) To: apraveen@pivotal.io; pgsql-docs@lists.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:^ permalink raw reply [nested|flat] 2+ messages in threadrefresh.diff (text/x-diff, 1.1K) download
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
end of thread, other threads:[~2019-10-24 00:30 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-10-11 04:31 Typo on Refresh Materialized View page PG Doc comments form <noreply@postgresql.org> 2019-10-24 00:30 ` Bruce Momjian <bruce@momjian.us>
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