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 1upRIv-005Ake-Gq for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Aug 2025 12:55:38 +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 1upRIu-005yO8-OR for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Aug 2025 12:55:37 +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.94.2) (envelope-from ) id 1upRFp-005vZN-T0 for pgsql-hackers@lists.postgresql.org; Fri, 22 Aug 2025 12:52:26 +0000 Received: from mail-vk1-xa36.google.com ([2607:f8b0:4864:20::a36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1upRFo-001H6i-1i for pgsql-hackers@postgresql.org; Fri, 22 Aug 2025 12:52:26 +0000 Received: by mail-vk1-xa36.google.com with SMTP id 71dfb90a1353d-53b1718837dso850419e0c.0 for ; Fri, 22 Aug 2025 05:52:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755867143; x=1756471943; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=JLMG2U7zwFW3gG2gcN4L26TEBVq+msjSr7y6gBB9+GQ=; b=ZNsOMzmdesFpyJep8FH4UK15+uoWUFqCuUT2V4tcd/pAO3O6R3+NtMDslvVINVJrz7 45rWhTeyYeE1SWU0WUBsEaK5jmm7lr4pu6gltxwjxMUbjPGF6TFJcWvwzXqCZ4EX6Pyb uCVuFtGwFknd7DtRBMeWNla0r3p+QbDrk6Hdx7b5kuwMIgC26cyiMSWpsN/NOc1ktEIP KyYm91woboHW22JH+27a+411B5YWpBovLYfaxWGqs7N9GwGmI78AEoynXVTOi4VCeQIE Ys1Gd6erqxmsyT0Ac7qkP3tL4zQjxR1kaXkwvXP1m/tcjCMct0/BOJW5qmPDrg9CCcoj YjGA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755867143; x=1756471943; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=JLMG2U7zwFW3gG2gcN4L26TEBVq+msjSr7y6gBB9+GQ=; b=KQtOilJ+2QwOCP9EvT44QHVpFn6b5Kwcn3eOol79hVSHlsP5WuBPeAdxyKnpBImBC+ LrNwwWhNJoG+EI+SE7AZjuiQr9f+hfrOISY8onbUOXfV2UpRpikvmGbAQrCz9Re5Swnn lveWSqVtm1bGr0MUasaH/4gbY8r0pveaQ8/qgaS4TuXFdE5b6QR8ehfLHBlZRiHdxBzZ jV83nmjeWyh29w1c/oZp6C0XOrfr8IALdgvvO1XAE/G42Bi3tPJQm+9UZjs5Jv1/gkGe 1XUI8h+yc344CYn/4hoJHeozKWv0ZmAsMEMRXIIlygtkqv/taGeLUYyOZu4Cn+GcFIk/ k+dg== X-Forwarded-Encrypted: i=1; AJvYcCWcL7ZrI/YaV/Ko9OMSuzsYIpAeYKt2bKhmguzd7FIMLRTpI7HE6czdSLzFnmUO8sWgOMsgL2D7RSDEAani@postgresql.org X-Gm-Message-State: AOJu0YwzeFh5OH/4t+9TPB9Nx7akFHJNja4NmP5D4TwzL+vFnTIBp/tk ZjYN2Tvr2KBIDmbYptM72CmH3dkHHxZFYUEq1Yvb2AuHpAdXjNwRCYPvMecHVI2rnab/7sqtG0k b4Si/tq4ZgA24sGQ7Jpw1apy2chk1irk= X-Gm-Gg: ASbGncuxVl7s4SfzBB2/XRnlXHE4eopawsFeiooGaudTKioYJr+se29M5r2JG659TdL TQlN6hHtyKZQhQ2gKQ5JveugUKs0fainKiiV8jeL8ag1YzA9l3HLzjLWq27p9bEPo5prW1rizP1 9Q+Q/yCXi++FaGeVs2bAoIgyoNRwSt8vC4Sw4PSb30FBzRBs57U8j3xr5uvbcYJNBaqAAL9EtsX TT/XNM/ X-Google-Smtp-Source: AGHT+IH2imOaNMjjnjsxvcxMxB+BN3LQSnAYkchyAQD1Mp/oa+t9Vfn0s5JJmQtNwG5QvcRMZRpzdaa96lOuOzfKAiw= X-Received: by 2002:a05:6122:21a0:b0:53c:6d68:1cc8 with SMTP id 71dfb90a1353d-53c8a40bab4mr777005e0c.14.1755867142715; Fri, 22 Aug 2025 05:52:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Mihail Nikalayeu Date: Fri, 22 Aug 2025 14:51:45 +0200 X-Gm-Features: Ac12FXxTQZETs_UsBfPvV7D2pmX4kVDpHcdSDd30NazcGNTxwQoZGoOFYmEOhaM 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" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Oh, > in index page appear because HOT was applied... I mean "HOT was NOT applied", sorry for the inconvenience.