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

Commitb3670f4

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 parentdcebb3e commitb3670f4

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
@@ -96,6 +96,16 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table_name</replaceable> [
9696
<refsect1>
9797
<title>Notes</title>
9898

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

0 commit comments

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