Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vT72q-00DFv0-07 for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Dec 2025 23:23:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vT72o-008SP4-2G for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Dec 2025 23:22:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vT72o-008SOw-0f for pgsql-hackers@lists.postgresql.org; Tue, 09 Dec 2025 23:22:58 +0000 Received: from mail.postgrespro.ru ([93.174.132.70]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vT72m-0048y3-0m for pgsql-hackers@lists.postgresql.org; Tue, 09 Dec 2025 23:22:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1765322574; bh=V1EhIG4oBql793wJd5HMPvxzuqIUEDASvDPneT0dxL4=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=pj50ozcnKPA84uARrCo+V8h96d2/k2UXauNI8EbcNOuvncr5y78K0+YA51FHXR7Ga aFaxS62rl6Muo/VEbmQELrLan9QYar2zMfc1G4qhDjPH42f5VlkZIOqF4ogE6wQlKj PZ3/kNjVOU4ywDT7gtL6S3L+DGlMXqyCtWUFxJ4IfqPBkFexTU4Ts62PapiHeJ8BsV rKZAfoL7OcZQJDKx36o8lVU3f+qRP2t/l5f1Dnnqxa8rCLywYzKs8c4uhLadzLdIen fSyBH9iLjHfl7Gxtp3Q4AQVDn0fheDqd57hbIFALNXauBnSQNMuTd7dI4Z2UcDWdyo Kx0joA+64X20A== Received: from [172.30.50.18] (debian11-template.l.postgrespro.ru [192.168.2.254]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: d.koval@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id A8D325FD36; Wed, 10 Dec 2025 02:22:54 +0300 (MSK) Message-ID: <29ff27f5-d359-4479-b11c-ce28e525d806@postgrespro.ru> Date: Wed, 10 Dec 2025 02:22:53 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands To: Alexander Korotkov Cc: pgsql-hackers@lists.postgresql.org References: <171085360143.2046436.7217841141682511557.pgcf@coridan.postgresql.org> <2643645f-2a02-43de-9321-c995ab1b7ef8@postgrespro.ru> <57a94d8a-d7b6-4c5e-9001-be1cd403b172@postgrespro.ru> <54414932-9E82-47AA-902B-2DED18F07F64@gmail.com> <3280c458-a886-4c58-8e2b-4d220b73161d@postgrespro.ru> <09414bf8-9326-431c-9422-b13bddf5f554@postgrespro.ru> Content-Language: en-US From: Dmitry Koval In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-KSMG-AntiPhishing: NotDetected, bases: 2025/12/09 22:46:00 X-KSMG-AntiSpam-Interceptor-Info: not scanned X-KSMG-AntiSpam-Status: not scanned, disabled by settings X-KSMG-AntiVirus: Kaspersky Secure Mail Gateway, version 2.1.0.7854, bases: 2025/12/09 15:30:00 #28036599 X-KSMG-AntiVirus-Status: NotDetected, skipped X-KSMG-LinksScanning: not scanned, disabled by settings X-KSMG-Message-Action: skipped X-KSMG-Rule-ID: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Alexander! Thank you for your corrections! Two questions: ---- 1) "v65-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch" patch, "src/backend/partitioning/partbounds.c" file, "check_two_partitions_bounds_range" function. Old comment (v64) + /* + * lower1=false (the second to last argument) for correct comparison of + * lower and upper bounds. + */ was changed to (v65) + /* + * cmpval == false for the correct comparison result of the lower and + * upper bounds. + */ Maybe it's better to keep the old comment (or keep its meaning)? ---- 2) "v65-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch" patch, "src/backend/parser/parse_utilcmd.c" file, "checkPartition" function. The third argument of function was changed from "is_merge" (v64) to "isMerge" (v65). Maybe the function description should be changed in the same way? + * is_merge: true indicates the operation is "ALTER TABLE ... MERGE PARTITIONS"; -- With best regards, Dmitry Koval Postgres Professional: http://postgrespro.com