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 1x6rmc-000ULY-0n for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 15:42:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x6rmb-008Be2-20 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2026 15:42:49 +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.96) (envelope-from ) id 1x6rmb-008Bdu-18 for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 15:42:49 +0000 Received: from mail-qk2-x28.google.com ([2607:f8b0:4864:34::28]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x6rmY-00000000p8w-091r for pgsql-hackers@lists.postgresql.org; Wed, 16 Sep 2026 15:42:49 +0000 Received: by mail-qk2-x28.google.com with SMTP id af79cd13be357-93910cadeb7so129062885a.0 for ; Wed, 16 Sep 2026 08:42:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1789573365; x=1790178165; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=4PQme938Iep3m6kHZox2YVvkc0BzImfJuyZsrJMlz/w=; b=epnnjcyyKjwoTskP2N/l/YWTLJp981zgdl1BIrpkoLlCMaW/xlonhCqac7E2CluqBL 4Qb4MvBu7aHn3QVRnxqk4zcJ6gxxtwRKa+HzwhxRrxMV92C3mZNIHiycCOgxQenLfiQS TeWBN7eG5Z2hThj9hB5vPtXsVdAj8JSdeA4a6ZxwECyDYI7YwdNEi84bemsBGfSTlRJc 2b9H6qJh+ksTeKp4BoqXE9HipWPbcr/EBWYyB80ojkX2EpZgngmLy7gz1t1Y/izcnzji kO+GODg7XVL/5mUZTJDKNnawUOobyobsmPq7ZTskKYa/PR8f/ZlV+n1KZ3yHZaC6V1FW kzjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1789573365; x=1790178165; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=4PQme938Iep3m6kHZox2YVvkc0BzImfJuyZsrJMlz/w=; b=uwB8Iv3uWH/i4fLvBGhhJt58QTYJSxrpdkKhN03MBqIJ311Ltqd4lkkMa3OZcPKXEx K6wxkMtzAMnbBAQC+kd4Cye1/F7u0/ruwGtnUqZn5Cl6YF2kBvQ+qVQuT4FfUPTAQ96X Fosqz1R+ES93C2YB92jlt5QAzEp3xgPLDija8yfKhnn63+O5fPZ9Nm542yWpE3j9G/sK a9lT+SUyop3cFRlcFl2agbpj8b5DrgXlX4YBSR1jFHSM6VPsv4xcwfK97SuQzjS5nBRI 16un+dt1zYjcUzDP/cdFy2TcLkYw8mMbU09kubkrqeOxiZokX8LjGrj/4fis2nyq5H8l RlVA== X-Forwarded-Encrypted: i=1; AKwUvByxf8JcM+5IKo322x8YiUMJQa7wV6fGe0GFPnjUUdbWyUOGQYJYw+BQM5M+No1O4XAT+BnDfQ02ArXUG31r@lists.postgresql.org X-Gm-Message-State: AFuF++n0EQ59Cqlu3FKTkZnkdy/eois4adV+qdTpmEiZMF9kOVLzvjit Giiv8fGd4iAbDsMApmNPwdmLTaYfhE+OLoORQD6psWMTVVMlI/1QSBLI X-Gm-Gg: AYBFou3tWBXQqc2ZdldwbCc4TBEssHwIImMnk45ibF/GlAFhQfuZcgUr9G6eYLhvlZZ UEN7Uk4/eSEtsozHPE6480xbLCQ/ExT7XhHnM7wYP6EZbFwtnA3I7CXXogTJ8YuVnDvte+ErdlQ /2LIBodlSCN9FKC5kQEyOVXxIwvO5hUO1ahnvv5T5Yt5jM/1J6YROWYQo165L+6B3lJKEICNRXE /6JHCKkOXl9f6JWLwRb/FZIk/ZI2+umC6me314jGfwBJRHROMQNUY6ftp2S0apUgcQikKg3T6JS LI0airS93fF3DqS+w4KU/ZDsdpEQywkBTsIDVbgw6bCy1xCz2PqL6aVI3JbsKQd6ZO5NBTNclXF fwH1N5728fJc1qlalt6cD4wL5+zuuYBus/08SzVG9cZ2VFEAPaN/afOKltLvS3olcXZZWF+ZflF neXUEEn/Ly0S0fpc0O21u6GKH8CFPh/f+T5OJpWj7k/mtTIqo4SeUC+RIxvaMpy0GdMZO//aN+a zL2pT1OebuaFb5/XWCF9jhd8nNfg2dWHxtCR9DjOSnvoS65N4+7pN+r9N/NPQntjdeOqNSeS+WN Unzbh2z4V5aTeWpWdbHGa3mBDCra+69pSe9K X-Received: by 2002:a05:620a:6888:b0:93a:c10c:6b5a with SMTP id af79cd13be357-93bb789d08amr592348985a.29.1789573365352; Wed, 16 Sep 2026 08:42:45 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id af79cd13be357-93b7823dc4csm240824585a.24.2026.09.16.08.42.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 16 Sep 2026 08:42:44 -0700 (PDT) Date: Wed, 16 Sep 2026 10:42:42 -0500 From: Nathan Bossart To: Zsolt Parragi Cc: Mihail Nikalayeu , pgsql-hackers@lists.postgresql.org, Michael Paquier , alvherre@kurilemu.de Subject: Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk [RMT hat] 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? -- nathan