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

Commitb7c1c33

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 parent54c98fa commitb7c1c33

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
@@ -93,6 +93,16 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table_name</replaceable> [
9393
<refsect1>
9494
<title>Notes</title>
9595

96+
<para>
97+
To analyze a table, one must ordinarily be the table's owner or a
98+
superuser. However, database owners are allowed to
99+
analyze all tables in their databases, except shared catalogs.
100+
(The restriction for shared catalogs means that a true database-wide
101+
<command>ANALYZE</command> can only be performed by a superuser.)
102+
<command>ANALYZE</command> will skip over any tables that the calling user
103+
does not have permission to analyze.
104+
</para>
105+
96106
<para>
97107
Foreign tables are analyzed only when explicitly selected. Not all
98108
foreign data wrappers support <command>ANALYZE</>. If the table's

0 commit comments

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