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.98.2) (envelope-from ) id 1x7X1x-00000000Skg-3Gch for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Sep 2026 11:45:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x7X0x-00000000eKj-2nl7 for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Sep 2026 11:44:23 +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.98.2) (envelope-from ) id 1x7WzR-00000000eGy-1i2H for pgsql-hackers@lists.postgresql.org; Fri, 18 Sep 2026 11:42:49 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x7WzO-000000001NR-2uYY for pgsql-hackers@lists.postgresql.org; Fri, 18 Sep 2026 11:42:49 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id 11BDDEC00B4; Fri, 18 Sep 2026 07:42:45 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Fri, 18 Sep 2026 07:42:45 -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=1789731765; x= 1789818165; bh=6JtAo9SGVx5C2h6mSRFZVmwfoajcStLfJM5RCqvKpUs=; b=A 8XVTEPiEdAFd18fkUNuJCI/UzQjy4udo17audARNnlyGIHGou7mPa5Hbm4Wg+qja 3XPwIV1o/eOSoGo/aYuUSl9hTEJWHAG2lTyVKV+XZqjOnw2OlbCXXuTlGM6QXuhh oGcJTUcwgCQyC/CpJHoaZEtEFMeeK7RtRhqj0nbUkflIcvb9Ui1OS9nDp/EKrPk8 otW3zi3n8lpGMsp0AyRM/TnZUffTzxNjWHWZ3EB/EtB03/SQQgCBsQvUPpSNrJCg PKH4hAFg6FgF/jMQFDs9mHZX6uNVMPaT6WmjV6MhK1ONf8RyzYTAMuqwiby4ACaH EXCOBsX54prGk2alB4w5w== 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=1789731765; x=1789818165; bh=6 JtAo9SGVx5C2h6mSRFZVmwfoajcStLfJM5RCqvKpUs=; b=Hct7KTwHXT0HvTjVk H+yatLlSkkGkXEcKuoWPNeOC3CcICBNlKqp6BkhzmZSW2uTkrLWOO4ZQle5KzU8X Fn7HnIGgTl4LzkY8j49SXlGCtaUXcPE7OoZGLLR10ytrvlDE9ZxqirHoNMTMcKcZ 8rMr4adGOAgMTi7/g7DwN8AaVH/Zz7ghveLsb7fv/R2v47MGaxpB0sOmrvas0hGO DMRtlFgP3p/bECFRYfg/aHxS1AtO3DWMxnTXIUnDfyXxBQf+bxJfBeCRIXjfAQCi qUG4HcuJwXddT5yLGtrLrKKcE0KibR4UirZDiH9GHH8VJuh7XVqBvloZOwkj86Ad HG60w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGLuuVOoHkBtaKwIqAKpM6sc/nKMDzGCXko/SJXEj4WtA/uLyFRKHEPAkGSgJMkLi 7jEnKnTRTcAvboHf2M9QExGvX6S8aftzEe7Eoe/DRPMS5hTIqH3hdI5o/5JKHfTCGgJnFG xLEhEYIzb9Z2hLWHQOEkXwU57L2s3z54la6Q0wvVNqqg+fNbni7g40tnv3bTGYLITAb8bs qp6U2UHRaTGXWCxnswPgz80N440u/8rvxTps2JcUph+Q+KCL7kAkxV4SOKtfGkbbDEwJVY 0l55+ikiCtgsY20fQ79Tv+uf6N5X4mTlihv7fZIOQq/6g31t/wiIOMQ+RfaJGnbF4hRDdh x8Cs50zbyp4VkMzK0QpHWODs2dLjWVMLXUQIH9HoQSwDjyftk/hEgO5Bwn5RMBZ3ZalYUi kCrhxyfNGvs3ml6nWTq8DRcIpIutyvdZY9Z3b+6I6qVPh9x8VhPkh65uTJlD45r4MYie1C Y/KrMyArg/x86WNmEC/aT+rFSsRq0D8MY+nTIahCRx+80E+u5bTQ1AzjNv3i1vj355qrvb pk5T1/ipS6yws/e1RD5bHyVAgV8OOcU6PZ6vrSCrd3RKYv983PnLgSJd+KVa2qalYhh1RZ 7lJTG+0XelnQ0RkKUP0tPrGM3IHgHDWwEOu/HRU/0xR9jCXT3JoNRdC+P4JA X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 18 Sep 2026 07:42:44 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1789731762; bh=EXzj2PX/oEhuV1fsDSnuCFAamgA6d1Ho662394F1OMI=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=7gqffiIoLaSiTgQNDRA2VUscUAWSCaGmoHyrxhs2/sManzCILKo7ubd1VEGYqc0UB 7bXVsK5Z/lu6DUMJRyUZ5YAewYBScJOUDdHQTEsHErkoQWWL5hE9VAKenEMOea9pYs 3REVpUd1upckr/DxpGURhfTmiufSczhybwSRYoUuBx3VgVAQiLQU+qWybWde9JtHX6 uW8AqqxsxDEYE+hVegCdTqQWQJOy1TOiy+KfDPP8E1EPwZw2xSiSJJjeICRbuV3UY1 ktLnJGN9ONdGhVb4aLv4NxjfWahDyiX+Q8E/od0jqq3joG78snbHsC3aItaY60J0eB 0m3OdlRvCmJwg== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id B9346B0008E; Fri, 18 Sep 2026 13:42:42 +0200 (CEST) Date: Fri, 18 Sep 2026 13:42:42 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Zsolt Parragi Cc: 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 Pushed, thanks. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ Syntax error: function hell() needs an argument. Please choose what hell you want to involve.