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 1vTb7W-005YG5-0s for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Dec 2025 07:29:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTb7V-002nG0-0h for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Dec 2025 07:29:49 +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 1vTb7U-002nF6-33 for pgsql-bugs@lists.postgresql.org; Thu, 11 Dec 2025 07:29:49 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTb7T-0006ZT-3B for pgsql-bugs@lists.postgresql.org; Thu, 11 Dec 2025 07:29:48 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id 259F214001C8; Thu, 11 Dec 2025 02:29:47 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Thu, 11 Dec 2025 02:29:47 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm3; t=1765438187; x= 1765524587; bh=S51u0JmbB4QiFl57Pwgqe05AmNEULU+Hpi5mLLJU7Ys=; b=F 8dyqKiGivCoI8p2xRqIJqrPC4m1MQxp4Him123T+n+zAd9brL7d1Km5N5aIiIOe/ /o9ho5f2a6ayhoBSO32KYOPZ4CO3lZ9q4PBBp5YXFm4ul0BrfksDB72uwxo//u1J dD0/cEWrLa9Czw7VSJTxstSmY3z0Tl3C3ZGI6ec6dEqZgBmSvJ4lYS1sgRch+6SR FAbauZBzDDXjzPKGPetDudiWda8Cgez4qHBFWMjeNiyPTUVO7ZpkH2E8K58dawby tRNtYUnsXb/lxioHwm5J4rhH1uv4FK0M72uQ6zmKolnvjvk+QA+gxQ2qWaUzUMrY myme2OtITmTj6PSCr59SA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1765438187; x=1765524587; bh=S 51u0JmbB4QiFl57Pwgqe05AmNEULU+Hpi5mLLJU7Ys=; b=ZQtcJGgjapdKXQvyl lEb7KiCnokfqbivaCxs8fhZCw4nJEtjknIHOhcnJ4TfI/28v2Vbg11kZcB3srrOq vaCdapc4a5tJpDFgRL/krTzhhc5wYFxTMTDIZZ0ZFst+isC35EytquH/uCzrCYOh S3W0lxuUttluFrsamAPnPYUPryvcK5x29Q9c4HcS6SJTJ5t6fRbr2JJdS0h6+iUK VGnmSDs3LNTFxBudRtery9EI2ciNQjDHKDOydEJxJ/b/vTmYiYDnod44G+wW2TQd Bk9zxO0l8aye7n9hxwtcfx+fCyB9OBaxlEzjrlfVvh9V+LTxmnlUKAjcQgFAuDZL PnJxQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvgeejudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnheptddvkeehgffhueffledtteegieffhfetieetfedtvdfffefhgeegkeeh fefgjefhnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhdpphhoshhtgh hrrdgvshenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohepfedpmh houggvpehsmhhtphhouhhtpdhrtghpthhtohepmhhsughntghhihhnrgesudeifedrtgho mhdprhgtphhtthhopehsrhhinhgrthhhvddufeefsehgmhgrihhlrdgtohhmpdhrtghpth htohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 11 Dec 2025 02:29:46 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1765438185; bh=+StCd54tVGqQh5Bb/Z6ybTItcNbXqpAA1fvA0XBgIRM=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=tq/Gqj/T/oCjQNEVXuZhjippJCJf++qsnyGvI20S9fi8IMcNGhV1rN+CPNvkxaXkR qW7WjJulV/oS+AnLOyNCcZZJEc6z2TozcshY33E/LRXyCbKzFdukZvxD37hacScdzg UFkD/CNTKuSBmA7gA3B9fBtS8Ny5+IwGGNbRA1e8JBGxM2xggfC8O16c7C21YfUYrr r8j02TNW+M5hexV40VXF+EjHX6XZDxNjfbo+s5dIiL/DzJw9xkt3My8Pl2CzTbRevM h6NSY1g6HaHB6K25H/IGTM1Q/sJhNFd6fGSOPHS2gnMYxLouOoBQIyS6qzIzfHP//h MKCYLWgGDSlLg== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 98FC578; Thu, 11 Dec 2025 08:29:45 +0100 (CET) Date: Thu, 11 Dec 2025 08:29:45 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Srinath Reddy Sadipiralla Cc: msdnchina@163.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Message-ID: <202512110728.qdjdihtm7pmg@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Dec-10, Srinath Reddy Sadipiralla wrote: > ah... just after a quick code lookup, remembered that > "not null" is treated as a column property, which is a > flag in pg_attribute catalog table named as "attnotnull", This is no longer true in 18. https://www.enterprisedb.com/blog/changes-not-null-postgres-18 -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Fundamental layering violations tend to bite you on tender parts of your anatomy." (Tom Lane) https://postgr.es/m/2818249.1748706121@sss.pgh.pa.us