diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-08-07 18:09:28 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-08-07 18:09:28 -0400 |
| commit | bae875d694d61b1627eaa6aafbcb2d5460f2dc9d (patch) | |
| tree | cb997a7cada95b4c15bb5f077951cc17b7a13760 | |
| parent | fd298cd6394bead60456457cf791f958d20fc3f4 (diff) | |
| download | postgresql-bae875d694d61b1627eaa6aafbcb2d5460f2dc9d.tar.gz postgresql-bae875d694d61b1627eaa6aafbcb2d5460f2dc9d.zip | |
Doc: document permissions required for ANALYZE.
VACUUM's reference page had this text, but ANALYZE's didn't. That's
a clear oversight given that section 5.7 explicitly delegates the
responsibility to define permissions requirements to the individual
commands' man pages.
Per gripe from Isaac Morland. Back-patch to all supported branches.
Discussion: https://postgr.es/m/CAMsGm5fp3oBUs-2iRfii0iEO=fZuJALVyM2zJLhNTjG34gpAVQ@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/ref/analyze.sgml | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 27ab4fca42c..f057341a079 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -94,6 +94,16 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table_name</replaceable> [ <title>Notes</title> <para> + To analyze a table, one must ordinarily be the table's owner or a + superuser. However, database owners are allowed to + analyze all tables in their databases, except shared catalogs. + (The restriction for shared catalogs means that a true database-wide + <command>ANALYZE</command> can only be performed by a superuser.) + <command>ANALYZE</command> will skip over any tables that the calling user + does not have permission to analyze. + </para> + + <para> Foreign tables are analyzed only when explicitly selected. Not all foreign data wrappers support <command>ANALYZE</>. If the table's wrapper does not support <command>ANALYZE</>, the command prints a |