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 1uXxwD-00GkbH-LJ for pgsql-hackers@arkaria.postgresql.org; Sat, 05 Jul 2025 08:07:57 +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 1uXxwA-003k9u-Ik for pgsql-hackers@arkaria.postgresql.org; Sat, 05 Jul 2025 08:07:55 +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.94.2) (envelope-from ) id 1uXxw9-003k9a-RV for pgsql-hackers@lists.postgresql.org; Sat, 05 Jul 2025 08:07:54 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uXxw8-005gHM-0k for pgsql-hackers@postgresql.org; Sat, 05 Jul 2025 08:07:53 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfhigh.phl.internal (Postfix) with ESMTP id 0A33B14001F7; Sat, 5 Jul 2025 04:07:51 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-10.internal (MEProxy); Sat, 05 Jul 2025 04:07:51 -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=1751702871; x=1751789271; bh=/ tIiaaCuixWnNSwJHCkRJQIVdKcXVX5PDAmrLXL8zJE=; b=Mvv0CKvVfBAmV+ekJ 28IQkszLpqsKwYLhC/zyT3qf5F8Iw8I7ie+Ny1BGYGEKgFmXGQAwcFOOvI6VW/dH zRkffzb4VWYZJURSPFtM0hqKxzv34TPSWOq4SGKcGgS/LSwPwZ96onUxzYu1LV3F t3SSLKdwi4jZyiF14gArRWWnNMjf00U8XtoY4yUrZmHHFHSyyoVrPtKugglPiigN L7ut1pGXN9jYKbhDHEpHIkOFIOXna1/4PDXgyKU3S+o3yztbMHoLPWiOuFw6U8VM OHqDD6p+YnTf/ARmOI6gnFZ9+Qama9RCsRgG91R4mf3Bjc7eGYwrMcP/xEZecZAF a5iRA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddvheehvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqeenuc ggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeffgfdu fffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghr rhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspghrtghpthhtohepkedpmhhouggvpe hsmhhtphhouhhtpdhrtghpthhtohepthhushhhrghrrdgrhhhujhgrsegvnhhtvghrphhr ihhsvggusgdrtghomhdprhgtphhtthhopehmihgthhgrvghlrdhprghquhhivghrsehgmh grihhlrdgtohhmpdhrtghpthhtohepthhhvgdrrghprggrnhesghhmrghilhdrtghomhdp rhgtphhtthhopehrmhhtsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghdprhgtph htthhopehmihgthhgrvghlsehprghquhhivghrrdighiiipdhrtghpthhtohepphhgshhq lhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepthhglh esshhsshdrphhghhdrphgrrdhushdprhgtphhtthhopehprhihiigshiesthgvlhhsrghs ohhfthdrtghomh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 5 Jul 2025 04:07:49 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1751702866; bh=boXqpeEaxmsShmuIFoYF0VYwxOXuQ9FCYDQkcZSv4Dc=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=FzmgzeB7n98QPuZfS4rVRN6KuOsXe/CLAPOKWzYoUJgwBoHf3hoQtz6fjolU4RvDI lDggI7eBqAznVGzDjhbXhJUSUBFvK5XBiOtthIUHjtwwnTqq4A4YDkI9qemHMAtzJf f5H/++MasiB44gKq7P86iUjJ4OwjjlXRYaLNQbxajuYkdFyb0x32/wYTQhb9+wznx9 iU47FN7U6ebPoNw+sOqMlGlS+r48V/izUcQY5mRjxOtY5JBBtqeealyCVcjWQjmaO6 UZr1JOV5j1iOfIXXSdpI9J5cnG86yanHTOJsSDZ1rGUqEpF9Wofva5O4WQGz+LxUEP 9fhg7kUr+7XgQ== Received: by schmee.kurilemu.local (Postfix, from userid 1000) id 30E4290; Sat, 5 Jul 2025 10:07:46 +0200 (CEST) Date: Sat, 5 Jul 2025 10:07:46 +0200 From: Alvaro Herrera To: Tom Lane Cc: Justin Pryzby , Michael Paquier , Ali Akbar , Michael Paquier , tushar , pgsql-hackers@postgresql.org, rmt@lists.postgresql.org Subject: Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL Message-ID: <202507050807.vqslmohdgjga@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <264849.1751650631@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Jul-04, Tom Lane wrote: > Alvaro Herrera writes: > > On 2025-Jul-04, Alvaro Herrera wrote: > >> Hmm, crake doesn't like the fact that there's no regnamespace in 9.4. > >> Apparently in version 13 we claim to support back to 9.0. I only tried > >> with an old server version 12. Should be an easy fix ... > > > It goes like this. It's tested with 9.2 only though, as 9.1 doesn't > > compile from Git (lack of Flex) and I didn't want to try a tarball. > > Query works, or at least throws no error, back to 8.4 (the oldest I > have at hand). Thanks for checking! Pushed late yesterday, crake is happy now. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)