Request a Demo
Home   >   mailing lists

Re: REPACK: warn about skipping foreign partitions - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: REPACK: warn about skipping foreign partitions
Date
Msg-id CAHGQGwGonjzb6ffY8jFEHE+HkE3RSDGwukA7zU+L-98xR2J59w@mail.gmail.com
Whole thread
In response to Re: REPACK: warn about skipping foreign partitions  (Zsolt Parragi <zsolt.parragi@percona.com>)
Responses Re: REPACK: warn about skipping foreign partitions
List pgsql-hackers
Tree view 
On Sat, Oct 10, 2026 at 12:57 AM Zsolt Parragi
<zsolt.parragi@percona.com> wrote:
>
> v3 is a trivial rebase to resolve a documentation conflict

In v3, CLUSTER/REPACK warn about foreign partitions during partition
collection, without locking them or checking privileges. OTOH,
VACUUM/VACUUM FULL warn only after locking each partition and
checking privileges.

So, for example, if the user lacks privileges on a foreign partition,
VACUUM/VACUUM FULL report a permission warning, whereas CLUSTER/REPACK
report that foreign tables cannot be processed.

Are these differences intentional, or should CLUSTER/REPACK perform the
checks in the same order as VACUUM/VACUUM FULL?

Regards,

--
Fujii Masao

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Policy for Abandoned Extensions
Next
From: Haibo Yan
Date:
Subject: Re: [PATCH] Fix grouping-set nulling of variable-free grouping expressions