Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2025-05-19 22:35:45
Message-ID: 7fdaf3e8-4c05-4739-bee6-98acc068d1c7@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
v38-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch text/plain 150.4 KB
v38-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch text/plain 216.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2025-05-19 23:11:07 Re: [PoC] XMLCast (SQL/XML X025)
Previous Message Sami Imseih 2025-05-19 22:10:14 Re: Regression in statement locations