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 ) id 1vUH3S-00494N-1A for pgsql-bugs@arkaria.postgresql.org; Sat, 13 Dec 2025 04:16:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vUH3R-009v2T-15 for pgsql-bugs@arkaria.postgresql.org; Sat, 13 Dec 2025 04:16:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUH3Q-009v2F-1o for pgsql-bugs@lists.postgresql.org; Sat, 13 Dec 2025 04:16:25 +0000 Received: from m16.mail.163.com ([117.135.210.2]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUH3K-000TSC-0r for pgsql-bugs@lists.postgresql.org; Sat, 13 Dec 2025 04:16:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:To:Subject:Content-Type:MIME-Version: Message-ID; bh=M64+BvL8gGHi4FGbHPqtYjYgRUBJnQx16frY/U0I74o=; b=d VxyTLwLH6DlT0uabTVElRfuyYOUirDqTFm4rp3dvlO1wpA6JEXSguyrybHGQQe4v uaWy47+ogSbt1nlnf7kI3FnWDZF0mvpzpOdRtAmV/SKEb+REzP4Tz999ni4lJ13d +rTyfphr8K+G9BrxvHlljqBKNKHRjqU7Z1+07c32RQ= Received: from msdnchina$163.com ( [120.225.24.250] ) by ajax-webmail-wmsvr-40-149 (Coremail) ; Sat, 13 Dec 2025 12:15:53 +0800 (CST) X-Originating-IP: [120.225.24.250] Date: Sat, 13 Dec 2025 12:15:53 +0800 (CST) From: "yanliang lei" To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: "Srinath Reddy Sadipiralla" , pgsql-bugs@lists.postgresql.org Subject: Re:Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2023.4-cmXT build 20250723(a044bf12) Copyright (c) 2002-2025 www.mailtech.cn 163com In-Reply-To: <202512121501.pmpgh7tiz53e@alvherre.pgsql> References: <202512121501.pmpgh7tiz53e@alvherre.pgsql> X-CM-CTRLMSGS: mA0V63BsdXM9MTc2NTU5OTM1MzE3OF8xMWZmMzMxOGRhZGQyMzE3ZDhkZjJjZ TAxMjM0NDQ5Yg== X-NTES-SC: AL_Qu2dB/mStksu5SGcYekfmUsVg+s3WMWxsv0n2IdSOJB6jCLr/T4+dnFCM2TR3OmjFBmDlgGlSBhN5cZRZohkfqIlbjCxuIY+P7fZEimIdOkuSw== Content-Type: multipart/alternative; boundary="----=_Part_26248_1478370202.1765599353154" MIME-Version: 1.0 Message-ID: <6ec30f7.19f1.19b15ec1942.Coremail.msdnchina@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID:lSgvCgD3H6t56DxpC3M4AA--.578W X-CM-SenderInfo: xpvg0upklqtqqrwthudrp/xtbC7BnBRWk86Hkg-wAA3q X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_26248_1478370202.1765599353154 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 aGkKCgpJJ20gc29ycnksIEkgZGlkbid0IG5vdGljZSB5b3VyIHJlcGx5LiBJIGp1c3QgcmVhZCB5 b3VyIHJlcGx5IGFuZCBJJ20gc29ycnksIGFzIEkgYW0gdGhlIGVuZCB1c2VyIG9mIHRoZSBkYXRh YmFzZSBhbmQgbm90IGEgZGV2ZWxvcGVyIG9mIHRoZSBkYXRhYmFzZSwgSSBkb24ndCBrbm93IGhv dyB0byBmaW5kIGNvbW1pdCAxNGU4N2ZmYTVjNTQuCgoKRnJvbSB0aGUgcGVyc3BlY3RpdmUgb2Yg dGhlIGVuZCB1c2VyIG9mIHRoZSBkYXRhYmFzZSxJbiBQb3N0Z3JlU1FMIDE4LAoKClN0ZXAgMTog QWZ0ZXIgdGhlIHN1Y2Nlc3NmdWwgZXhlY3V0aW9uIG9mICJjcmVhdGUgdGFibGUgdGVzdF9udWxs XzIwMjUxMjEwIChjMSBpbnQgbm90IG51bGwsIGMyIHRleHQpOyIsIApQb3N0Z3JlU1FMIDE4ICB3 aWxsIGF1dG9tYXRpY2FsbHkgY3JlYXRlIGEgbm90IG51bGwgY29uc3RyYWludCBuYW1lIGZvciBj b2x1bW4gYzEsIGFuZCB0aGUgY29uc3RyYWludCBuYW1lIGlzICAidGVzdF9udWxsXzIwMjUxMjEw dWMxX25vdF9udWxsIiwKCgpTdGVwIDI6IFRoZSBleGVjdXRpb24gb2YgJ2FsdGVyIHRhYmxlIHRl c3RfbnVsbF8yMDI1MTIxMCBhZGQgY29uc3RyYWludCB4eXp4eXogbm90IG51bGwgYzEnIGRpZCBu b3QgcmV0dXJuIGFueSBlcnJvcnMuCgoKYWZ0ZXIgdGhlIGV4ZWN1dGlvbiBvZiBTdGVwIDIgLCB0 aGUgZXhlY3V0aW5nIHVzZXIgb2YgdGhlIFNRTCBzdGF0ZW1lbnQgImFsdGVyIHRhYmxlIHRlc3Rf bnVsbF8yMDI1MTIxMCBhZGQgY29uc3RyYWludCB4eXp4eXogbm90IG51bGwgYzEiIGluIHRoZSBT dGVwIDIgd2lsbCBhc3N1bWUgKGJlY2F1c2UgdGhlcmUgd2FzIG5vIGVycm9yIHByb21wdCBpbiB0 aGUgIFN0ZXAgMiAgICkgdGhhdCB0aGUgbm90IG51bGwgY29uc3RyYWludCBoYXMgYmVlbiBzdWNj ZXNzZnVsbHkgYWRkZWQgdG8gY29sdW1uIGMxLCBhbmQgdGhlIG5hbWUgb2YgdGhlIGNvbnN0cmFp bnQgaXMgeHl6eHl6LgogLS0tLUhvd2V2ZXIsIGluIHJlYWxpdHksIGJhc2VkIG9uIHRoZSBleGVj dXRpb24gcmVzdWx0cyBvZiB0aGUgU1FMIGRhdGFiYXNlLCB0aGUgU3RlcCAyIGRpZCBub3QgYWN0 dWFsbHkgc3VjY2VlZC4KCgpTbywgYmFzZWQgb24gdGhpcyBzaXR1YXRpb24sCkkgYmVsaWV2ZSB0 aGF0IHRoZXJlIGlzIGEgcHJvYmxlbSB3aXRoIHRoZSBleGVjdXRpb24gcmVzdWx0IG9mIHRoZSBT dGVwIDIgbm90IHJlcG9ydGluZyBhbiBlcnJvciwgd2hpY2ggY2FuIG1pc2xlYWQgdGhlIHVzZXIg ZXhlY3V0aW5nIHRoZSBTUUwgc3RhdGVtZW50IGluIFN0ZXAgMi4KCkF0IDIwMjUtMTItMTIgMjM6 MDE6NTMsICLDgWx2YXJvIEhlcnJlcmEiIDxhbHZoZXJyZUBrdXJpbGVtdS5kZT4gd3JvdGU6Cj5P biAyMDI1LURlYy0xMiwgeWFubGlhbmcgbGVpIHdyb3RlOgo+Cj4+IFRoYW5rcyBmb3IgcmVwbHlp bmcgLgo+PiAKPj4gaW4gdGhlIHBvc3RncmVzcWwgMTgg77yMbm90IG51bGwgaGFzIOKAnENvbnN0 cmFpbnQgTmFtZeKAne+8jGFuZCB0aGlzIGlzIGEgUG9zdGdyZVNRTCAxOCAgTmV3IEZlYXR1cmUu Cj4+IAo+PiBzbyAsIGkgdGhpbmsgdGhhdDogdGhpcyBwcm9ibGVtKEJVRyAjMTkzNTEpIGlzIGEg YnVnLgo+Cj5EaWQgeW91IHJlYWQgbXkgb3RoZXIgcmVwbHk/Cj5odHRwczovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9tZXNzYWdlLWlkLzIwMjUxMjExMDcxNi5qcGJjaGVmZmhkb3clNDBhbHZoZXJyZS5w Z3NxbAo+Cj4tLSAKPsOBbHZhcm8gSGVycmVyYSAgICAgICAgQnJlaXNnYXUsIERldXRzY2hsYW5k ICDigJQgIGh0dHBzOi8vd3d3LkVudGVycHJpc2VEQi5jb20vCj4iUmlnaHQgbm93IHRoZSBzZWN0 b3JzIG9uIHRoZSBoYXJkIGRpc2sgcnVuIGNsb2Nrd2lzZSwgYnV0IEkgaGVhcmQgYSBydW1vciB0 aGF0Cj55b3UgY2FuIHNxdWVlemUgMC4yJSBtb3JlIHRocm91Z2hwdXQgYnkgcnVubmluZyB0aGVt IGNvdW50ZXJjbG9ja3dpc2UuCj5JdCdzIHdvcnRoIHRoZSBlZmZvcnQuIFJlY29tbWVuZGVkLiIg IChHZXJyeSBQb3Vyd2VsbGUpCg== ------=_Part_26248_1478370202.1765599353154 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdiBp ZD0ic3BuRWRpdG9yQ29udGVudCI+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+aGk8L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+SSdt IHNvcnJ5LCBJIGRpZG4ndCBub3RpY2UgeW91ciByZXBseS4gSSBqdXN0IHJlYWQgeW91ciByZXBs eSBhbmQgSSdtIHNvcnJ5LCBhcyBJIGFtIHRoZSBlbmQgdXNlciBvZiB0aGUgZGF0YWJhc2UgYW5k IG5vdCBhIGRldmVsb3BlciBvZiB0aGUgZGF0YWJhc2UsIEkgZG9uJ3Qga25vdyBob3cgdG8gZmlu ZCBjb21taXQgMTRlODdmZmE1YzU0Lgo8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij4KPC9k aXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjog MDsiPkZyb20gdGhlIHBlcnNwZWN0aXZlIG9mIHRoZSBlbmQgdXNlciBvZiB0aGUgZGF0YWJhc2Us SW4gUG9zdGdyZVNRTCAxOCwKPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2 PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPlN0ZXAgMTogQWZ0ZXIgdGhlIHN1Y2Nlc3NmdWwgZXhl Y3V0aW9uIG9mICJjcmVhdGUgdGFibGUgdGVzdF9udWxsXzIwMjUxMjEwIChjMSBpbnQgbm90IG51 bGwsIGMyIHRleHQpOyIsJm5ic3A7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+UG9zdGdy ZVNRTCAxOCZuYnNwOyB3aWxsIGF1dG9tYXRpY2FsbHkgY3JlYXRlIGEgbm90IG51bGwgY29uc3Ry YWludCBuYW1lIGZvciBjb2x1bW4gYzEsIGFuZCB0aGUgY29uc3RyYWludCBuYW1lIGlzJm5ic3A7 ICJ0ZXN0X251bGxfMjAyNTEyMTB1YzFfbm90X251bGwiLAo8L2Rpdj48ZGl2IHN0eWxlPSJtYXJn aW46IDA7Ij4KPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2PjxkaXYgc3R5 bGU9Im1hcmdpbjogMDsiPlN0ZXAgMjogVGhlIGV4ZWN1dGlvbiBvZiAnYWx0ZXIgdGFibGUgdGVz dF9udWxsXzIwMjUxMjEwIGFkZCBjb25zdHJhaW50IHh5enh5eiBub3QgbnVsbCBjMScgZGlkIG5v dCByZXR1cm4gYW55IGVycm9ycy4KPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+CjwvZGl2 PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7 Ij5hZnRlciB0aGUgZXhlY3V0aW9uIG9mIFN0ZXAgMiAsIHRoZSBleGVjdXRpbmcgdXNlciBvZiB0 aGUgU1FMIHN0YXRlbWVudCAiYWx0ZXIgdGFibGUgdGVzdF9udWxsXzIwMjUxMjEwIGFkZCBjb25z dHJhaW50IHh5enh5eiBub3QgbnVsbCBjMSIgaW4gdGhlIFN0ZXAgMiAgd2lsbCBhc3N1bWUgKGJl Y2F1c2UgdGhlcmUgd2FzIG5vIGVycm9yIHByb21wdCBpbiB0aGUmbmJzcDsKU3RlcCAyJm5ic3A7 Jm5ic3A7ICkgdGhhdCB0aGUgbm90IG51bGwgY29uc3RyYWludCBoYXMgYmVlbiBzdWNjZXNzZnVs bHkgYWRkZWQgdG8gY29sdW1uIGMxLCBhbmQgdGhlIG5hbWUgb2YgdGhlIGNvbnN0cmFpbnQgaXMg eHl6eHl6LjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPiZuYnNwOy0tLS1Ib3dldmVyLCBp biByZWFsaXR5LCBiYXNlZCBvbiB0aGUgZXhlY3V0aW9uIHJlc3VsdHMgb2YgdGhlIFNRTCBkYXRh YmFzZSwgdGhlIFN0ZXAgMiBkaWQgbm90IGFjdHVhbGx5IHN1Y2NlZWQuIAo8L2Rpdj48ZGl2IHN0 eWxlPSJtYXJnaW46IDA7Ij4KPC9kaXY+PC9kaXY+PGRpdiBzdHlsZT0icG9zaXRpb246cmVsYXRp dmU7em9vbToxIj48L2Rpdj48ZGl2IGlkPSJkaXZOZXRlYXNlTWFpbENhcmQiPjwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5Tbywg YmFzZWQgb24gdGhpcyBzaXR1YXRpb24sCjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPkkg YmVsaWV2ZSB0aGF0IHRoZXJlIGlzIGEgcHJvYmxlbSB3aXRoIHRoZSBleGVjdXRpb24gcmVzdWx0 IG9mIHRoZSBTdGVwIDIgbm90IHJlcG9ydGluZyBhbiBlcnJvciwgd2hpY2ggY2FuIG1pc2xlYWQg dGhlIHVzZXIgZXhlY3V0aW5nIHRoZSBTUUwgc3RhdGVtZW50IGluIFN0ZXAgMi48L2Rpdj48cHJl Pjxicj5BdCAyMDI1LTEyLTEyIDIzOjAxOjUzLCAiw4FsdmFybyBIZXJyZXJhIiAmbHQ7YWx2aGVy cmVAa3VyaWxlbXUuZGUmZ3Q7IHdyb3RlOgomZ3Q7T24gMjAyNS1EZWMtMTIsIHlhbmxpYW5nIGxl aSB3cm90ZToKJmd0OwomZ3Q7Jmd0OyBUaGFua3MgZm9yIHJlcGx5aW5nIC4KJmd0OyZndDsgCiZn dDsmZ3Q7IGluIHRoZSBwb3N0Z3Jlc3FsIDE4IO+8jG5vdCBudWxsIGhhcyDigJxDb25zdHJhaW50 IE5hbWXigJ3vvIxhbmQgdGhpcyBpcyBhIFBvc3RncmVTUUwgMTggIE5ldyBGZWF0dXJlLgomZ3Q7 Jmd0OyAKJmd0OyZndDsgc28gLCBpIHRoaW5rIHRoYXQ6IHRoaXMgcHJvYmxlbShCVUcgIzE5MzUx KSBpcyBhIGJ1Zy4KJmd0OwomZ3Q7RGlkIHlvdSByZWFkIG15IG90aGVyIHJlcGx5PwomZ3Q7aHR0 cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC8yMDI1MTIxMTA3MTYuanBiY2hlZmZo ZG93JTQwYWx2aGVycmUucGdzcWwKJmd0OwomZ3Q7LS0gCiZndDvDgWx2YXJvIEhlcnJlcmEgICAg ICAgIEJyZWlzZ2F1LCBEZXV0c2NobGFuZCAg4oCUICBodHRwczovL3d3dy5FbnRlcnByaXNlREIu Y29tLwomZ3Q7IlJpZ2h0IG5vdyB0aGUgc2VjdG9ycyBvbiB0aGUgaGFyZCBkaXNrIHJ1biBjbG9j a3dpc2UsIGJ1dCBJIGhlYXJkIGEgcnVtb3IgdGhhdAomZ3Q7eW91IGNhbiBzcXVlZXplIDAuMiUg bW9yZSB0aHJvdWdocHV0IGJ5IHJ1bm5pbmcgdGhlbSBjb3VudGVyY2xvY2t3aXNlLgomZ3Q7SXQn cyB3b3J0aCB0aGUgZWZmb3J0LiBSZWNvbW1lbmRlZC4iICAoR2VycnkgUG91cndlbGxlKQo8L3By ZT48L2Rpdj4= ------=_Part_26248_1478370202.1765599353154--