Horton

Re: Documentation clarification re: ANALYZE

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Isaac Morland <isaac.morland@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-08-08T09:22:31Z
Lists: pgsql-hackers 
On Wed, Aug 07, 2019 at 05:54:14PM -0400, Tom Lane wrote:
> Actually, looking in the source code finds
> 
>      * We allow the user to vacuum or analyze a table if he is superuser, the
>      * table owner, or the database owner (but in the latter case, only if
>      * it's not a shared relation).
> 
> It's definitely a documentation omission that this isn't spelled out in
> the ANALYZE reference page (VACUUM's page does have text about it).

As far as I recall we have been doing that for ages, so +1 for the
documentation fix you have just done.
--
Michael

Commits

  1. Doc: document permissions required for ANALYZE.