Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commited6df2e

Browse files
committed
Doc: document permissions required for ANALYZE.
VACUUM's reference page had this text, but ANALYZE's didn't. That'sa clear oversight given that section 5.7 explicitly delegates theresponsibility to define permissions requirements to the individualcommands' man pages.Per gripe from Isaac Morland. Back-patch to all supported branches.Discussion:https://postgr.es/m/CAMsGm5fp3oBUs-2iRfii0iEO=fZuJALVyM2zJLhNTjG34gpAVQ@mail.gmail.com
1 parent26555cb commited6df2e

File tree

1 file changed

+10
-0
lines changed

1 file changed

+10
-0
lines changed

‎doc/src/sgml/ref/analyze.sgml

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -114,6 +114,16 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea
114114
<refsect1>
115115
<title>Notes</title>
116116

117+
<para>
118+
To analyze a table, one must ordinarily be the table's owner or a
119+
superuser. However, database owners are allowed to
120+
analyze all tables in their databases, except shared catalogs.
121+
(The restriction for shared catalogs means that a true database-wide
122+
<command>ANALYZE</command> can only be performed by a superuser.)
123+
<command>ANALYZE</command> will skip over any tables that the calling user
124+
does not have permission to analyze.
125+
</para>
126+
117127
<para>
118128
Foreign tables are analyzed only when explicitly selected. Not all
119129
foreign data wrappers support <command>ANALYZE</command>. If the table's

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp