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 1v4NUt-00E3G7-5G for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Oct 2025 17:53:43 +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 1v4NUq-008lJ0-VW for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Oct 2025 17:53:41 +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.94.2) (envelope-from ) id 1v4M8E-008OEA-JR for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 16:26:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v4M88-0003B9-1n for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 16:26:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=+2dGWmsV1MdOa8NjWgUk8IjmvDW3uFf+ZTcVn8h5uIA=; b=mq2b4S3XE4CFfiAPphSgBeHAtz Hx4pJpc+Nj7F2lV2Cl16AwRzzGtnF9lKxV8joqi68Aiw6eyyIY/4bnoo8d1XJbnWBJHR5BAOcd1g0 m5U3g/R/2p66HNvxDXzcOA3MIiMMTQPHAYSb1KHPdMM5wFJTCiTdd/G4BZoHsiJ0kJqeqx5nQ7AHK 4yKr23BqC0bqbwAC24S1yNRDKvlCpaplzYG5oRNjyeylxEVfVUufDvook5RFAsue67DvwXajukpxb QldubWNqUJTTLpYyxJzMpNNEWLm5Vfup21ic0QpvlXBTVUIB1R/NLQKdDEBYubH0zfnjldUhKp1KJ uhYxFObQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v4M83-002wmp-HN for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 16:26:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v4M83-005pnO-05 for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 16:26:03 +0000 Content-Type: multipart/mixed; boundary="===============1433278100953507582==" MIME-Version: 1.0 Subject: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mohen.lhy@alibaba-inc.com Reply-To: mohen.lhy@alibaba-inc.com, pgsql-bugs@lists.postgresql.org Date: Thu, 02 Oct 2025 16:25:58 +0000 Message-ID: <19070-781326347ade7c57@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1433278100953507582== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA3MApMb2dnZWQgYnk6ICAgICAgICAgIGhhaXlhbmcgbGkKRW1haWwg YWRkcmVzczogICAgICBtb2hlbi5saHlAYWxpYmFiYS1pbmMuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTguMApPcGVyYXRpbmcgc3lzdGVtOiAgIGFueQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGkg YWxsLApERVRBQ0ggUEFSVElUSU9OIENPTkNVUlJFTlRMWSB3aWxsIGFkZCBhIGNoZWNrIGNvbnN0 cmFpbnQgdG8gZGV0YWNoZWQKcGFydGl0aW9uLgpIb3dldmVyLCBJIGZvdW5kIGFuIGlzc3VlIHdo ZW4gdXNpbmcgaXQgb24gYSBoYXNoIHBhcnRpdGlvbmVkIHRhYmxlLgoKVGhlIHJlcHJvIHN0ZXBz IGFyZSBhcyBmb2xsb3dzOgpgYGAKQ1JFQVRFIERBVEFCQVNFIGRiMTsKQ1JFQVRFIERBVEFCQVNF IGRiMjsKXGMgZGIxCkNSRUFURSBUQUJMRSB1c2VycyAoaWQgaW50LCBuYW1lIHRleHQpIFBBUlRJ VElPTiBCWSBIQVNIIChpZCk7CkNSRUFURSBUQUJMRSB1c2Vyc19wMCBQQVJUSVRJT04gT0YgdXNl cnMKIEZPUiBWQUxVRVMgV0lUSCAoTU9EVUxVUyA0LCBSRU1BSU5ERVIgMCk7cwpDUkVBVEUgVEFC TEUgdXNlcnNfcDEgUEFSVElUSU9OIE9GIHVzZXJzCiBGT1IgVkFMVUVTIFdJVEggKE1PRFVMVVMg NCwgUkVNQUlOREVSIDEpOwpDUkVBVEUgVEFCTEUgdXNlcnNfcDIgUEFSVElUSU9OIE9GIHVzZXJz CiBGT1IgVkFMVUVTIFdJVEggKE1PRFVMVVMgNCwgUkVNQUlOREVSIDIpOwpDUkVBVEUgVEFCTEUg dXNlcnNfcDMgUEFSVElUSU9OIE9GIHVzZXJzCiBGT1IgVkFMVUVTIFdJVEggKE1PRFVMVVMgNCwg UkVNQUlOREVSIDMpOwppbnNlcnQgaW50byB1c2VycyB2YWx1ZXMgKDEsICdhJyksKDIsICdiJyks KDMsICdjJyksKDQsICdk4oCZKTsKCkFMVEVSIFRBQkxFIHVzZXJzIGRldGFjaCBwYXJ0aXRpb24g dXNlcnNfcDAgY29uY3VycmVudGx5IDsKClxkKyB1c2Vyc19wMAogVGFibGUgInB1YmxpYy51c2Vy c19wMCIKQ29sdW1uIHwgVHlwZSB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgRGVmYXVsdCB8IFN0 b3JhZ2UgfCBDb21wcmVzc2lvbiB8ClN0YXRzIHRhcmdldCB8IERlc2NyaXB0aW9uCi0tLS0tLS0t Ky0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQppZCB8IGludGVnZXIgfCB8 IHwgfCBwbGFpbiB8IHwgfApuYW1lIHwgdGV4dCB8IHwgfCB8IGV4dGVuZGVkIHwgfCB8CkNoZWNr IGNvbnN0cmFpbnRzOgogInVzZXJzX3AwX2lkX2NoZWNrIiBDSEVDSyAoc2F0aXNmaWVzX2hhc2hf cGFydGl0aW9uKCcxNjk5MCc6Om9pZCwgNCwgMCwKaWQpKQpBY2Nlc3MgbWV0aG9kOiBoZWFwCgpc cQoKcGdfZHVtcCAtRmMgZGIxIC1VIHBvc3RncmVzIC10IHVzZXJzIC10IHVzZXJzX3AwID4gdXNl cnMuZHVtcApwZ19yZXN0b3JlIHVzZXJzLmR1bXAgLWQgZGIyIC1VIHBvc3RncmVzCmBgYAoKVGhl IHJlc3RvcmUgZmFpbHMgd2l0aDoKYGBgCnBnX3Jlc3RvcmU6IGVycm9yOiBDT1BZIGZhaWxlZCBm b3IgdGFibGUgInVzZXJzX3AwIjogRVJST1I6IGNvdWxkIG5vdCBvcGVuCnJlbGF0aW9uIHdpdGgg T0lEIDE2OTkwCkNPTlRFWFQ6IENPUFkgdXNlcnNfcDAsIGxpbmUgMTogIjEgYSIKcGdfcmVzdG9y ZTogd2FybmluZzogZXJyb3JzIGlnbm9yZWQgb24gcmVzdG9yZTogMQpgYGAKCkFmdGVyIGRldGFj aCwgdXNlcnNfcDAgaGFzIGFuIGFkZGVkIGNoZWNrIGNvbnN0cmFpbnQgdXNlcnNfcDBfaWRfY2hl Y2sKY2FsbGluZyBzYXRpc2ZpZXNfaGFzaF9wYXJ0aXRpb24uClRoZSBmaXJzdCBwYXJhbWV0ZXIg aXMgdGhlIE9JRCBvZiB1c2Vycy4gSW4gdGhlIGR1bXAsIHRoZSBDUkVBVEUgVEFCTEUgZm9yCnVz ZXJzX3AwIGlzOgpgYGAKQ1JFQVRFIFRBQkxFIHB1YmxpYy51c2Vyc19wMCAoCiBpZCBpbnRlZ2Vy LAogbmFtZSB0ZXh0LAogQ09OU1RSQUlOVCB1c2Vyc19wMF9pZF9jaGVjayBDSEVDSyAoc2F0aXNm aWVzX2hhc2hfcGFydGl0aW9uKCcxNjk5MCc6Om9pZCwKNCwgMCwgaWQpKQopOwpgYGAKCldoZW4g cmVzdG9yaW5nIHRvIGRiMiwgYW55IGluc2VydCBpbnRvIHVzZXJzX3AwIGZhaWxzIHdpdGggRVJS T1I6IGNvdWxkIG5vdApvcGVuIHJlbGF0aW9uIHdpdGggT0lEIHh4eHguClRoaXMgYmVoYXZpb3Ig c2VlbXMgdW5kZXNpcmFibGUuIE9IT0gsIGEgZGV0YWNoZWQgcGFydGl0aW9uIHNob3VsZCBiZWNv bWUgYQpwbGFpbiB0YWJsZS4KVGhlIGZhY3QgdGhhdCBkZXRhY2ggYWRkcyBhbiBleHRyYSBjb25z dHJhaW50IGZlZWxzIG9kZCwgaSB0aGluay4KCkkgY2FuIHRoaW5rIG9mIHR3byBwb3NzaWJsZSBz b2x1dGlvbnM6CjEpIENoYW5nZSBzYXRpc2ZpZXNfaGFzaF9wYXJ0aXRpb24ob2lkLGludDQsaW50 NCxhbnkpIHRvCnNhdGlzZmllc19oYXNoX3BhcnRpdGlvbih0ZXh0LHRleHQsaW50NCxpbnQ0LGFu eSksCndpdGggdGhlIGZpcnN0IHR3byBwYXJhbXMgYmVpbmcgc2NoZW1hIG5hbWUgYW5kIHRhYmxl IG5hbWUuIFRoaXMgY291bGQgb25seQpiZSBhcHBsaWVkIHRvIHRoZSBtYXN0ZXIKYnJhbmNoLCBh bmQgaXMgbm90IHBlcmZlY3Qg4oCUIGUuZy4sIGEgUkVOQU1FIG9uIHRoZSBwYXJlbnQgdGFibGUg d291bGQgY2F1c2UKb3RoZXIgZXJyb3JzLgoKMikgRHJvcCB0aGUgYWRkZWQgY29uc3RyYWludCBh ZnRlciBkZXRhY2guIFRoaXMgc291bmRzIGNsZWFuZXIsIGJ1dCB3b3VsZApyZXF1aXJlIHN0b3Jp bmcgYWRkaXRpb25hbAptZXRhZGF0YSBpbiB0aGUgY2F0YWxvZyB0byBpZGVudGlmeSBzdWNoIGNv bnN0cmFpbnRzLCBzbyB3ZSBjYW4gcmVtb3ZlIHRoZW0KZXZlbiBhZnRlciByZWNvdmVyeS4KQWdh aW4sIHRoaXMgaXMgcHJvYmFibHkgb25seSBmb3IgdGhlIG1hc3RlciBicmFuY2guCgphbnkgdGhv dWdodD8KCuKAlApSZWdhcmRzCkhhaXlhbmcgTGkKCg== --===============1433278100953507582==--