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.94.2) (envelope-from ) id 1u1sVz-009eBv-E1 for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Apr 2025 19:52:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u1sVx-003M2K-PO for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Apr 2025 19:52:14 +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.94.2) (envelope-from ) id 1u1sVx-003M1i-EI for pgsql-hackers@lists.postgresql.org; Mon, 07 Apr 2025 19:52:13 +0000 Received: from fout-a5-smtp.messagingengine.com ([103.168.172.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u1sVv-003yzm-0i for pgsql-hackers@postgresql.org; Mon, 07 Apr 2025 19:52:13 +0000 Received: from phl-compute-09.internal (phl-compute-09.phl.internal [10.202.2.49]) by mailfout.phl.internal (Postfix) with ESMTP id D03221380185; Mon, 7 Apr 2025 15:52:09 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-09.internal (MEProxy); Mon, 07 Apr 2025 15:52:09 -0400 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=fm2; t=1744055529; x=1744141929; bh=V /hjim3SP0gWNljCW+yux2eqWFKzb1S0Dh6hoD3C1as=; b=E8Q+krMzor46iqRm/ q+dw/PTeVRn3ig/jpRgSse+S/B7yl6SZTOwpSj4W4d9Mmve15K1wJBrtGgfOZ1Ch 0XbI+X1XG7bQSpofnm1kTXkL7yRLMaAQdp0qYUBqn07yeGtXfwYIigdNQR8PJHBx 9dYGZiPmQRcQ1gOzQtTr+HQRxNa5qcUWZ1G7MnrEfpU3ksCtxRHMcLdtORBC0xzY cPUTauD00rBm9VGsl694cID0pHATA1ULKhRt73sD0UysYlLfiFp2dGElpzECX1cL GEjvBVlEeKeVRFHCPdM+c8KDIChY7L7YoeNlQ8zxv6aPzkGu89UeDvTDzpZK2EZk 8KrtQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvtddutdekucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddt jeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepkedthfekveduuefgueel teekgfejgeekueduudeuveeuvddufffggfetiefhvdefnecuffhomhgrihhnpehpohhsth hgrhgvshhqlhdrohhrghdpvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluhhsthgv rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrghdpnhgspghrtghpthhtohephedpmhhouggvpehsmhhtphho uhhtpdhrtghpthhtoheprghnughrvghssegrnhgrrhgriigvlhdruggvpdhrtghpthhtoh epjhhirghnrdhunhhivhgvrhhsrghlihhthiesghhmrghilhdrtghomhdprhgtphhtthho pehruhhshhgrsghhrdhlrghthhhirgesghhmrghilhdrtghomhdprhgtphhtthhopehpgh hsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopeht ghhlsehsshhsrdhpghhhrdhprgdruhhs X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 7 Apr 2025 15:52:09 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1744055526; bh=D7zc1+uIK1ULiWxHvaqj657QieKdx5hvIpDvaSCd0C0=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=mSz9xxVLXP447pNmDUzeoZUIe6Z2fZx4Qa76D3J43FESddbSWoQcP4putADs8ggBn V7JOvTU8TdVY7zXF1di9xSGiJ7ZlJo0kt7K5tHx5LTRsRj5XGh6/2uz9mLK5RhXnfc /UKN5Ec+QYmWbdoKaKzrlb2Yw7tqlqrxuKsVkAw9lyCTQnerHphXSsgKVwG5k4B/FJ OK0l83biuN871oy7Ud8qtgnL22Y5bcmFN6fqqDRYa5DIZjsRFHjklrTCuTG2S5v6Mx MF49WvH7Zm8g3yvXJaiLQxuuwkkqqPUUlyV5BgzwUTVm8gqVEdH/T5QyD8sviTdE2f gV9dUghavDHNw== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 073278F; Mon, 7 Apr 2025 21:52:06 +0200 (CEST) Date: Mon, 7 Apr 2025 21:52:06 +0200 From: Alvaro Herrera To: Tom Lane , Andres Freund Cc: jian he , Rushabh Lathia , PostgreSQL Hackers Subject: Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Message-ID: <202504071952.go6yqgqosl7o@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3603704.1744050641@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Apr-07, Tom Lane wrote: > Alvaro Herrera writes: > > I have pushed this after some small additional changes. > > Looks like some of the test cases have issues with locale-dependent > ordering. > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jay&dt=2025-04-07%2017%3A56%3A49 On 2025-Apr-07, Andres Freund wrote: > Looks like the test results aren't quite stable across collations: > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jay&dt=2025-04-07%2017%3A56%3A49 > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hippopotamus&dt=2025-04-07%2018%3A28%3A12 Should be fixed now, thanks. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/