Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: zengman <zengman(at)halodbtech(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2025-12-20 08:58:21
Message-ID: CALdSSPj6ixZC2EaTgJU_2BNhgjsg_8665x2-pDzcEoc-PRueAA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi!

I have been looking though git log, noticed this commit, and did small tests.

This is what I found:

```
reshke=# create table z(i int) partition by range(i);
CREATE TABLE
reshke=# create table z_1 partition of z for values from (0)to(1);
CREATE TABLE
reshke=# create table z_2 partition of z for values from (1)to(2);
CREATE TABLE
reshke=# alter table only z merge partitions (z_1,z_2) into z_12;
ALTER TABLE
reshke=#

```

IMO "alter table only ... merge partitions" does not make perfect
sense and should be rejected rather than executed. WDYT?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2025-12-20 09:25:15 Re: Orphaned records in pg_replication_origin_status after subscription drop
Previous Message Zsolt Parragi 2025-12-20 07:38:59 Re: Fix typo 586/686 in atomics/arch-x86.h