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.94.2) (envelope-from ) id 1v7UZa-003WFz-MU for pgsql-bugs@arkaria.postgresql.org; Sat, 11 Oct 2025 08:03:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v7UZX-00Ff8T-9v for pgsql-bugs@arkaria.postgresql.org; Sat, 11 Oct 2025 08:03:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v7UZW-00Ff8K-8l for pgsql-bugs@lists.postgresql.org; Sat, 11 Oct 2025 08:03:23 +0000 Received: from m16.mail.163.com ([220.197.31.2]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v7UZP-001AXG-2G for pgsql-bugs@lists.postgresql.org; Sat, 11 Oct 2025 08:03:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:To:Subject:Content-Type:MIME-Version: Message-ID; bh=fTDbNR/uviqznzwmQPwP5WwWZgPOBKmMX2niTvapb48=; b=a E/qe1gZzcF35eqbIbkt6HGwUNrnaZMAnUsPPbvnhb6kCkE3j95Am8M2fZlCRftAw 5BgkazftWsMjDK7TD9ikahTXyiviY5FzCal9wmz6+/BdWC+4JIMDYhSJldx4sXdP cR+rXiZZFdzNr4EoNCXOnS/35ahGDd2pzOsigsMG3E= Received: from ocean_li_996$163.com ( [2401:b180:1000:2:4195:497a:4195:497a] ) by ajax-webmail-wmsvr-40-103 (Coremail) ; Sat, 11 Oct 2025 16:02:59 +0800 (CST) X-Originating-IP: [2401:b180:1000:2:4195:497a:4195:497a] Date: Sat, 11 Oct 2025 16:02:59 +0800 (CST) From: ocean_li_996 To: songjinzhou Cc: =?UTF-8?Q?=C3=81lvaro_Herrera?= , "mohen.lhy@alibaba-inc.com" , "pgsql-bugs@lists.postgresql.org" , robertmhaas Subject: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on ahash partition table X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2023.4-cmXT build 20250723(a044bf12) Copyright (c) 2002-2025 www.mailtech.cn 163com In-Reply-To: References: <202510101057.2czghujtfz33@alvherre.pgsql> <17a8f848.b7f6.199cf1e3b5e.Coremail.ocean_li_996@163.com> X-NTES-SC: AL_Qu2dAv2dtk8s7yCRbOkfmUoVhOc5Xsq4uPgu3IdQPJB6jC3pwh0kXn5CHVnW3smhIhKNrzqWTzZSxdVjWLRidJgAZBO7uv/I9NWDeJGfZEM1IQ== Content-Type: multipart/alternative; boundary="----=_Part_99134_454577338.1760169779110" MIME-Version: 1.0 Message-ID: <5ca9d8f4.65cd.199d24b5fa6.Coremail.ocean_li_996@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: ZygvCgBn_tkzD+po4Y4IAA--.1902W X-CM-SenderInfo: prfht05bolsmizw6il2tof0z/xtbBgBnjj2jpuNsimQAOsi X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_99134_454577338.1760169779110 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 SGVsbG8gamluemhvdSwKCgpUaGFua3MgZm9yIHlvdXIgb3Bpbmlvbi4KCgpBdCAyMDI1LTEwLTEx IDEwOjAwOjU0LCAic29uZ2ppbnpob3UiIDx0c2luZ2h1YWx1Y2t5OTEyQGZveG1haWwuY29tPiB3 cm90ZToKPiBIZWxsbyBoYWNrZXJzLCBIYWl5YW5nLiBJIHRoaW5rIHRoZSBkaXJlY3QgZGVsZXRp b24gb2YgdGhlIERldGFjaEFkZENvbnN0cmFpbnRJZk5lZWRlZCBmdW5jdGlvbiBpbiB0aGUgcGF0 Y2ggYWJvdmUgbWlnaHQgbm90IGJlIGEKPiBnb29kIGlkZWEuIFdpbGwgdGhpcyBjcmVhdGUgbmV3 IHByb2JsZW1zPwo+IAo+IE9mIHRoZSB0d28gc29sdXRpb25zIEhhaXlhbmcgbWVudGlvbmVkIGVh cmxpZXIsIGlzIHRoZSBzZWNvbmQgb25lIG1vcmUgYXBwcm9wcmlhdGU/IFNob3VsZCBpdCBiZSBk ZWxldGVkIGFmdGVyIGRldGFjaGluZz8gRm9yCj4gZXhhbXBsZSwgc29tZXdoZXJlIGluIHRoZSBE ZXRhY2hQYXJ0aXRpb25GaW5hbGl6ZSBmdW5jdGlvbj8KCgpBRkFJQ1MsIHRoZSBtYWlubHkgZGlm ZmVyZW5jZSBiZXR3ZWVuICJEaXJlY3QgZGVsZXRpb24gb2YgdGhlIERldGFjaEFkZENvbnN0cmFp bnRJZk5lZWRlZCBmdW5jdGlvbiIgKHRob3VnaHQgMSkKYW5kICJBZGRpbmcgY29uc3RyYWludCBm aXJzdCBhbmQgcmVtb3ZpbmcgaXQgbGF0ZXIiICh0aG91Z2h0IDIpIGlzIHRoZSBtb21lbnQgYWZ0 ZXIgdGhlIGZpcnN0IHRyYW5zYWN0aW9uIGNvbW1pdApvZiBkZXRhY2ggY29uY3VycmVudGx5LiBJ biB0aGF0IG1vbWVudCwgdGhvdWdodCAxIHdpbGwgbm90IGFkZCBhIGNvbnN0cmFpbnQgb24gZGV0 YWNoZWQgcGFydGl0aW9uIGFuZCB0aG91Z2h0IDIgd2lsbC4KCgpIb3dldmVyLCBkZXRhY2hlZCBw YXJ0aXRpb24gc3RpbGwgaGF2ZSBhIHBhcnRpdGlvbiBjb25zdHJhaW50LCB3aGljaCBpcyBmdW5j dGlvbmFsbHkgcmVkdW5kYW50IHdpdGggdGhlIG5ld2x5IGFkZGVkCmNvbnN0cmFpbnQgZm9yIGEg cGFydGl0aW9uIHRhYmxlLiBSZWdhcmRpbmcgdGhlIHBhcnRpdGlvbmVkIHRhYmxlLCBvbmNlIGZp cnN0IHRyYW5zYWN0aW9uIGhhcyBjb21taXR0ZWQsIHRoZSBwYXJ0aXRpb24KY2FuIGJlIHJlZ2Fy ZGVkIGFzIGFscmVhZHkgZGV0YWNoZWQgZnJvbSBpdHMgcGFyZW50LiBUaGVyZWZvcmUsIEnigJlt IGluY2xpbmVkIHRvIGdvIHdpdGggdGhvdWdodCAxLgoKCi0tCnJlZ2FyZHMKSGFpeWFuZyBMaQoK ------=_Part_99134_454577338.1760169779110 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdj5I ZWxsbyBqaW56aG91LDwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+VGhhbmtzIGZvciB5b3VyIG9w aW5pb24uPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5BdCAyMDI1LTEwLTExIDEwOjAwOjU0LCAi c29uZ2ppbnpob3UiICZsdDt0c2luZ2h1YWx1Y2t5OTEyQGZveG1haWwuY29tJmd0OyB3cm90ZTo8 L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTogLWFwcGxlLXN5c3RlbSwgc3lzdGVt LXVpOyI+Jmd0OyBIZWxsbyBoYWNrZXJzLCBIYWl5YW5nLiBJIHRoaW5rIHRoZSBkaXJlY3QgZGVs ZXRpb24gb2YgdGhlIERldGFjaEFkZENvbnN0cmFpbnRJZk5lZWRlZCBmdW5jdGlvbiBpbiB0aGUg cGF0Y2ggYWJvdmUgbWlnaHQgbm90IGJlIGE8L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0i Zm9udC1mYW1pbHk6IC1hcHBsZS1zeXN0ZW0sIHN5c3RlbS11aTsiPiZndDsgZ29vZCBpZGVhLiBX aWxsIHRoaXMgY3JlYXRlIG5ldyBwcm9ibGVtcz88L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHls ZT0iZm9udC1mYW1pbHk6IC1hcHBsZS1zeXN0ZW0sIHN5c3RlbS11aTsiPiZndDsmbmJzcDs8L3Nw YW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6IC1hcHBsZS1zeXN0ZW0sIHN5 c3RlbS11aTsiPiZndDsgT2YgdGhlIHR3byBzb2x1dGlvbnMgSGFpeWFuZyBtZW50aW9uZWQgZWFy bGllciwgaXMgdGhlIHNlY29uZCBvbmUgbW9yZSBhcHByb3ByaWF0ZT8gU2hvdWxkIGl0IGJlIGRl bGV0ZWQgYWZ0ZXIgZGV0YWNoaW5nPyBGb3I8L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0i Zm9udC1mYW1pbHk6IC1hcHBsZS1zeXN0ZW0sIHN5c3RlbS11aTsiPiZndDsgZXhhbXBsZSwgc29t ZXdoZXJlIGluIHRoZSBEZXRhY2hQYXJ0aXRpb25GaW5hbGl6ZSBmdW5jdGlvbj88L3NwYW4+PC9k aXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6IC1hcHBsZS1zeXN0ZW0sIHN5c3RlbS11 aTsiPjxicj48L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6IC1hcHBs ZS1zeXN0ZW0sIHN5c3RlbS11aTsiPkFGQUlDUywgdGhlIG1haW5seSBkaWZmZXJlbmNlIGJldHdl ZW4gIkRpcmVjdCBkZWxldGlvbiBvZiB0aGUgRGV0YWNoQWRkQ29uc3RyYWludElmTmVlZGVkIGZ1 bmN0aW9uIiAodGhvdWdodCAxKTwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZh bWlseTogLWFwcGxlLXN5c3RlbSwgc3lzdGVtLXVpOyI+YW5kICJBZGRpbmcgY29uc3RyYWludCBm aXJzdCBhbmQgcmVtb3ZpbmcgaXQgbGF0ZXIiICh0aG91Z2h0IDIpIGlzIHRoZSBtb21lbnQgYWZ0 ZXIgdGhlIGZpcnN0IHRyYW5zYWN0aW9uIGNvbW1pdDwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1m YW1pbHk6IC1hcHBsZS1zeXN0ZW0sIHN5c3RlbS11aTsiPjwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFu IHN0eWxlPSJmb250LWZhbWlseTogLWFwcGxlLXN5c3RlbSwgc3lzdGVtLXVpOyI+b2YgZGV0YWNo IGNvbmN1cnJlbnRseS4gSW4gdGhhdCBtb21lbnQsJm5ic3A7PC9zcGFuPjxzcGFuIHN0eWxlPSJm b250LWZhbWlseTogLWFwcGxlLXN5c3RlbSwgc3lzdGVtLXVpOyI+dGhvdWdodCAxIHdpbGwgbm90 IGFkZCBhIGNvbnN0cmFpbnQgb24gZGV0YWNoZWQgcGFydGl0aW9uIGFuZCB0aG91Z2h0IDIgd2ls bC48L3NwYW4+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5Ib3dldmVyLCZuYnNwOzxzcGFuIHN0 eWxlPSJmb250LWZhbWlseTogLWFwcGxlLXN5c3RlbSwgc3lzdGVtLXVpOyI+ZGV0YWNoZWQgcGFy dGl0aW9uIHN0aWxsIGhhdmUgYSBwYXJ0aXRpb24gY29uc3RyYWludCwmbmJzcDs8L3NwYW4+PHNw YW4gc3R5bGU9ImNvbG9yOiByZ2IoMCwgMCwgMCk7IGZvbnQtZmFtaWx5OiAmcXVvdDtQaW5nRmFu ZyBTQyZxdW90OywgJnF1b3Q7SGVsdmV0aWNhIE5ldWUmcXVvdDssIEhlbHZldGljYSwgQXJpYWws IFRhaG9tYSwgJnF1b3Q7TWljcm9zb2Z0IFlhSGVpJnF1b3Q7OyI+d2hpY2ggaXMgZnVuY3Rpb25h bGx5IHJlZHVuZGFudCB3aXRoIHRoZSBuZXdseSBhZGRlZDwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFu IHN0eWxlPSJjb2xvcjogcmdiKDAsIDAsIDApOyBmb250LWZhbWlseTogJnF1b3Q7UGluZ0Zhbmcg U0MmcXVvdDssICZxdW90O0hlbHZldGljYSBOZXVlJnF1b3Q7LCBIZWx2ZXRpY2EsIEFyaWFsLCBU YWhvbWEsICZxdW90O01pY3Jvc29mdCBZYUhlaSZxdW90OzsiPmNvbnN0cmFpbnQgZm9yIGEgcGFy dGl0aW9uIHRhYmxlLiZuYnNwOzwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6ICZxdW90 O1BpbmdGYW5nIFNDJnF1b3Q7LCAmcXVvdDtIZWx2ZXRpY2EgTmV1ZSZxdW90OywgSGVsdmV0aWNh LCBBcmlhbCwgVGFob21hLCAmcXVvdDtNaWNyb3NvZnQgWWFIZWkmcXVvdDs7IGNvbG9yOiByZ2Io MCwgMCwgMCk7Ij5SZWdhcmRpbmcgdGhlIHBhcnRpdGlvbmVkIHRhYmxlLCBvbmNlIGZpcnN0IHRy YW5zYWN0aW9uIGhhcyBjb21taXR0ZWQsIHRoZSBwYXJ0aXRpb248L3NwYW4+PC9kaXY+PGRpdj48 c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6ICZxdW90O1BpbmdGYW5nIFNDJnF1b3Q7LCAmcXVvdDtI ZWx2ZXRpY2EgTmV1ZSZxdW90OywgSGVsdmV0aWNhLCBBcmlhbCwgVGFob21hLCAmcXVvdDtNaWNy b3NvZnQgWWFIZWkmcXVvdDs7IGNvbG9yOiByZ2IoMCwgMCwgMCk7Ij5jYW4gYmUgcmVnYXJkZWQg YXMgYWxyZWFkeSBkZXRhY2hlZCBmcm9tIGl0cyBwYXJlbnQuJm5ic3A7PC9zcGFuPjxzcGFuIHN0 eWxlPSJjb2xvcjogcmdiKDAsIDAsIDApOyBmb250LWZhbWlseTogJnF1b3Q7UGluZ0ZhbmcgU0Mm cXVvdDssICZxdW90O0hlbHZldGljYSBOZXVlJnF1b3Q7LCBIZWx2ZXRpY2EsIEFyaWFsLCBUYWhv bWEsICZxdW90O01pY3Jvc29mdCBZYUhlaSZxdW90OzsiPlRoZXJlZm9yZSw8L3NwYW4+PHNwYW4g c3R5bGU9ImZvbnQtZmFtaWx5OiAmcXVvdDtQaW5nRmFuZyBTQyZxdW90OywgJnF1b3Q7SGVsdmV0 aWNhIE5ldWUmcXVvdDssIEhlbHZldGljYSwgQXJpYWwsIFRhaG9tYSwgJnF1b3Q7TWljcm9zb2Z0 IFlhSGVpJnF1b3Q7OyI+IEnigJltIGluY2xpbmVkIHRvIGdvIHdpdGggdGhvdWdodCAxLjwvc3Bh bj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTogJnF1b3Q7UGluZ0ZhbmcgU0Mm cXVvdDssICZxdW90O0hlbHZldGljYSBOZXVlJnF1b3Q7LCBIZWx2ZXRpY2EsIEFyaWFsLCBUYWhv bWEsICZxdW90O01pY3Jvc29mdCBZYUhlaSZxdW90OzsgY29sb3I6IHJnYigwLCAwLCAwKTsiPjxi cj48L3NwYW4+PC9kaXY+PGRpdj4tLTwvZGl2PjxkaXY+cmVnYXJkczwvZGl2PjxkaXY+SGFpeWFu ZyBMaTwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2Pg== ------=_Part_99134_454577338.1760169779110--