Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 10 Feb 2026 09:37:09 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, huseyin.d3r@gmail.com,
	pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19393: pg_upgrade fails with duplicate key violation when
 CHECK constraint named *_not_null exists
Message-ID: <aYp9tTWjUqS1ffAd@paquier.xyz>
References: <19393-6a82427485a744cf@postgresql.org>
 <2b3a2cd5f9b6e82fba6ac45b413291b01dd252ea.camel@cybertec.at>
 <61c535617992fff830961ecc09a9c20096bc1f36.camel@cybertec.at>
 <CAFiTN-vPxycE0YeNNTx6_nnD4cGHMP=WA=Yada+Ons=VTGPsdg@mail.gmail.com>
 <99c37bcd620778c743a413dc9a1dce53ae9f4c38.camel@cybertec.at>
 <CAFiTN-uF8gF2cvHC_YbDMtBVeOWWtJc3LvCToy2PvLy9LJwC3g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="8/jmVWbv0XRHUVwL"
Content-Disposition: inline
In-Reply-To: <CAFiTN-uF8gF2cvHC_YbDMtBVeOWWtJc3LvCToy2PvLy9LJwC3g@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/aYp9tTWjUqS1ffAd%40paquier.xyz>
Precedence: bulk


--8/jmVWbv0XRHUVwL
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Fri, Feb 06, 2026 at 04:16:08PM +0530, Dilip Kumar wrote:
> Right I see, I was talking about the similar case something like[1]
> but I see it already handles the conflict and generates a conflicting
> name if a constraint with the name already exists.  So we are good,
> thanks.

I had this patch marked on my tablets for a lookup, with the hope that
it would have been possible to get something done for this week's
release, unfortunately I got drifted away and lacked time.  I'll look
into what you have here.
--
Michael

--8/jmVWbv0XRHUVwL
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmmKfbUACgkQnvQgOdby
QH2J3g//bfMyD00SPDL6di17UTCBwEjSFU+JAfONHLgLDuaVcH75IQ6aUdSxh2/Q
VHI2+kSJLccDb39Snmow78isf9AC4cObq4T9D5NW7Nt3FPnhB5tk33zvEjdh+7sf
w9bc3S0uWwB+Dnuxydhlci/SU4Q5pMreqSXA7BwfQMtGHm8zS6fEa6W8byB4+8zi
JbsoYZODRMWK1XBMiAUvbnQ9NXA/o//cmydlPnAOI6fbqTcv/x3az0wKkRKQNwIW
yvP8hqSZy27BGAMPaItO/3FOZIrnfOCV+Q1mCbvJMF3Spknzl0yY354tws5A3Rul
WMbMWdQ/88pwiKL3driHi6Z2dttzIUrMAUuRqn3aozOBnx8VZPdDLe/YcXdobc5l
tIUBFxD8ouxBN+KLO03h48UPmF1wt7EAFW+mCnMjAIjPKiQh5M0wso3tn4H99TgL
6R5gH5WWGkaRoSdBYpjfi6SoIMndUVm+9iAlLLTba9BAV4dF9X8CvllGTjcdIIW1
9RcpQnWZmA/6O9JrNwQlpFietakTqR5JXPxm4t2SDDS21Yw0I44GVVw0Jzr1GKBp
rMBPllSSpBYiWLzKI0hCLlGdnUYS1VfdeJZpcXbaCsJD01BjVQaOGKVnVXM5+LH4
z058FLb2bdM8THb4Li33FJJxCEnX0HLu4QFSzzVpvX/u63ywhHQ=
=QDUv
-----END PGP SIGNATURE-----

--8/jmVWbv0XRHUVwL--