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 1uXjXk-00Diyq-Ux for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 16:45:44 +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 1uXjXi-0026Qn-QB for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 16:45:43 +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 1uXjXi-0026QZ-DY for pgsql-hackers@lists.postgresql.org; Fri, 04 Jul 2025 16:45:43 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uXjXh-005ZeE-0m for pgsql-hackers@postgresql.org; Fri, 04 Jul 2025 16:45:42 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id AB15EEC0193; Fri, 4 Jul 2025 12:45:40 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Fri, 04 Jul 2025 12:45:40 -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=1751647540; x=1751733940; bh=1 auveIvJiYid9WgtxteJzl1L+CCaz8H06HfZdoicGKo=; b=cTDNXzHgH6Xl3lb+5 84fSYjQUz3q0t4442ee1EVlBFfdZR0Q8FqUhIfYJJ8skuxMcuYbnGBDE8ffLAQrt MC71bpwSi9cc5/L0oR+OhKFIQJijbWBW3mABzYo7PnaeRoCoKa7V6esMgFPEwaxJ YVUTXNk2UaCbSI/FV+jTgccgEmxGDB+rNtwTQlAf4/zrt9YlV0W2dMFC3zI/6Azz ELsgjlhpvlVNAhld2oBPRy5fQof/zpvx9eu9tMKw43xQmbdaVeyUEg5eFK7obyJh 8P7R7nuFKKIpACAJQbytZxkvvKrEqWiEjkfREJ1IGiZVb34X/8TsG05xLpGGpowy Hwx1w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddvfeeijecutefuodetggdotefrod 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; Fri, 4 Jul 2025 12:45:39 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1751647538; bh=HXjRuoka8bMOTZchDOnLD8S7MWAj7xKNbHl2a3Wd74k=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=f6+ixyxtFCp6jXFlVy38JLICFh0D1RWWItcTaJmr1v7i26Y4NLezgRiofgUuLjHdA hfqhqcAfIiNZpreHEfE/b7nn7zGa7DVo+uNiIZTgCgvDn+bdeihGfaQNoCgDiNbJhZ sNIDRxpxVDpxyU2xv2cno+gcIqkAp9Q3RsZEflwclib7+LN8NRPLeKhQp6M0T+Irzv aTAta/Fl2U9y9aSrJNSlKQCcMlUm2AOs4bGFzmf1JzlVJygdC2smrdwNBjiaIPjN// kXyVvS2RuFI+V897rQliiBtXWF9KU46/+LRhD7+uj3FOiS02I6wwFMvYeDOzkfem/b 21lX9aLav0XXA== Received: by schmee.kurilemu.local (Postfix, from userid 1000) id B9B9890; Fri, 4 Jul 2025 18:45:38 +0200 (CEST) Date: Fri, 4 Jul 2025 18:45:38 +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: <202507041645.afjl5rssvrgu@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202507041621.fs23x5filgko@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 ... -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/