Horton

Re: fix and document CLUSTER privileges

Pavel Luzanov <p.luzanov@postgrespro.ru>

View thread View on postgr.es
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
To: Nathan Bossart <nathandbossart@gmail.com>, pgsql-hackers@postgresql.org
Date: 2022-12-08T11:15:58Z
Lists: pgsql-hackers 
On 08.12.2022 01:39, Nathan Bossart wrote:
> It was also noted elsewhere [1] that the privilege requirements for CLUSTER
> are not documented.  The attached patch adds such documentation.
> [1] https://postgr.es/m/661148f4-c7f1-dec1-2bc8-29f3bd58e242%40postgrespro.ru

Thanks for the patch. It correctly states the existing behavior.

But perhaps we should wait for the decision in discussion [1] (link above),
since this decision may affect the documentation on the CLUSTER command.

-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com

Commits

  1. Clarify documentation for CLUSTER on partitioned tables.

  2. Fix MAINTAIN privileges for toast tables and partitions.

  3. Have CLUSTER ignore partitions not owned by caller