Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19475: VACUUM on a partition still warns after MAINTAIN is
 granted on the partitioned parent
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: 798604270@qq.com
Reply-To: 798604270@qq.com, pgsql-bugs@lists.postgresql.org
Date: Mon, 11 May 2026 07:41:42 +0000
Message-ID: <19475-513aa13168f22afe@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19475-513aa13168f22afe%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19475
Logged by:          Chi Zhang
Email address:      798604270@qq.com
PostgreSQL version: 18.3
Operating system:   Ubuntu 24.04
Description:       =20

Hi,

I tested the current PostgreSQL master at commit 901ed9b352b (postgres
--version reports PostgreSQL 19devel). The current branch already contains
commit ff9618e82a466fc9c635f9f087776e57b21e4f14, whose commit message says:

=E2=80=9CFor partitions, allow the maintenance command if the user has the =
MAINTAIN
privilege on the partition or any parent.=E2=80=9D

However, the following test case still produces a permission warning when
VACUUM is run directly on a partition after granting MAINTAIN only on its
partitioned parent.

Reproduction:

```
CREATE TABLE parent (a int) PARTITION BY RANGE (a);
CREATE TABLE child PARTITION OF parent
  FOR VALUES FROM (0) TO (100);
INSERT INTO parent VALUES (1), (2), (3);

GRANT MAINTAIN ON parent TO main_role;

SET client_min_messages =3D warning;
SET ROLE main_role;

VACUUM child;  -- WARNING:  permission denied to vacuum "child", skipping it

```