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 1wUgiN-001MhY-1P for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jun 2026 08:12:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUgiM-000T76-1R for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jun 2026 08:12:38 +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 1wUgiM-000T6y-06 for pgsql-hackers@lists.postgresql.org; Wed, 03 Jun 2026 08:12:38 +0000 Received: from mail-yx1-xb131.google.com ([2607:f8b0:4864:20::b131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wUgiJ-000000010mD-24yV for pgsql-hackers@lists.postgresql.org; Wed, 03 Jun 2026 08:12:37 +0000 Received: by mail-yx1-xb131.google.com with SMTP id 956f58d0204a3-6608c1a4215so631228d50.0 for ; Wed, 03 Jun 2026 01:12:34 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780474353; cv=none; d=google.com; s=arc-20240605; b=dYQDkVu8EHa3EuuqDQ347JWP9vfErEvnfXUUDRDB7L8NTfOeOJDgaJ0uZlYF3JWcWx DEw2Ny5WTENfosL2Nsgf4TRWOYDTM8qYbSvXdP10opVT+fNXsGAeJjqhxAoEdSAaKzrZ F4TXLWnk/Kmn4sxlaBJVI4CYzDhemYSfdRo4VQ7NynMf7dz93LJiWF8rfxtQfa0JzSgm izKnnOJUl0M+mA5F3ug06AKdnJZvEEZlZSVQ4TmsiihTinOz1AIIpLHUrlX4hsvIWKx9 0iGcJEnoC6xO5SRdk48dlHSN4ctX9QJ4uZa24VFE/8v77W9GDHH2iCWTuYa7oEfGmLU+ V9rg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :dkim-signature; bh=ah0g17I/nqztwWZcikhCdPdxxCVLuaapPAm79FN6DTM=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=izW5Qef0kdnGjQcd1nUtAlc7VS9EbjrbusY7/aWfNoeMwpzA48neAFSIL8qnZIo3EP 2pRWfnI4WBMQW1pEZSIOSaWVqbIc0g6qVsE8Kg8Gw0q/fytJQK54d3KNVLNgSyfRFYmL fXQRhRkzS06ZS3t9bjqkLPsZD9EhCC/CwrhIfduchVJYZyUuXId1Ka8ue2OGvb1+Zs5A H4AiqaJvcm5N6FAVXMhhbvXhpuOwyMrc6H9MJn7fw/bArlMXKflsdb3qDZxQcR+6fMzW 4I88EP49aiIt6BT6+4wQBRkWPqAlEvskjpJOchQ7blApu8Wp6Jg871eAKuDQRLOKDqTy g0bQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1780474353; x=1781079153; darn=lists.postgresql.org; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :from:to:cc:subject:date:message-id:reply-to; bh=ah0g17I/nqztwWZcikhCdPdxxCVLuaapPAm79FN6DTM=; b=h8o3agLBS3Kror2XIBCjjiPmnmEhLq8QyCfTcyJcSCcOZctUDM0l0B/fiqncOBz1HK v2Rr211T9CwgcV2UA0znf/NRyKMJw+icswbEC2NQxA74ehmkJLc4dqJhfBuEcg/VED38 uZ+Oh/mDEqk1EhrAmF2qOEMigqbUpgIH8sE74= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780474353; x=1781079153; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ah0g17I/nqztwWZcikhCdPdxxCVLuaapPAm79FN6DTM=; b=LquRk6s2YBeBZI5iEqc1fQcfPPDSlWdjbF6KCthNpqZo3d1wKbgkjX23u3i+/CwPZC 2+X8dP0G0R4Vt4Ir5xuvymUmXLB3NxwUdebSqGCIBO8QY4+eY9DKiTt2XfDr0Pd9KaHw Ud7TmcZR09j76I60qim3TDljeMKuy8RpikxdaW7PPdRhd0VFD34ikVfDAHbjfln2ki3a +tc2fHZCanjuyi/vL5Sr//FzMW9hdWnyPW4yvrvO8trVeaUs30IBoz47XCMD1w0nmvup l3Xk46IQYBHGEiJEytNPxYYIrz50xRFvuho3uYoWD16HYmHghtfRq5giAySRJqUKEnLI OhCQ== X-Gm-Message-State: AOJu0Yy4mD/WoTvm8/r/b9tM/qteQ6+Ldwhs86K25y5uPZm7IYp4DYfF h35RzMF41EICvO8ejLPbmoWEwUyODHAF15HFyIH2Rfus2+L415Oypph/fw6qTtr/Aprghax5jxm FTNRdA/tXYLgn5Sq5TvSbao9N6OTVa+TDnA7DXvc22GtzLEi4+On0Ro2QSxsIaF89PHl6Db5knC u0kt/HohK2NdpAn6FKCH+khoArpykNM+GrgooBzA/Hn5T3aVK6i3yfM4pTwO9ZQMaL6oR8fE7aM kQYDiRkuuzVYHSld+UVOXE89b8nPYL+pDksRF9cdOwdDzuCIFM10r/W8WmeECS0g3yW0OKbZda6 qA== X-Gm-Gg: Acq92OFeDAEZM+a0GEXTQHou0vq7qnvbW5sdlonHjCPL3pjgMh2sgESVteQ30Qn5cua MLJkvV9sizcP2JnXs4/l2mJSwrUdbFMD1VwYKh39L4X5bacV3tmkMD61zMoGfMJxCpvT1n+c+Uz nUmLS4P81K78AAi2eExE5uNflGUGvYufd0ni89o/p+g3Q1hxC/pK4QYoDTgOq51tiSlz/fQ44a1 wVGEhkkf4MAO/Lj0BfUjlZB9Wz2TNtG+Ux6c8s6y4D4a8QMeKsweWDxEvpKmkwIWmpwvaXoRTpK 7ftMSn4eH/QXo7CUCp2ygdXskFR/DB174Z/8NjVJq5B6j+F+zJDh48N7XlMbWzFr/oOM+YScFaH N/SQ= X-Received: by 2002:a05:690e:b8d:b0:654:fd9:2e88 with SMTP id 956f58d0204a3-660dcc39b9cmr1479052d50.31.1780474353199; Wed, 03 Jun 2026 01:12:33 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 3 Jun 2026 03:12:31 -0500 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 3 Jun 2026 03:12:31 -0500 From: Zsolt Parragi In-Reply-To: <185FC597-BF26-4075-9D59-E5905ED74E0F@gmail.com> References: <33E9C4C2-B6A8-4FCC-BEEA-461EA5FB98C8@gmail.com> <7F0EA98A-6DBC-436A-8FF4-4A511A05ABE6@gmail.com> <7B7172F4-DB02-4259-997B-6AEF5ADF7FCE@gmail.com> <185FC597-BF26-4075-9D59-E5905ED74E0F@gmail.com> MIME-Version: 1.0 Date: Wed, 3 Jun 2026 03:12:31 -0500 X-Gm-Features: AVHnY4KeA8VwGFiC1bG8SfCRvpS3ABTszdKKqI4r81GKr0Y4ismdNYGjKBwYQ74 Message-ID: Subject: Re: Fix bug of CHECK constraint enforceability recursion To: pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Thanks for your view. > > I just tried your test with v6, but didn't see the bug you mentioned: Eh, sorry, that was a user error on my part. There were 3 new patch versions in a short timeframe, I applied one, built postgres, realized it's not the latest, applied the latest instead... and didn't rebuild postgres. It's not reproducible with your latest patch.