diff options
| author | Michael Paquier <michael@paquier.xyz> | 2018-08-17 11:29:15 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2018-08-17 11:32:32 +0900 |
| commit | 82784f088986140bc08ab22ae34f4b1cbce58eae (patch) | |
| tree | c8075d223b25dc7e9990a8163800eae74dd2bac1 | |
| parent | 864ecd716a0dd191e587dd09e24992be5e720b26 (diff) | |
| download | postgresql-82784f088986140bc08ab22ae34f4b1cbce58eae.tar.gz postgresql-82784f088986140bc08ab22ae34f4b1cbce58eae.zip | |
Mention ownership requirements for REFRESH MATERIALIZED VIEW in docs
Author: Dian Fay
Discussion: https://postgr.es/m/745abbd2-a1a0-ead8-2cb2-768c16747d97@gmail.com
Backpatch-through: 9.3
| -rw-r--r-- | doc/src/sgml/ref/refresh_materialized_view.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgml index c165c69c9f9..28ff8606559 100644 --- a/doc/src/sgml/ref/refresh_materialized_view.sgml +++ b/doc/src/sgml/ref/refresh_materialized_view.sgml @@ -31,7 +31,8 @@ REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] <replaceable class="PARAMETER">name</ <para> <command>REFRESH MATERIALIZED VIEW</command> completely replaces the - contents of a materialized view. The old contents are discarded. If + contents of a materialized view. To execute this command you must be the + owner of the materialized view. The old contents are discarded. If <literal>WITH DATA</literal> is specified (or defaults) the backing query is executed to provide the new data, and the materialized view is left in a scannable state. If <literal>WITH NO DATA</literal> is specified no new |