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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tM2nX-001GzF-V7
	for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Dec 2024 10:21:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tM2nV-004loR-Bl
	for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Dec 2024 10:21:26 +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 <alvherre@alvh.no-ip.org>)
	id 1tM2nU-004lo6-Mb
	for pgsql-hackers@lists.postgresql.org; Fri, 13 Dec 2024 10:21:26 +0000
Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1tM2nT-002bG6-1v
	for pgsql-hackers@postgresql.org; Fri, 13 Dec 2024 10:21:24 +0000
Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44])
	by mailfhigh.stl.internal (Postfix) with ESMTP id 7D49A2540111;
	Fri, 13 Dec 2024 05:21:21 -0500 (EST)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-04.internal (MEProxy); Fri, 13 Dec 2024 05:21:21 -0500
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=1734085281; x=1734171681; bh=g
	Mv8jovYTp4j8NwJjWYL4fj3eAcp061TT2PE8OGpSMI=; b=ftnVadIidUWnM4wSz
	eaITgr2lnJpiAPxPUtXEXO+4qug8YdhrC7PD9+DHQbuCRzCy+sxPTt1LR7ML773M
	SVvLoHNN6zt+g981f4jr7dg4zwnkbI6NShO6GEKZ/qvzEyJXQIhU5+DLZ/GBwSDe
	SOtX4ftl33AjTkv9WHVlHIVeST5YxDNsSlSNZ1rb6kcOPlWkrbbQbr9lMHA3AtoE
	OnjOmh8ydAcT1A8AEUSzbKzJUZQtvPNQOh8tGltwHGFEAy+RYwfIxTlXz4kLy9Ck
	eIq5BY0OQXlhT58MgnghF52LPx6qpa/BDBkwyxkwwdNrX9JdwqCB9tZaM/nwnqYO
	UbzpA==
X-ME-Sender: <xms:oApcZxy-6ac9zMeYXf50PdgSAhwCZufEnnncgQ0kNKIzB0ioGWw5FA>
    <xme:oApcZxQ2GVETXNnV0Y9SBHxEiK-Q93AWTstH_c3hs01ynoJhn0lyNfDP1dVyQpOYP
    8SFrl5oz30SW__Z1A>
X-ME-Received: <xmr:oApcZ7VWIlhKTVxteu0Qo-DGOPlQSq5_24Kg5atIIK4SAEvXHV6_cvaldgAhHHEIdgxe2MPm-V0gmQJui1hfBzfn6Ve-f1kcedSbQz54K-VkMU9j2k8dl5zJCVEOYpAM5qrw>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkeejgdduhecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr
    tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuf
    fkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgr
    uceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvg
    hrnhepvddufedtgfevvdfgffeghfevuddvgefhudegudffhfegudduteettdfhvdegffeh
    necuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhdpthifihhtthgvrhdrtg
    homhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegr
    lhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgpdhnsggprhgtphhtthhopedvpd
    hmohguvgepshhmthhpohhuthdprhgtphhtthhopegrshhhuhhtohhshhdrsggrphgrthdr
    ohhsshesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhsse
    hpohhsthhgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:oApcZzj1RIo6KQu1C0FkxjRpJ8W8ps9TEL09uj7tNSQOEmlBjclbgA>
    <xmx:oApcZzB9kK8V2yeLsScy_hpF7lwUKOHUHwBOR-jr5vZwVyg8TIaOqQ>
    <xmx:oApcZ8IJJRrK2NIaCM57O6BgBVtJDlh5rCo_Grai6KMxobjTqDAX1g>
    <xmx:oApcZyAF_xWI5F3iJQ-8PXO2UYWpREfA9GdWR6sr1-VmrviXG5votg>
    <xmx:oQpcZ2MAHASR_Aptm2E7mqqhRuTmvzdSYgzQhSSr0L0VnBpF_iakMm8U>
Feedback-ID: ia2694551:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri,
 13 Dec 2024 05:21:20 -0500 (EST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org;
	s=schmee; t=1734085278;
	bh=ETondgUXZ8pjVPasqO2NttF6/SGMj5jjyCRFKwqYC4c=;
	h=Date:From:To:Cc:Subject:In-Reply-To:From;
	b=Fgnb2CgH3j/ViOwCP+6KvgfyIoGagBwn3dlgNGsLf8qSnuoNZqU/AMB5ESlIKO7wb
	 Jv1gMgF9WDoPdJSr0uOxpEQj2x4S/qEcQWgS8mjsp2mBkM3R4BdndKLsLaTxczeKfZ
	 +zHVCaex4oXYrZLXlLdQBY5wOXBaKzvRFr11dnZnEsBxNuh0LnTvPp2vltawL6Xuv/
	 DW+jtOzxFL5DXMRpktUDFf/NkDMC0zN01H93ulpzVwsVrfkBwYmgR71X4gMweOSxBG
	 d9mzO46slLmkxLZCM2KLDpPMWbEK6b6Bo+4mi4MjY+w6y5tEQU7WwodEpUbekOQUvg
	 gV3D8mzXgB6Bg==
Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000)
	id 455239E; Fri, 13 Dec 2024 11:21:18 +0100 (CET)
Date: Fri, 13 Dec 2024 11:21:18 +0100
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Difference in dump from original and restored database due to
 NOT NULL constraints on children
Message-ID: <202412131021.kgqz4tljxc4y@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAExHW5sKiWzNAWrrSBFR1NFrQMPmcv=QqTKVCBXDyAYimMdE7g@mail.gmail.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/202412131021.kgqz4tljxc4y%40alvherre.pgsql>
Precedence: bulk

On 2024-Dec-12, Ashutosh Bapat wrote:

> Attached updated patch. Once we commit this patch, I will be able to
> proceed with the dump/restore test at [1].

Thanks, I have pushed it.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"You don't solve a bad join with SELECT DISTINCT" #CupsOfFail
https://twitter.com/connor_mc_d/status/1431240081726115845