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 1v7eQG-005ppq-EI for pgsql-bugs@arkaria.postgresql.org; Sat, 11 Oct 2025 18:34:28 +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 1v7eQE-00GjLc-2c for pgsql-bugs@arkaria.postgresql.org; Sat, 11 Oct 2025 18:34:26 +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 1v7eQD-00GjLF-8R for pgsql-bugs@lists.postgresql.org; Sat, 11 Oct 2025 18:34:26 +0000 Received: from fout-a4-smtp.messagingengine.com ([103.168.172.147]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v7eQC-001EnS-1I for pgsql-bugs@lists.postgresql.org; Sat, 11 Oct 2025 18:34:25 +0000 Received: from phl-compute-07.internal (phl-compute-07.internal [10.202.2.47]) by mailfout.phl.internal (Postfix) with ESMTP id DAA3EEC014C; Sat, 11 Oct 2025 14:34:22 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-07.internal (MEProxy); Sat, 11 Oct 2025 14:34:22 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1760207662; x= 1760294062; bh=wHz2t6OLCrdDxu6syV0PM4B5uNN0XyxXJI0dLmhy3s4=; b=W ToCKm7FnkX5Co/F5Dg3pBbki26WAhaVRl10zKXCE28zwOhd5rLTOXjHzkUeCuvLR dYOUu3Hr1C9X8P8Y6r8xbhT5dyQk+5YyMCzOiYNpuLm9axmZksi1g6wVjUFA6ccV /HNzqGGPE+VziBYgdSGW0tbcQrwC7eLDEd85B1TZNguy/6rsYk77SZLSOF0ifjcI +Ksg4jin/gi/ERTxLJUPv8eSv+HoF1vsPYsBraqLMu3c1zWV5ohnvKGVRvscrAHV MLo7uEwvnSiY37HNgCLNQu4apNUrS/A/g+56Vf6JXTB9F81x3UcaiwAWdcW7xYwQ zpZ67azod9DHfZ7VlSglg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1760207662; x=1760294062; bh=w Hz2t6OLCrdDxu6syV0PM4B5uNN0XyxXJI0dLmhy3s4=; b=ZBQCdHsRQTSkvsa6I jILklPtJjqNqiqjjLeYKsY7XSMv4yAA/nZXGxHP8XZdefOENSdBHdfKUo0LX8E4U l8fzkCHHsiJ/cEqxnUSkLU0CAv910+cojomDv/0OJfZbrslwusYDgg63oeAv/5BE H0NFeiffmjNo4BWKgvBuACy3s7t7f3PGe5FBuVHPKGN6jxeM3OR9WAvuq8hC09eb m7BNje4TMhb4g1bNpzyN3Rx1JutYIHrV8mfSIyGVbIRW3z8Zgwrya8kPXXJ8r4I3 Ort9GmGBM+9B1MJM6z+FyQ7dsiCWNgYK699LQvcpGxrNlg3cOKWYvHwJOSXCIdGV pQjLw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduuddviedvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpeffhffvvefukfggtggugfgjsehtkeertd dttdejnecuhfhrohhmpemllhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgeqnecuggftrfgrthhtvghrnhepteeuvdehffekvefgueehve etveekgfegtddtueefueehuddutdfhfeffhfejfeffnecuffhomhgrihhnpegvnhhtvghr phhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghp thhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepohgtvggrnhgplhhipg elleeiseduieefrdgtohhmpdhrtghpthhtohepmhhohhgvnhdrlhhhhiesrghlihgsrggs rgdqihhntgdrtghomhdprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrph hoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 11 Oct 2025 14:34:21 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1760207658; bh=ltLNV4MSOY3OsQfB/HQ7Fo2NhyTK9sHL1LXqgtkrHGY=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=sp04PPpyuRniQCm+qtYN4QP9Q75RttC4+JyBFL7FsMWg1JK9cZJc5q2YvXcQSxJJ5 yOiQmbKTsyLC9tCryBDV0U0PZqH/FA8BeQjqvonVSj0Oz2cqsLG0gdANf//fDrS4WU 2NmJ55uYWTVaadZzVdlk2DC37q3Zmj3wKVZMnr1qRynZXPGBkR9y8tb7kA7Z6K7hCT RF00KVOF4HrpjUB5VN1GbToSwnY4eKcGsuA+KzGciSE3ckW69X3yIus81gDX5z+Bkj JpxY3V6fBMkgttYF+ahoDP10BohddeSXFYoPdcIhb5GOGWNW2IHWBFo7pfyl5qR1i2 jr2+yoTc7Wp0A== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id C710B6A; Sat, 11 Oct 2025 20:34:18 +0200 (CEST) Date: Sat, 11 Oct 2025 20:34:18 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: ocean_li_996 Cc: "mohen.lhy@alibaba-inc.com" , "pgsql-bugs@lists.postgresql.org" Subject: Re: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table Message-ID: <202510111831.xmk4a6jrtrqm@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <17a8f848.b7f6.199cf1e3b5e.Coremail.ocean_li_996@163.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Oct-11, ocean_li_996 wrote: > Based on the discussion in #18371 and my own investigation, I think the > proposed fix is appropriate. I’m attaching patches for both the stable > and master branches, FYI. Yeah, looks good -- pushed to all branches since 14. One thing I modified in branch master is that the test just above the new one is testing that a constraint is being added, but that's no longer true, so I removed some lines there. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "El número de instalaciones de UNIX se ha elevado a 10, y se espera que este número aumente" (UPM, 1972)