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 1uXjAS-00DepW-1u for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 16:21:40 +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 1uXjAQ-001xpH-61 for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 16:21:38 +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 1uXjAP-001xp4-R9 for pgsql-hackers@lists.postgresql.org; Fri, 04 Jul 2025 16:21:38 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uXjAN-005ZSd-36 for pgsql-hackers@postgresql.org; Fri, 04 Jul 2025 16:21:37 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfout.phl.internal (Postfix) with ESMTP id F3311EC0183; Fri, 4 Jul 2025 12:21:34 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-08.internal (MEProxy); Fri, 04 Jul 2025 12:21:35 -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=1751646094; x=1751732494; bh=9 gaBqvJRnZ0TgWiFr7IOLWNs2thBAbGE+ltcJDXl4Dw=; b=AGcswiCIoq1cQt5EH bRl9wMiiqAtR2IB+kwd6GDTz4T9LFtOn0LEfeZjTRc2/BBQcTREsg6ExqdI3dbRs LyzN9+IfkP0y+gy+3LKzgDdcYot3/xfG+4M7j/52wktngRfpLDJ7Qj5bVXFQI0WQ NnRKvAx4gW80Ty+tzHW3knfa/eXZvezUzxWqil/8aYkc77J5TL/bs6pJNruXzfun CrEZEhm9Jfcm661dHzeo8wQwZi3gC/rj/SY11QScSj48Rl8L/QCVU/1r+DS776f5 X8eyo6EHDNEKnxVy51V12a8Ab9RlG7nwrw7+XmerTyf3/0TSTVjcLKoab8zbWatH Tcu6A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddvfeeivdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqeenuc ggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeffgfdu fffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghr rhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspghrtghpthhtohepledpmhhouggvpe hsmhhtphhouhhtpdhrtghpthhtohepthhushhhrghrrdgrhhhujhgrsegvnhhtvghrphhr ihhsvggusgdrtghomhdprhgtphhtthhopehmihgthhgrvghlrdhprghquhhivghrsehgmh grihhlrdgtohhmpdhrtghpthhtohepthhhvgdrrghprggrnhesghhmrghilhdrtghomhdp rhgtphhtthhopehlrghnghhothgvpggrmhhithgpfheksehlrggsrdhnthhtrdgtohdrjh hppdhrtghpthhtoheprhhmtheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhr tghpthhtohepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidprhgtphhtthhopehpgh hsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopeht ghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepphhrhiiisgihsehtvghlsh grshhofhhtrdgtohhm X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 4 Jul 2025 12:21:33 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1751646091; bh=0aqnPsyARzEMYg/rGyhxW29riXL84QoLukln6mI1r2A=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=d03EIvzaMzF5ZtawIOToEhthDGJ9Gwoek4++s1KGgxR6qWUedMPwc+BpSX+xDReRk IqPB6AriOE5fL/AJ7wck3Ift60PesLjYQOSNHUymwVXU+hKufcI2RvNk7jPJQb6czq b3R0WhtinAE8RYcxC1jUJWEpu9mdLevPBQyr1Ex/p8O1jYmzTfhkRdG8VhkrwzPLzb uEukbhYMv57kTdRKP0WD3CiPvcKKpNnfJWdhikJIPzXSmWDBLRK7Mu1zbP3cNgSpKK M6RGH8h5JtV2A6QalD3vYqJa7nLXJkxG2FB/5EpFMqSBd00CVdu3R1w2kNFyjXpKG/ +nScIgniy6DZw== Received: by schmee.kurilemu.local (Postfix, from userid 1000) id 3FF4690; Fri, 4 Jul 2025 18:21:31 +0200 (CEST) Date: Fri, 4 Jul 2025 18:21:31 +0200 From: Alvaro Herrera To: Tom Lane Cc: Justin Pryzby , Michael Paquier , Ali Akbar , Michael Paquier , Amit Langote , 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: <202507041621.fs23x5filgko@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4084943.1751573241@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Jul-03, Tom Lane wrote: > Alvaro Herrera writes: > > On 2025-Jul-03, Justin Pryzby wrote: > >>> Actually I think we should consider backporting to all live versions > > >> If you don't backpatch it, there's no point. > > > Oh yeah, you're absolutely right. > > No, it'd still be useful for handling upgrades from $busted_version > to current. But it seems also useful in the back branches, so > +1 for back-patch. Pushed to all branches. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "El miedo atento y previsor es la madre de la seguridad" (E. Burke)