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 1vJWMF-009beX-3D for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Nov 2025 12:23:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJWMD-001Nd8-0h for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Nov 2025 12:23:21 +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 1vJWMC-001Ncz-2f for pgsql-hackers@lists.postgresql.org; Thu, 13 Nov 2025 12:23:20 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJWMA-006umK-0k for pgsql-hackers@postgresql.org; Thu, 13 Nov 2025 12:23:19 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-5943d1d0656so1126309e87.0 for ; Thu, 13 Nov 2025 04:23:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763036596; x=1763641396; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=NR2AqVidSV+RQqF3QlhQfh1S8fXzPyPHLYZRbp0ghOA=; b=FjPZcnA3/7l2tM9zaxsJcTsp3GQFIB3D5seX94lkb9sF48q5G7dbdzUioZjSG9b8Rk IbsbWtEpy5FMiA/ZMg45ISeM+N/3JmUzf0CUNLFXJAkd+fLBo99BU18esczNDdYY6l3R zhDYdwH9rJ3rjBEcjcvsoM0Gh4oI5doqMqLoBu6A4G7QexVdVHMmODh1a5vhsNoVUTTS CpahiTU7tpnDzu0AMC93dZ/HRKxtEkg1wQSs2G5y7vTYnCRpPpsVie8EKjSYkwQGAJdc TngrMH6XjNEPsXijc/U7Ve7Oa5fPQRvOpYdPT0Mp+xaMx0Oq6+em5eRHZz/39MeViFUc DMkQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763036596; x=1763641396; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=NR2AqVidSV+RQqF3QlhQfh1S8fXzPyPHLYZRbp0ghOA=; b=sFp22KB9IuaaN6rT/0K40WynPks2mZ8R8jzR7Tf9K1oaKWOSkCs3GJdeUnGoQL034i CSEOw6AFMJ9hGwmEOleTgE4ZurC73+v7SBmM6fJpvk861VuLJi3P+7CrqmCMXiBKAWOP ZUBKFwpVT7hgBGsuMDlvnnqmQb5FOlwJrnfRDuRnqF1vrnQt7ftHt23Fjx25qnRZ2Q0p 4ZV/CbLj2pUR8IgrQyqaLuGWSEszMB9A8SZsUVh8eeRKOqlNLdor9gZPu+AJYXyleEk9 sxxzovRhAX65hMrM9tYj5auuSnuqjW3GM+nhJtBkY64PbgLWtepXWjkcngSAePTCAWN7 g7sw== X-Forwarded-Encrypted: i=1; AJvYcCUe3cBqweEG9gLieDKJa3i7sQtTUVd/k1hnzApk0Xrof3Qv7121kXIIJ7+RLvjGMELRSPXO8q/78fdus0oz@postgresql.org X-Gm-Message-State: AOJu0YxTXAmbPPaEoWOIAcbirfZ+Kxo+rEtA4Rp+hilfrFRDqjhJiYcq 7n/52Z5E+pwqf4NC+5Q8TVV7We2r5F2HdFBemb4z99MXZ5ZHLXMeI4gSJUQymim6+PP0dAIZptW 6eDcSk6ER+zZn5mfqMyCUqjly4zRQJk4pE/Qs X-Gm-Gg: ASbGncvPj4rLBhBit73mme4+EWlWDF/UwD/nOL68+Lpywzu+Y354KTTHTR5czJ9n+To o3ecFVc9/iEnUFtOTTUS9AYvW3BvzXU7NBW5eSHIiZqlrubAtcMc5+eMuDgIKN7orIGvQuUmarx ioPzKIXbHjaAh6nh4vSe55xecje/v5oQY7/5FW5FapmAjbEL87oAvEE9ru3QkUx9raWuqgikeLA vGeJZ2+AvCdXa0kuSQBtxb8ZqPHKMzuolwRyyeUfKxiYoBHqAYnTLAwTcHA5vps3tafwA4ZOcH3 F1DfN3i5KPYpoop016Y= X-Google-Smtp-Source: AGHT+IGFekhU7dtqv/dnsoQWDnw+0CK/ondgLWo/tKR2MzS2nUKvVfiSNamqZ24WXrQg5hYYZWsi7ArdB1Ky2lU9lbY= X-Received: by 2002:a05:6512:40cd:20b0:595:7c57:e0c2 with SMTP id 2adb3069b0e04-5957c57e2bcmr1442717e87.55.1763036595384; Thu, 13 Nov 2025 04:23:15 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Mihail Nikalayeu Date: Thu, 13 Nov 2025 13:22:38 +0100 X-Gm-Features: AWmQ_bnA9Gj6l30DIyuo-I7gx31xtpRc7EwQQAga2r1pbfDmXbU5OiZi0U-RQeE Message-ID: Subject: Re: [BUG?] check_exclusion_or_unique_constraint false negative To: Amit Kapila Cc: "Zhijie Hou (Fujitsu)" , Peter Geoghegan , "Hayato Kuroda (Fujitsu)" , PostgreSQL Hackers , Andres Freund Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, Amit! On Tue, Aug 26, 2025 at 1:08=E2=80=AFPM Amit Kapila wrote: > I think it is better to document this race somewhere in a logical > replication document for now unless we have a consensus on a way to > move forward. I have added a draft of the documentation patch in related thread [0]. [0]: https://www.postgresql.org/message-id/flat/CADzfLwU_o%2BeL2z9ifkpW2%2B= kSJEXEbXkTmomvoEw-UY9CzgOn1A%40mail.gmail.com#2919d50a20b530092ec7e6ec71709= 697 Mikhail.