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 1wQROz-001YjT-1y for pgsql-hackers@arkaria.postgresql.org; Fri, 22 May 2026 15:03:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQROx-00DVHn-1S for pgsql-hackers@arkaria.postgresql.org; Fri, 22 May 2026 15:03:04 +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 1wQROx-00DVHf-0X for pgsql-hackers@lists.postgresql.org; Fri, 22 May 2026 15:03:04 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQROw-00000000uFM-0frn for pgsql-hackers@lists.postgresql.org; Fri, 22 May 2026 15:03:03 +0000 Received: by mail-pj1-x102f.google.com with SMTP id 98e67ed59e1d1-36a7bbb9698so423299a91.2 for ; Fri, 22 May 2026 08:03:01 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779462180; cv=none; d=google.com; s=arc-20240605; b=DNidcN2xEuSiwgcQX3uCEmZesVvaMyWvxYhU1yueWoMm727cImyFzw2gDvHsI/bSkh oPL01gJskFHy08WRGXcM02dZTTDtPblpsPCvVBBGhh/PN0ZZwQswd5Cp0HsRZQCzHnnk yjNtvFvlwgI9/nam7onniVDlOB7ImO5DoKOhGFHvJdpe+DghajIWW0oTeHIW3b0LewDQ FuYoshjSypzSVrt+QpJ0YaccUgv8bp/PS9kDtAWUBVHxe6iurdyD31fENnq/7oX6qcBr Zw4NPEAvJZComemslKZUKtATIxwh+mnvJCMcblA2ij+2x/m4VSPfrrm9SqtI++ZSZxf6 vhyg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=oBIG/j2Um4WYIwo+rkMHRK0Ea2c5nB8r1iYZs0YbKeI=; fh=/jPG4Qn7VDqygyYD1zJorqX79DzzK/wOQFwdB06VvxM=; b=jbCS523PHlLLBaZe5bAedtB2jnp64OG+1IrFNEeL1A0JwO5g/Uyyq5G2BNmI37RbbM e3zlhaCgjaVFp3cvh0UF1dTKl48eLYr9MRIqwu/ggaHSb1Smm9hq28MRkUtvC9kVgdlK 78pizv8PwlAc1n8wOMmdthMze20SnELWUwJYK7oplL/fC37j4xJrSVPxy/Goqp34SAa0 8JSSNEiuMAfsi2KjEVqYFSpR4skvBmjjjC7Eg0fEilHnRIEjKD+d2db/gA64VYR17S+H tfzh7uR7k6+XbPdjVGfvdRrPf+bvpi4Op0WoKn6u6zU6oZXK3Nh6SH25Vee3Lt7pz5l8 buQw==; 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=gmail.com; s=20251104; t=1779462180; x=1780066980; darn=lists.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=oBIG/j2Um4WYIwo+rkMHRK0Ea2c5nB8r1iYZs0YbKeI=; b=cfvTzQlVEH1PadxhCe7uj+ZLeUiFXNB7dE3aoqxlL9bQHZ9YjAvUJqernFfV9rFzko k2ZNz8TL9t3fq9gumuFNTcgqRJ7pffiPgucUJm4xMz9ocgKXmkWTfVDqjdFb4BLrFbCq rnMxfnnCE8iwyUGdvth9E1LFa4Jy6KjcHMCqKORBKF3VfTNbvzq5HWbpFon0zgEeahk/ yWL74w74G+sJ4xyjfx694Kq1Y+j8+ExI1SV9zMd5Zuzq3Rs6AvsvU+Li62dqfdurFsOG mTEWs/yIrZsooR3+w+0BNcTuAd2rH5sCzmoTXcMePrJWLUSQ9Y7t9eVzGy0nGsXgcJkM hZwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779462180; x=1780066980; 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=oBIG/j2Um4WYIwo+rkMHRK0Ea2c5nB8r1iYZs0YbKeI=; b=bFFRAMqyYeQ3rQbpK2BcRKXUrquMEKg59tV0cviOLHLHJo+X6VJwpDVSRc3Tb3I4HJ FmjeKQviRt5w9oB+BzLc1/hwjVmbsRJ3IFzePhgXpQ3zSU8321dqNlySMR/UWwX+ZJbP dEp4FpRXWHdymkDRn6a5Ls0Uk5AZpKmvBH9qlrOki4Cvf9yAT5jod4WIUb0zdw8C902x MToaTOxSxLFdGLiSfkBCdKpQMgMOUj4fl4ocCemqEhYwoeCcqquW2X3rczjJWxqcZ0tK pT+LJquHXpFPdq6qXe19AGw+7Ue+qJTAVN6kg7boIQrHdwSfVChAMjKtGctYLI0sRRYW k6VA== X-Forwarded-Encrypted: i=1; AFNElJ/IvjcEs2xqdumHEqnlzmprsGoP+NpJNVK2haDVyF2P0T09Ji1eVN/eHmEiwKPni/n7Cya90IdAdI6avZO3@lists.postgresql.org X-Gm-Message-State: AOJu0YyJMuYqKvKTHXPmJTT0m4kPj18PY0pTOxcdxf9ViE2/DVV94Ar/ nPkpKlFVkfJSPcHO+Ocw507mlPOiKRJREOs7HT0kOCGFhZBqKQnHvgtRHBkLh2AMseKc3vhWuGC cmeiHS4Xr916x7kBUYBgEZ0Yq+jq7lsk= X-Gm-Gg: Acq92OFzGJgPNAsPsy6tvWc6p+AyhQIEFbcT5MAiQmJjuLt8PZDw69SLswjXfTaVEes 2OSM5N7uyx5msgT2kUjlpE1fnknrDv6XthXMjGrzhoSzPKucI1hvUAeDYXMa7LMfzEKG1MaiV/X TJA9xvDY6i7FMJEJ7t6xNKo44JmRg0rIpu1TInV7sqX2RQjOT7kEDKzub9DvX/2rD/K834ESCpi btKEpzMp4YP+4PwpJ+18hTgcZgoxiB7BQTje3/CMpZcFOVNJqCOXUxdbziDW64shEZRCdDB3PbI NTHnrPFzK/OXQLltCGB8fPYVhBluPaCHzJDDV7UJYVEiCyZN63UX X-Received: by 2002:a17:90b:490e:b0:367:b819:2214 with SMTP id 98e67ed59e1d1-36a6765b57emr2898680a91.13.1779462179602; Fri, 22 May 2026 08:02:59 -0700 (PDT) MIME-Version: 1.0 References: <24bfd6b7-d566-490c-812f-c61c9eb2ef69@uni-muenster.de> <7299e1c3-9cf5-4e72-94ae-1771d88fb0a3@proxel.se> In-Reply-To: From: Fujii Masao Date: Sat, 23 May 2026 00:02:47 +0900 X-Gm-Features: AVHnY4I3Ws7WllBDXxQLhaQZP6u-BCdvEaO32OsjA0GKs932zbQ0bcbQYuEbaso Message-ID: Subject: Re: Prevent setting NO INHERIT on partitioned not-null constraints To: Andreas Karlsson Cc: Jim Jones , PostgreSQL Hackers 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 On Fri, May 22, 2026 at 5:10=E2=80=AFPM Andreas Karlsson wrote: > > On 5/22/26 3:10 AM, Fujii Masao wrote: > > This should be backpatched to v18, where ALTER TABLE ... ALTER > > CONSTRAINT ... [NO] INHERIT > > was added. Right? > Yes, as this is a bug I think it should be backpatched to 18. I've pushed the patch. Thanks! Regards, --=20 Fujii Masao