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 1x6tbp-0000a5-31 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 17:39:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x6tbo-008s3F-1W for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 17:39:48 +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.96) (envelope-from ) id 1x6tbn-008s36-1m for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 17:39:48 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x6tbl-00000000Rwr-21yl for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 17:39:46 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfhigh.stl.internal (Postfix) with ESMTP id 30A2F7A007C; Wed, 16 Sep 2026 13:39:44 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Wed, 16 Sep 2026 13:39:44 -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=fm3; t=1789580384; x= 1789666784; bh=MC0mZZMwdK6zyhSWOnCWCYBbjHSFvAqwP1gfyugyZ5c=; b=W XaZQDWmx3Znh/tvtBv24HiHAZZltwP+TidvoGucDeug2dQ2Q3lEmHGWQm/cqBdPd yBvGQdeFYCY3iMMvWf3EraMrHw57Mn6+IQ6t0yziSama/RZwEOFrssc6pEGHVzWA 2u/k3gyf1RxFHFu0TKBmHD9Z6cfR+crYrMhuhfqWj0rXAgYbNMLbTh/qG1r11hI4 mIQhQSwzqGi4FbZ06Kc6OS2j8zQzajSJkwPopCuGX2hWtUoyeGyCLRgmrpTZ44iw 1ia/v4F7x2zkV/n/610KVYWN9pv6JPrCfT9Znoh4Xk6flepr+OOtpak+2NlQtwb4 Zz07plf7jSesdPiK+SeTw== 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=fm1; t=1789580384; x=1789666784; bh=M C0mZZMwdK6zyhSWOnCWCYBbjHSFvAqwP1gfyugyZ5c=; b=o3kVs2CCkjayCmC5x OqNzy9a+LlcO8P5chG7dN10Wlq7kDJBerpLljYWB4WNUQFXRcfSwQj5fI4ZbbmMs H4hdZmYAKwCir0qZFOsXeOSAoisaxpIwoQQT3AsGxKTrPPADC7UD5CWA7ifIh++4 Jn99KRjaReWuyS7NlVt8YUu4Z6psxu88nmyzR7F31R6ckJ4quWJ/bzY/WdDg3NWQ GMrmnusN3dkjnwt2vUHkWNzYZBCTjmN6WOTXtbjoQKVyBSs9D1IIgjtuqCuSYcVd 058zahWAWHhBBttaKlkSsq2aotOHt2TBIDpi0bycQ/P+CWa1mEIPWeDbLfSSoQEG QGaUg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGFGfMKHJsnQt36qL5x7RglP3f345I0oe6pr961zGW8gMnc6o3ZAniJU3UxUfWtyj qWGSWmCCzydk90xrxgNnmyCB+JzrtTUpT3IDoV9ZgTulWygg47Jkrr1K5/zdgsP95zBkIZ nQxwX2/5o+hn1PlK3pewMTOPIHBmlKwO9FUsJN2BTy/jQPonWp6agNmYbsVkmMujefFDjX BL2Z1tKuavJ0dDSjGXg/mrB4N8LkJCeFNgrZeCUmX3Y7et3bzrtLY46tr8M8nXv/Arxbdw COw7d7QsGrbQ0ClAAQHLn2MopUxklnOLTni4BM7R89ZqAJQtp0/tbaQ1kvjNxEvcy/x3L4 5+gIrsnf77f0w26iaJ0wL4d8HnA2QLmJyL4qRJv6P6pZh6e8LD6JIJiq1eOJXND5kH1wVY oM2SyETA66f684knKfrHO8N9T5gdFgWL+8ZbtOQx/gWAuFLjAlW+agPlTL4jDEKk2/gPIZ 7dGeL1nd1DnhazQLdbJXu1yU1y+3kpVO8M6fryxlr1hLIqFL0dsX+GY1lFz8C2K8kEyj00 IPQ1hBNdsS1w6gdw3O/sUTiOPnaR4MTun8892asm+5vGlKvCgC/OlnIiNB9vfJ6TEaMk2M 1Vr2FTsyKfst4OFGBVCcPZKee25rRCSRU6xm6pplKcUiqNtBFSzqNzQreFcA X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 16 Sep 2026 13:39:43 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1789580379; bh=Ty9DA5HaMnYjc/3j4XuvZJ6ogdXl2sCFBdg+0JaafyY=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=UMeqLoXpKseD4B/kzOueGjmVG54R9WrEnqOTZXuqD2CEOaK5hdZlDk168LrTYj+JI 85C7G3FytzciZ9dsEWa75YknSQ2JXuZoPPuV0++2E6C/2YmNJMSqGyfGEgxYPg+soq z4cpQX9pU/TrStsi0DFa0tJDQRmLResopFe6/JHO43mg2jQFTWLJ97lcLCDdKDOyy3 ofsQqT7wUqFXHz+V9llwfSDUMaCP6VM/No8aCnWxvWKVigOVj9iW573qE8SybMXCGn P/OI5dZolbxnEr3sQgvpQlwLaLeTwYvlq869dt34ZUZl2L1pDxBCOd3QmmxoDnMVBr L22JdUViuiWug== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id 307DDB002DE; Wed, 16 Sep 2026 19:39:39 +0200 (CEST) Date: Wed, 16 Sep 2026 19:39:39 +0200 From: Alvaro Herrera To: Nathan Bossart Cc: Zsolt Parragi , Mihail Nikalayeu , pgsql-hackers@lists.postgresql.org, Michael Paquier Subject: Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Sep-16, Nathan Bossart wrote: > This one is listed as an open item, but there haven't been any updates to > the thread in a couple of weeks. What is the current status, and can it be > fixed before code freeze for 19beta4 begins on Saturday at noon UTC? I haven't reviewed the proposed fix yet, but I'll strive to get the fix in before that deadline. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/