Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

Dmitry Koval <d.koval@postgrespro.ru>

From: Dmitry Koval <d.koval@postgrespro.ru>

To: pgsql-hackers@lists.postgresql.org

Date: 2025-05-19T22:35:45Z

Lists: pgsql-hackers

Attachments

v38-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch (text/plain)
v38-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch (text/plain)

Hi!

Changes in patches:

1) Added usage of SECURITY_RESTRICTED_OPERATION for SPLIT/MERGE 
PARTITION(S) commands.

2) For SPLIT PARTITION command: new partitions will have the same owner 
as the parent.

3) For MERGE PARTITIONS command: if merged partitions have different 
owners, an error will be generated.

Patches are attached to the email.

-- 
With best regards,
Dmitry Koval

Postgres Professional: http://postgrespro.com