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 1v7Au5-00G79F-V6 for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Oct 2025 11:03:18 +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 1v7Au3-00Bkf1-JJ for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Oct 2025 11:03:16 +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 1v7Au2-00Bkes-Uw for pgsql-bugs@lists.postgresql.org; Fri, 10 Oct 2025 11:03:16 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v7Au1-0011jI-2u for pgsql-bugs@lists.postgresql.org; Fri, 10 Oct 2025 11:03:14 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id C755DEC018E; Fri, 10 Oct 2025 07:03:12 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Fri, 10 Oct 2025 07:03:12 -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=1760094192; x= 1760180592; bh=ChzuZggYs61Eb5GrZbazmnP5/WvmZPCqlJyutHpJiCA=; b=K 9M3J6LYzXplA8msDVAPtIPyL/mU7YKdYmy0a/qtmqmSbDhEZA8a/8FPmDYW9fh/N uyhk2jee8FQiQLsDXiiDywkBTrqFzXZqQ3n9bVdnLgAbVaDMoKARuOzz708uqoGG 37Cr8PH0LNiYkstBmJXldiry3ukFijk9UH8FKqxKWo84jrmvBzdunZUF0pfmXCVX XAUa364fy1SjemWqWbvw5UNxboDfdBiTMqe470A14SFbN6qE7L3CY6GU0NVSMhkW +MLA4jpIjvJrcOlnsAbqLq4/VuPo+B5jOHrtjBpdyc0+Uqvfch3xAJyDny8CmOwy pQ978gzW16NaLbVFx7JYg== 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=1760094192; x=1760180592; bh=C hzuZggYs61Eb5GrZbazmnP5/WvmZPCqlJyutHpJiCA=; b=OSUx00QqtScycbhRr gho0TRZiHzFstljTIrV9wzCpbZsBSodnYR0Yd3olHyHLWkYXUrpCt3Xk+n7QyLWQ kr9LUHddcArmx9jwJ73TUGrUrixqoeCQB4ewB1BMkkW22D2g6g75zqcFHSc+C3g8 cDpO1lKLRHduz6pHwgMk0exYiKbaEg6KEumgMG+CWv3PpKlKpr1lRwfTbSqkjnC7 /DGni9dWKGIRLSXTxXJHS3uwcbZEmMrKuqVoadu3kFfqs3vOhFynVmmQGMDqVauX aWCwcTZLibbXyCj2VD0EK7b3QDq7ablVFzZnKWwNKErXbwkPl8JvCPWCWhSZUE0U obkqQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddutdekkeelucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpeffhffvvefukfggtggugfgjsehtkeertd dttdejnecuhfhrohhmpemllhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgeqnecuggftrfgrthhtvghrnhepteeuvdehffekvefgueehve etveekgfegtddtueefueehuddutdfhfeffhfejfeffnecuffhomhgrihhnpegvnhhtvghr phhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghp thhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepohgtvggrnhgplhhipg elleeiseduieefrdgtohhmpdhrtghpthhtohepmhhohhgvnhdrlhhhhiesrghlihgsrggs rgdqihhntgdrtghomhdprhgtphhtthhopehrohgsvghrthhmhhgrrghssehgmhgrihhlrd gtohhmpdhrtghpthhtohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgv shhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 10 Oct 2025 07:03:11 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1760094188; bh=Jf57COJyjrs9VPP+/8Kz85PpCQ70yDPn590Y7GxLY6E=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=qxWe80AE1bM1nW//APhE6CCITyNqHA/iX6a7OmaguCoLoe4hm8rR4W9Dzn0ND38Ey TBAfCmWjG+YeUJ35RBmLbwlY6QWCSEoUiwtfaSjqeENFryBgVRgiHFIwfiAKcNlaeV aZS5Ul7/wcFpMmfvEtY9W67QMJL5X8bQLm5mbSEUlh5STFXkQM1h85uKdPK4JZe8mR RHXj+mBi7u0uLvH9VAxwfwVgm0468qWOmwnf4pVehA+EsQVfi5TBQnHKCVYLc2aaYj 8jCejLJzDNCXRvDGoJRHH6MfAvfOOd66/3G0JJatQzpnbkfgNkeCguPA+8PuHn4nGk 1WCuBNE+QxlQA== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 2362657; Fri, 10 Oct 2025 13:03:08 +0200 (CEST) Date: Fri, 10 Oct 2025 13:03:08 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: ocean_li_996 Cc: "mohen.lhy@alibaba-inc.com " , "pgsql-bugs@lists.postgresql.org " , robertmhaas@gmail.com Subject: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table Message-ID: <202510101057.2czghujtfz33@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1831e120.1e8.199cc10d785.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-10, ocean_li_996 wrote: > Since there has been no update in this thread for a few days, I > reached out to the primary committer for this functionality. Yes, this is buggy, and has been reported previously (#18371). I'll fix it before the November minors, probably by removing the step of creating the constraints during detach. I think for stable branches I'll do that only for hash partitioning, to avoid breaking workloads that might depend on those constraints, but for branch master I'll do it for all partitioning strategies. > No offense meant; I’m simply interested in getting your perspective. Yeah, I should have reacted sooner to the previous report of this bug. No offense taken. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Linux transformó mi computadora, de una `máquina para hacer cosas', en un aparato realmente entretenido, sobre el cual cada día aprendo algo nuevo" (Jaime Salinas)