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.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vtKNy-00GvsP-2p
	for pgsql-hackers@arkaria.postgresql.org;
	Fri, 20 Feb 2026 06:53:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vtKNx-006ppX-1S
	for pgsql-hackers@arkaria.postgresql.org;
	Fri, 20 Feb 2026 06:53:09 +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.96)
	(envelope-from <huseyin.d3r@gmail.com>)
	id 1vtKNx-006ppO-0Z
	for pgsql-hackers@lists.postgresql.org;
	Fri, 20 Feb 2026 06:53:09 +0000
Received: from mahout.postgresql.org ([2001:4800:3e1:1::227])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <huseyin.d3r@gmail.com>)
	id 1vtKNu-00000000KAW-234W
	for pgsql-hackers@lists.postgresql.org;
	Fri, 20 Feb 2026 06:53:08 +0000
Received: from coridan.postgresql.org ([2001:4800:3e1:1::213])
	by mahout.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <huseyin.d3r@gmail.com>)
	id 1vtKNp-000kig-2A
	for pgsql-hackers@lists.postgresql.org;
	Fri, 20 Feb 2026 06:53:02 +0000
Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org)
	by coridan.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <huseyin.d3r@gmail.com>)
	id 1vtKNq-000bxV-0G
	for pgsql-hackers@lists.postgresql.org;
	Fri, 20 Feb 2026 06:53:02 +0000
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Subject: Re: BUG #19393: pg_upgrade fails with duplicate key violation when CHECK constraint named *_not_null exists
To: pgsql-hackers@lists.postgresql.org
From: =?utf-8?q?H=C3=BCseyin_Demir?= <huseyin.d3r@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Date: Fri, 20 Feb 2026 06:52:33 +0000
User-Agent: pgcommitfest
X-cfsender: demir
In-Reply-To: <aYp9tTWjUqS1ffAd@paquier.xyz>
References: <19393-6a82427485a744cf@postgresql.org> <aYp9tTWjUqS1ffAd@paquier.xyz>
Message-ID: <177157035357.626.5599596504298221780.pgcf@coridan.postgresql.org>
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/177157035357.626.5599596504298221780.pgcf%40coridan.postgresql.org>
Precedence: bulk

VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl
c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBmYWlsZWQK
SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIGZhaWxlZApTcGVjIGNvbXBsaWFudDog
ICAgICAgICAgIHRlc3RlZCwgZmFpbGVkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgdGVzdGVk
LCBmYWlsZWQKCkhpLA0KDQpJIHJldmlld2VkIGFuZCB0ZXN0ZWQgdjIgb2YgdGhpcyBwYXRjaC4N
Cg0KQnVpbGRzIHdpdGggemVybyBlcnJvcnMgYW5kIHplcm8gd2FybmluZ3MgYW5kIGFsbCB0ZXN0
cyBwYXNzZWQuDQoNClZlcmlmaWVkIHRoZSBmaXggYWdhaW5zdCBCdWcgIzE5MzkzLiBUaGUgb3Jp
Z2luYWwgY3Jhc2ggKHVuaXF1ZSBrZXkgdmlvbGF0aW9uIG9uIHBnX2NvbnN0cmFpbnRfY29ucmVs
aWRfY29udHlwaWRfY29ubmFtZV9pbmRleCkgbm8gbG9uZ2VyIG9jY3Vycy4NCkFsc28gdGVzdGVk
IGVkZ2UgY2FzZXM6IGNhc2NhZGluZyBjb2xsaXNpb25zIChuYW1lLCBuYW1lMSwgbmFtZTIgYWxs
IHRha2VuKSwgbXVsdGlwbGUgTk9UIE5VTEwgY29sdW1ucyB3aXRoIG1peGVkIGNvbGxpc2lvbnMs
IGFuZCB0aGUgbm9ybWFsIG5vLWNvbGxpc2lvbiBjYXNlLiBBbGwgd29yaw0KY29ycmVjdGx5LiBO
byBkb2MgY2hhbmdlcyBuZWVkZWQuCgpUaGUgbmV3IHN0YXR1cyBvZiB0aGlzIHBhdGNoIGlzOiBS
ZWFkeSBmb3IgQ29tbWl0dGVyCg==