Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 24 Feb 2026 08:20:11 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?iso-8859-1?Q?=C1lvaro?= Herrera <alvherre@kurilemu.de>
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: <aZzgq3Cqvrv_a7k3@paquier.xyz>
References: <aZp6mrxzlNc1KmRf@paquier.xyz>
 <202602231541.tcrufawcdbne@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="w4xlRbOij5OwxnPD"
Content-Disposition: inline
In-Reply-To: <202602231541.tcrufawcdbne@alvherre.pgsql>
Archived-At: <https://www.postgresql.org/message-id/aZzgq3Cqvrv_a7k3%40paquier.xyz>
Precedence: bulk


--w4xlRbOij5OwxnPD
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Feb 23, 2026 at 05:47:46PM +0100, Alvaro Herrera wrote:
> On 2026-Feb-22, Michael Paquier wrote:
>> Based on my read of the fix, I feel rather safe that this is OK.  But
>> as I have quoted upthread, the reason why I did not reply yet was to
>> wait for next week's release to be out before acting.  That's your
>> code of course, so no objections from here, just a slight doubt about
>> the timing.
>=20
> Hmm, what?  The only response from you that I see in this thread is
> https://postgr.es/m/aYp9tTWjUqS1ffAd@paquier.xyz
> which was on Feb 10th, which is before the 18.2 release, so you couldn't
> have been considering the 18.3 release yet.

Well, you are not counting the week of the 18.2 release, this thread
being an item I had on my stack of items to look at once the tags were
applied.  It didn't make to the top of the list.  It does not matter
much at the end.  Thanks for fixing the issue!
--
Michael

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

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

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmmc4KsACgkQnvQgOdby
QH1i+w/+N/M5Ja53QqCDLIUVXCTTWlf63LhvCsGXOtJfWV1gpYThmkRqvDLXCZCC
MjbLJ1ckOb+AnKbG3UcmDykpYdj5uX7eHjJ6VnHF+YT47T/lmUbqysy9+jRWgpE1
YUSPAYGBNXL99A9qqUftcKl/THQFyTBtN3cEk/36IGEuIXsUg5mT5U8pzpFi/JCI
jnPW8y0cy+KUOdQROxnrffxS97pccFYyPoVKgYjQTKWOfc288ms3orKTKbtWIt/x
B5zAyeCLaud0EE/zAdwEHchSdHzx5pJ/s/5ytnNI/kmxtIRDih80jrTNVRhNUMWO
2927OKYsaBNQoBkvgmzMNoXkxz7CZZgI1iTriGzWTHFOkCZfgVgR2KPA11MLVbFG
Mn8bf2O7S4UwZP2vcuA9Ew1ZC5LDsffM7Szz+ym5QLtN1qBaFYgfqAc4zf/R8Gd+
PrQMGmlRXzZnesXzNsA6XurKTKRJpnC51fdRCAGtO0pCGKNfGGcX6/EFU0NDl/KJ
UlWkt9aNa5RNvOCEyLfT1VgHbtK3MASs3FxJ7Z3ep2SXer10q/IHlGWnRA0NiJyo
YyPNmePUcjneaWxiOv6bJWsI13digfAC+qvdguK239XHae4Xi2dY+pNSvw3Sve+c
rGjmJ1yzLK/CA8SPG9BcrCneWhI2SuIMslmYjO5sG+P18vk6BzI=
=5y1y
-----END PGP SIGNATURE-----

--w4xlRbOij5OwxnPD--