Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2025-06-17 21:45:24
Message-ID: 4f19550b-eb41-4649-8bf5-566dc020a720@postgrespro.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

>v46-0001-regress-test-refactoring-and-others.no-cfbot
Thanks, applied. Two comments:

>+ errmsg("relation \"%s\" already exists", cmd->name->relname));
>There are no regress tests for this, I have added a simple test for it.

Test for this is in the second commit (SPLIT PARTITION) but
it's okay to have test here.

>+SELECT tableoid::regclass, * FROM sales_range ORDER BY ...

Similar changes are also made for SPLIT PARTITION.

--
With best regards,
Dmitry Koval

Postgres Professional: http://postgrespro.com

Attachment Content-Type Size
v47-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch text/plain 166.7 KB
v47-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch text/plain 219.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2025-06-17 22:36:41 Re: POC: Parallel processing of indexes in autovacuum
Previous Message Jelte Fennema-Nio 2025-06-17 21:10:27 Re: minimum Meson version