Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: Zhihong Yu <zyu(at)yugabyte(dot)com>
To: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2022-10-11 17:15:05
Message-ID: CALNJ-vRee1RmHgzV=-_B=6AN3L_CCuAjdzej5XxhfHR6iT2K5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 11, 2022 at 9:58 AM Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:

>
>
> On Tue, Oct 11, 2022 at 9:22 AM Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
> wrote:
>
>> Hi!
>>
>> Fixed couple warnings (for cfbot).
>>
>> --
>> With best regards,
>> Dmitry Koval
>>
>> Postgres Professional: http://postgrespro.com
>
> Hi,
> For v12-0001-PGPRO-ALTER-TABLE-MERGE-PARTITIONS-command.patch:
>
> + if (equal(name, cmd->name))
> + /* One new partition can have the same name as merged
> partition. */
> + isSameName = true;
>
> I think there should be a check before assigning true to isSameName - if
> isSameName is true, that means there are two partitions with this same name.
>
> Cheers
>

Pardon - I see that transformPartitionCmdForMerge() compares the partition
names.
Maybe you can add a comment in ATExecMergePartitions referring to
transformPartitionCmdForMerge() so that people can more easily understand
the logic.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-10-11 17:27:06 Re: Eliminating SPI from RI triggers - take 2
Previous Message Bruce Momjian 2022-10-11 17:08:31 Re: Add a missing comment for PGPROC.pgprocno