Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

Dmitry Koval <d.koval@postgrespro.ru>

View thread

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

To: jian he <jian.universality@gmail.com>

Cc: pgsql-hackers@lists.postgresql.org

Date: 2025-06-17T21:45:24Z

Lists: pgsql-hackers

Attachments

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

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