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 1wUmiN-001RY1-0a for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jun 2026 14:37:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUmiJ-001qEa-3B for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jun 2026 14:36:59 +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 1wUmiJ-001qER-2C for pgsql-hackers@lists.postgresql.org; Wed, 03 Jun 2026 14:36:59 +0000 Received: from mail-yx1-xb12b.google.com ([2607:f8b0:4864:20::b12b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wUmiG-000000014C6-2soi for pgsql-hackers@lists.postgresql.org; Wed, 03 Jun 2026 14:36:59 +0000 Received: by mail-yx1-xb12b.google.com with SMTP id 956f58d0204a3-66039d3efcbso7217590d50.2 for ; Wed, 03 Jun 2026 07:36:56 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780497415; cv=none; d=google.com; s=arc-20240605; b=kKBFMl5hxL/zf8z0fFQ48sXO9TRr3ovXQdXzqZgFm6a+uqcxLcqMSgvok/r4mvIfmc Gx7ttTWR+KqvaJYwjcN9JjlAw5baW30NHOSfoFG4Zig9bW+H/QmVcHuElyhjyomrRtmU qZGrYZ7JSFu51ZV0Fldl75WGlY3aUMUG3hqKTKtJkASJCj8RehdA/ahXePPv4pfo9ASa /ArRVOsWtJc3m6/NDVGs2pMjpON3oVFxH5GauUvuoFf85isZPQnZD4iY5wgxood8lfML dYzKdqkzb+HkajccinhTLwDw0cpkodtMjT8WpzEnC0NWPnQirZ6SfbG43GfcQo5KcjsG 6waQ== 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=K9RB4BHEyVMA0+B7gZLLdbdqXGeLx2jRLZx7zywClWE=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=eufzP9MbEBOZRrwgYGXGA0nKG5P1cUwZz3byrlDGStjrbnH+rbhRXKes87OunfW1ng YLZN8XKYqS1NpWy8UfG3z+Ux9yTXL7q1uCZdceGqeN3oiwxchZDOl3wL6nTDxIluhXSc r2UryT69j6q9+8Edrvj8KDxi+iashf+fRkB2J83l26OJvXkpvhbw1EIXya4NPuzcF8kr EXZgm5ENGllm1/RnS+ohbU3crvLKifgR+Pe44nTGYWkEir67FDlxBd5JDdxycCl//PU8 r68hKRmtN+QHARA4MNkI8XQ8+BaXmRDgn+vhkhnJSQpzu3NZWPx7lmKoc4zRuLsa6djC efwQ==; 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=1780497415; x=1781102215; 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=K9RB4BHEyVMA0+B7gZLLdbdqXGeLx2jRLZx7zywClWE=; b=TeFSlHMhkV4oC+AceNWFv37sk03f483D5MLKeGNkwUjhgF6xR1whamKghO5gZsVpR1 cG1+TbyPY0zOr5JzhN7h2rH/amsiRyWurvQ+Uq/hzSXtYn1alB7bAkkIHHtYafMKp09c DuknLiuLQfWEQkGeRimSJQzfR8rS/Zyb0xHqM= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780497415; x=1781102215; 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=K9RB4BHEyVMA0+B7gZLLdbdqXGeLx2jRLZx7zywClWE=; b=og3MqYXnmMtrZYxgUBVSJk/LY5I3n/GUWynJeoCxBaAOe8MJ0DPP5v9E8TiESzyEdk qbP/lbkOM4F2bcumHUExevl/gZ1ykn/ecmhz7oxyFtahoj7Div+f0KBfjnFGSBEjF31y nolZWTZxKNQr7YOIRcsnvg7nF03fRdVjq1bDa6hEm8bJ4rb8x6UqtJfPCA+CAOJ0B1pX U+Z7zb93NWNookAFDnpKzGnhCReCLs9eMvLl5g6pQCSy1ejmC+OcxHr4mx3hJq1bRmBr FQNAuk+/ejvzq+zI1bQx2CZ2wNTOBLI7lqcR5/7FxzOb9U6ynPXFlfEzcI1qWV8Anc/8 W+1w== X-Gm-Message-State: AOJu0YxladmK9vcRPmKKUm7HzO0CcdzyHz2T7il2s5/81D08JzXCZ8uL AVPbobsUbfcncwKn95XDlDPaectMsID07lg1X/15lPmDTheTyXqiL7kVfT2jBFPep/nww+EDlF5 lHeprTYEQXodnml7lgrptudzr7PTjDOLqHRkWyMeWQql9Zm/4EnUIqjp31UbwGZdtKCM/llXhSk fDscKbtz1cwYxCfK2jI39gFc+09CdtcjKnDE96D+hopKuutWDpcJijMUqw0rGI9l7YN4dsSYOFh oziYkEr+pVqSbA7g231yQ5DhpK6p59/vZdRt3aqrCE6abuLji4Z9wiv9Xw2xiEgiZYdsCpvWTtc rw== X-Gm-Gg: Acq92OHpiYgKbjn1sz87X9GBkRxzU+cCSfcOP9otfb/6a900IZN3yta8xptGzA0WAV5 K3qXSihRBnMemyAgN6C6HgThAJFx7oRiqm7bOCgH+/IsFbNIiyO/xpq6W76fvszfpby/gTHw+r/ lIp5kDFz5FW0eo6Kq4di65su+GrGTpFFYsS03nia50yEo50VlGLVSD6MKAzPgTpSeoQcrBCA2a7 PYKwA9LrH1J7C1uoRARg3s/JPbG3yZ0/S4Jd0jyh8iRXIwfZVGs0scH0P5ZlVcOB0YFKZaXwqcp 4/2uWYspuyAo+WdbT/sY/pRxMdfPctUlljijQguaRJtxy9gLQT5f7fUeS1ZnLUDU2BM5A+NrqL0 B8XY= X-Received: by 2002:a53:d016:0:b0:660:689b:1539 with SMTP id 956f58d0204a3-660dc5af389mr2886062d50.58.1780497414737; Wed, 03 Jun 2026 07:36:54 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 3 Jun 2026 07:36:53 -0700 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 3 Jun 2026 07:36:53 -0700 From: Zsolt Parragi In-Reply-To: References: <33E9C4C2-B6A8-4FCC-BEEA-461EA5FB98C8@gmail.com> <7F0EA98A-6DBC-436A-8FF4-4A511A05ABE6@gmail.com> <7B7172F4-DB02-4259-997B-6AEF5ADF7FCE@gmail.com> <14E223D8-8425-446A-A36C-6B62BC334656@gmail.com> <9A3D388C-1DF4-4C43-9AB6-83529A8F48C8@gmail.com> MIME-Version: 1.0 Date: Wed, 3 Jun 2026 07:36:53 -0700 X-Gm-Features: AVHnY4KIopjF730Vvrfvk-UC_x8wnSwUFjip-Duzb9M2qohOhgppUByN1Tera6g 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 Hello After a bit more testing, I think there's still a remaining issue with the latest patch: create table root_t (a int constraint c check (a > 0) enforced); create table p2 (a int constraint c check (a > 0) enforced); create table d () inherits (root_t, p2); create table e () inherits (d); create table f () inherits (e); alter table root_t alter constraint c not enforced; insert into e values (-5); -- succeeds d remains enforced as it should, but e and f doesn't.