Re: Add SPLIT PARTITION/MERGE PARTITIONS commands - Mailing list pgsql-hackers

On Thu, May 22, 2025 at 11:57 AM Dmitry Koval <d.koval@postgrespro.ru> wrote:
> > superuser can bypass all permission checks.
> > superuser can attach any table to the partitioned table as he wants.
>
> That's right.
> Using SUPERUSER may be a rare situation, but it needs to be processed.

I suggest that owner of new partitions produced by ALTER TABLE ...
SPLIT should be the same as owner of original partition.  Even if this
operation is done by superuser.  Superuser may explicitly set he owner
if needed.  I think we need to explicitly document this.

------
Regards,
Alexander Korotkov
Supabase