Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2025-09-17 07:35:34
Message-ID: CACJufxGkVBQCj+fP=Dpy3-Hnkay6UqYwnWY+h_GaMgz0UGa9LQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 17, 2025 at 6:08 AM Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> wrote:
>
> 2. Patch v56-0001-refactor-v56-check_partitions_for_split.no-cfbot
> applied with cosmetic changes.
>

hi.

check_two_partitions_bounds_range
ereport(ERROR,
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
merge_split
? errmsg("can not merge partition \"%s\" together with
partition \"%s\"",
second_name->relname, first_name->relname)
: errmsg("can not split to partition \"%s\" together
with partition \"%s\"",
second_name->relname, first_name->relname),
errdetail("lower bound of partition \"%s\" is not
equal to the upper bound of partition \"%s\"",
second_name->relname, first_name->relname),
merge_split
? errhint("ALTER TABLE ... MERGE PARTITIONS requires
the partition bounds to be adjacent.")
: errhint("ALTER TABLE ... SPLIT PARTITIONS requires
the partition bounds to be adjacent."),
parser_errposition(pstate, datum->location));

This is too much...., also bad for translation, so I refactored this.
I also refactored check_partition_bounds_for_split_range.

In ATExecSplitPartition,
"char relname[NAMEDATALEN];" is not necessary?

Attachment Content-Type Size
v57-0001-refactor-for-v57.no-cfbot application/octet-stream 14.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2025-09-17 07:41:40 Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Previous Message Shubham Khanna 2025-09-17 06:46:35 Re: Add support for specifying tables in pg_createsubscriber.