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 1vU4ei-00GRBA-1g for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Dec 2025 15:02: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 1vU4eh-008MNj-0l for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Dec 2025 15:02: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 1vU4eg-008MNa-1G for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 15:02:03 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vU4ec-000MGE-1O for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 15:02:02 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfhigh.phl.internal (Postfix) with ESMTP id D61B9140009C; Fri, 12 Dec 2025 10:01:55 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Fri, 12 Dec 2025 10:01:55 -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=1765551715; x= 1765638115; bh=fbuZOrJpROdKknp6GspPEzzE/N09Hevf+MANwJwP9oU=; b=n x6Dci1Wz3DYOAPVb3LFp3by56UgCqWrpckm5YvxfyZNrb0m1Na36McNLlhKC9ed7 uYIT7k2q/x9Vgkh//w2F7fJjYz6DI4z2+75+J4ffbAH8blY51bPj920xxGfTXowS vjbhZhAcJ0qaEaKvgZqEuVmJ+sDYenR64meDaEIx3eMU40yEX2+NylKNwDHvtx9K wqfdIJCiQLCk3CSomBpnPQxfodmwjM1Fj3bJniDI/RcC9I2DxYJzhHCFlpmxPYvH AgpD8LL0OnWgILRylKhLLtzmRzVBT/8WIZcLHtzmwGFLLf6WzKgrE2Rl3LDIpFbG SlcfcL/zVwxWmvJphj9HQ== 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=1765551715; x=1765638115; bh=f buZOrJpROdKknp6GspPEzzE/N09Hevf+MANwJwP9oU=; b=G66QO3mgNiVtj2bNM XlBlbIpJHvf/NE/iJn1bAXSjS6NxKSywCkSejwEgFQnme8gB+BSesXOihN8uRSM2 kGnEFyl1xCN9OviNADyqhuYbEC5/4LuvOz5qIzPrjZx4pNFehkWmyDgdXcPX3D9N rtZbjK6uB436PG6fSJRXdenSyCNQZQUoUZsXruLSeNOel6w92sRNBZB5G2dZlOJq Eerp9u3ohaB8dOTryKkrVBlYEWdytEcyWFpdK4+X3SVL+87pclk1+s5UC4G1rEUK qMEJ1P4hHW9WHOl6GyRdQrx6jR37Bd03h2sssOp4FTvbtCHz8idy2WzogGLIgZpx Pg1Sw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvkeeglecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepfeegveekteejhfeukefghfffkeeihfeuleejieffteettedtffekkeel jeejhfdunecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghdpvghnthgvrhhprh hishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtth hopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehmshgunhgthhhinhgrsedu ieefrdgtohhmpdhrtghpthhtohepshhrihhnrghthhdvudeffeesghhmrghilhdrtghomh dprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhl rdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 12 Dec 2025 10:01:55 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1765551713; bh=TXw9xHq9FhiI/PhU0T0GN2G78SwVJiT4OpvQQ66lYWI=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=SkvEI7BO5XAi6c/GjyThadr+Dt4H0zmrW8tFiEbQ3Rp3eQmckjQQvT9K/HKkUugaB QtAQW1wK79m8RFFJxj39bSge24IpZcr4q8LWr+5nO79KKlOnDAlGTi60q6juArrSMB /qjRdfZqLdxL5roaWUflWCmO/geqhdsBS9gVxMcakMHzR4iNeE0YgdNnf6cWhw2RFl OhGf/K1N8pjCaUXgINGpayg+hZ0hK4cnk5zI+izLQkzqRNcP32Y1wOCVDGWQfmf7vm VG56Xl9wjuwSC+pI6uDMK2QznWXk3QD3863YGHKERhvun6s8M5UfqLoOU7tCir7im/ SSDmuVRTcC3nQ== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 4EBA378; Fri, 12 Dec 2025 16:01:53 +0100 (CET) Date: Fri, 12 Dec 2025 16:01:53 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: yanliang lei Cc: Srinath Reddy Sadipiralla , pgsql-bugs@lists.postgresql.org Subject: Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. Message-ID: <202512121501.pmpgh7tiz53e@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1259da72.9641.19b12163641.Coremail.msdnchina@163.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Dec-12, yanliang lei wrote: > Thanks for replying . > > in the postgresql 18 ，not null has “Constraint Name”，and this is a PostgreSQL 18 New Feature. > > so , i think that: this problem(BUG #19351) is a bug. Did you read my other reply? https://www.postgresql.org/message-id/202512110716.jpbcheffhdow%40alvherre.pgsql -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Right now the sectors on the hard disk run clockwise, but I heard a rumor that you can squeeze 0.2% more throughput by running them counterclockwise. It's worth the effort. Recommended." (Gerry Pourwelle)