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 1vU0JR-00FMlU-0r for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Dec 2025 10:23:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vU0JQ-007Yg8-0D for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Dec 2025 10:23:48 +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 1vU0JP-007Yfy-0R for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 10:23:48 +0000 Received: from m16.mail.163.com ([220.197.31.2]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vU0JJ-000K8T-21 for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 10:23:46 +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=K/kkjaPxIfP3aIdfUYIJAcDyTpskMVQvOFrfm2KVWeo=; b=q du25WO9r5ffwq7Ht2EhhJBSqY/jNbjRPqFnUFgy9TFlrP01OgyYrQzdkqKIXqnqQ rii8h/mMeNkw85xAo7FS/nXkJ6SAkGTi5A4iYMBEdJptFtGhlY944+9qYU5FaCPF vCA+7C0UtOvdes6IiDo0FVWaHXUE7kEaOfAbnOSG2Q= Received: from msdnchina$163.com ( [113.128.48.245] ) by ajax-webmail-wmsvr-40-115 (Coremail) ; Fri, 12 Dec 2025 18:23:24 +0800 (CST) X-Originating-IP: [113.128.48.245] Date: Fri, 12 Dec 2025 18:23:24 +0800 (CST) From: "yanliang lei" To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: "Srinath Reddy Sadipiralla" , pgsql-bugs@lists.postgresql.org Subject: 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: <202512110728.qdjdihtm7pmg@alvherre.pgsql> References: <202512110728.qdjdihtm7pmg@alvherre.pgsql> X-CM-CTRLMSGS: Pmgix3BsdXM9MTc2NTUzNTAwNDI2NV9iNDI2MjQ3ODYyYzU0NmUyNGUxMGQ0O WZiN2ZhZjAxZA== X-NTES-SC: AL_Qu2dB/mYukgr4iKZYukfmUsVg+s3WMWxsv0n2IdSOJB6jDzpyjwGc1NvN0DZyfmdGyyPqBqvaAl+8cR/VIVTTrAG1Cm3Fb8g1+d/6dEgXZmOxw== Content-Type: multipart/alternative; boundary="----=_Part_144589_1248777302.1765535004225" MIME-Version: 1.0 Message-ID: <1259da72.9641.19b12163641.Coremail.msdnchina@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID:cygvCgB3Wkoc7Ttp1xo4AA--.942W X-CM-SenderInfo: xpvg0upklqtqqrwthudrp/xtbCxByrL2k77RwFQAAA36 X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_144589_1248777302.1765535004225 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 VGhhbmtzIGZvciByZXBseWluZyAuCgoKaW4gdGhlIHBvc3RncmVzcWwgMTgg77yMbm90IG51bGwg aGFzIOKAnENvbnN0cmFpbnQgTmFtZeKAne+8jGFuZCB0aGlzIGlzIGEgUG9zdGdyZVNRTCAxOCAg TmV3IEZlYXR1cmUuCgoKc28gLCBpIHRoaW5rIHRoYXQ6IHRoaXMgcHJvYmxlbShCVUcgIzE5MzUx KSBpcyBhIGJ1Zy4KCgoKQXQgMjAyNS0xMi0xMSAxNToyOTo0NSwgIsOBbHZhcm8gSGVycmVyYSIg PGFsdmhlcnJlQGt1cmlsZW11LmRlPiB3cm90ZToKPk9uIDIwMjUtRGVjLTEwLCBTcmluYXRoIFJl ZGR5IFNhZGlwaXJhbGxhIHdyb3RlOgo+Cj4+IGFoLi4uIGp1c3QgYWZ0ZXIgYSBxdWljayBjb2Rl IGxvb2t1cCwgcmVtZW1iZXJlZCB0aGF0Cj4+ICJub3QgbnVsbCIgaXMgdHJlYXRlZCBhcyBhIGNv bHVtbiBwcm9wZXJ0eSwgd2hpY2ggaXMgYQo+PiBmbGFnIGluIHBnX2F0dHJpYnV0ZSBjYXRhbG9n IHRhYmxlIG5hbWVkIGFzICJhdHRub3RudWxsIiwKPgo+VGhpcyBpcyBubyBsb25nZXIgdHJ1ZSBp biAxOC4KPmh0dHBzOi8vd3d3LmVudGVycHJpc2VkYi5jb20vYmxvZy9jaGFuZ2VzLW5vdC1udWxs LXBvc3RncmVzLTE4Cj4KPi0tIAo+w4FsdmFybyBIZXJyZXJhICAgICAgICBCcmVpc2dhdSwgRGV1 dHNjaGxhbmQgIOKAlCAgaHR0cHM6Ly93d3cuRW50ZXJwcmlzZURCLmNvbS8KPiJGdW5kYW1lbnRh bCBsYXllcmluZyB2aW9sYXRpb25zIHRlbmQgdG8gYml0ZSB5b3Ugb24gdGVuZGVyCj5wYXJ0cyBv ZiB5b3VyIGFuYXRvbXkuIiAgICAgICAgICAgICAgICAgICAgICAgICAgKFRvbSBMYW5lKQo+aHR0 cHM6Ly9wb3N0Z3IuZXMvbS8yODE4MjQ5LjE3NDg3MDYxMjFAc3NzLnBnaC5wYS51cwo= ------=_Part_144589_1248777302.1765535004225 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdiBp ZD0ic3BuRWRpdG9yQ29udGVudCI+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGRpdiBpZD0ic3Bu RWRpdG9yQ29udGVudCI+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7Ij5UaGFua3MgZm9yIHJlcGx5 aW5nIC48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDBweDsiPjxicj48L2Rpdj48ZGl2IHN0eWxl PSJtYXJnaW46IDBweDsiPmluIHRoZSBwb3N0Z3Jlc3FsIDE4IO+8jG5vdCBudWxsIGhhcyDigJxD b25zdHJhaW50IE5hbWXigJ3vvIxhbmQgdGhpcyBpcyBhIFBvc3RncmVTUUwgMTgmbmJzcDsgTmV3 IEZlYXR1cmUuPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7Ij48YnI+PC9kaXY+PGRpdiBz dHlsZT0ibWFyZ2luOiAwcHg7Ij5zbyAsIGkgdGhpbmsgdGhhdDogdGhpcyBwcm9ibGVtKEJVRyAj MTkzNTEpIGlzIGEgYnVnLjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjxkaXYgc3R5bGU9InBvc2l0 aW9uOnJlbGF0aXZlO3pvb206MSI+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48 L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PHByZT48YnI+QXQgMjAyNS0x Mi0xMSAxNToyOTo0NSwgIsOBbHZhcm8gSGVycmVyYSIgJmx0O2FsdmhlcnJlQGt1cmlsZW11LmRl Jmd0OyB3cm90ZToKJmd0O09uIDIwMjUtRGVjLTEwLCBTcmluYXRoIFJlZGR5IFNhZGlwaXJhbGxh IHdyb3RlOgomZ3Q7CiZndDsmZ3Q7IGFoLi4uIGp1c3QgYWZ0ZXIgYSBxdWljayBjb2RlIGxvb2t1 cCwgcmVtZW1iZXJlZCB0aGF0CiZndDsmZ3Q7ICJub3QgbnVsbCIgaXMgdHJlYXRlZCBhcyBhIGNv bHVtbiBwcm9wZXJ0eSwgd2hpY2ggaXMgYQomZ3Q7Jmd0OyBmbGFnIGluIHBnX2F0dHJpYnV0ZSBj YXRhbG9nIHRhYmxlIG5hbWVkIGFzICJhdHRub3RudWxsIiwKJmd0OwomZ3Q7VGhpcyBpcyBubyBs b25nZXIgdHJ1ZSBpbiAxOC4KJmd0O2h0dHBzOi8vd3d3LmVudGVycHJpc2VkYi5jb20vYmxvZy9j aGFuZ2VzLW5vdC1udWxsLXBvc3RncmVzLTE4CiZndDsKJmd0Oy0tIAomZ3Q7w4FsdmFybyBIZXJy ZXJhICAgICAgICBCcmVpc2dhdSwgRGV1dHNjaGxhbmQgIOKAlCAgaHR0cHM6Ly93d3cuRW50ZXJw cmlzZURCLmNvbS8KJmd0OyJGdW5kYW1lbnRhbCBsYXllcmluZyB2aW9sYXRpb25zIHRlbmQgdG8g Yml0ZSB5b3Ugb24gdGVuZGVyCiZndDtwYXJ0cyBvZiB5b3VyIGFuYXRvbXkuIiAgICAgICAgICAg ICAgICAgICAgICAgICAgKFRvbSBMYW5lKQomZ3Q7aHR0cHM6Ly9wb3N0Z3IuZXMvbS8yODE4MjQ5 LjE3NDg3MDYxMjFAc3NzLnBnaC5wYS51cwo8L3ByZT48L2Rpdj4= ------=_Part_144589_1248777302.1765535004225--