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 1vTM1c-000lks-06 for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Dec 2025 15:22:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTM1a-00CPFc-1y for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Dec 2025 15:22:42 +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 ) id 1vTLY5-00CF4E-1u for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 14:52:13 +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.96) (envelope-from ) id 1vTLY2-0049LK-25 for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 14:52:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=+gQ9hFj1SX9abUQ4TsLyMxDTY4xI+pfvfaUyP0i3w00=; b=Tv1fwgOpqp3PAm8pO73w2C3o9p w1rT0TkgTzG4RvGdVUEH4dJDEFSPvEgIbnqmwAtrOn/NQ+BQRYWwDUrm5ioG1esrTkKYgqldI1cdB zBbO9VdRyTdn/k8RaDYl7zn2WOzfGWExxj/gW6gTmr1HS7eqXLxjr0ahReJxMMpuYKWSW8+uAlDj6 n9hP2GzfpWDyGf1kH31F1iHRMiIszXdPXPVcYSDcHLC8P7jZ6L/yi7il0cCgdPb8F5kwc2yQ+lCE2 csp+9PhFd7He4BFaJCK9kFETeKNzQwiakT5deue3Kd6/PiDvKEcnS8pe3wInOj6nZDV1x7QITVxHz 1CZFuBhQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTLXx-007xRP-0Z for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 14:52:10 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTLXu-00B9wz-1t for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 14:52:03 +0000 Content-Type: multipart/mixed; boundary="===============6347939453300418888==" MIME-Version: 1.0 Subject: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: msdnchina@163.com Reply-To: msdnchina@163.com, pgsql-bugs@lists.postgresql.org Date: Wed, 10 Dec 2025 14:51:20 +0000 Message-ID: <19351-8f1c523ead498545@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6347939453300418888== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM1MQpMb2dnZWQgYnk6ICAgICAgICAgIHlhbmxpYW5nIGxlaQpFbWFp bCBhZGRyZXNzOiAgICAgIG1zZG5jaGluYUAxNjMuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTgu MQpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpwb3N0Z3Jl cz0jIGNyZWF0ZSB0YWJsZSB0ZXN0X251bGxfMjAyNTEyMTAoYzEgaW50IG5vdCBudWxsLGMyIHRl eHQpOwpDUkVBVEUgVEFCTEUKcG9zdGdyZXM9IyBcZCsgdGVzdF9udWxsXzIwMjUxMjEwCiAgICAg ICAgICAgICAgICAgICAgICAg5pWw5o2u6KGoICJwdWJsaWMudGVzdF9udWxsXzIwMjUxMjEwIgog 5qCP5L2NIHwgIOexu+WeiyAgIHwg5qCh5a+56KeE5YiZIHwgIOWPr+epuueahCAgfCDpooTorr4g fCAgIOWtmOWCqCAgIHwg5Y6L57ypIHwg57uf6K6h55uu5qCHIHwg5o+P6L+wCi0tLS0tLSstLS0t LS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLSstLS0t LS0tLS0tKy0tLS0tLQogYzEgICB8IGludGVnZXIgfCAgICAgICAgICB8IG5vdCBudWxsIHwgICAg ICB8IHBsYWluICAgIHwgICAgICB8ICAgICAgICAgIHwKIGMyICAgfCB0ZXh0ICAgIHwgICAgICAg ICAgfCAgICAgICAgICB8ICAgICAgfCBleHRlbmRlZCB8ICAgICAgfCAgICAgICAgICB8Ck5vdC1u dWxsIGNvbnN0cmFpbnRzOgogICAgInRlc3RfbnVsbF8yMDI1MTIxMF9jMV9ub3RfbnVsbCIgTk9U IE5VTEwgImMxIgrorr/pl67mlrnms5UgaGVhcAoKcG9zdGdyZXM9IyBhbHRlciB0YWJsZSB0ZXN0 X251bGxfMjAyNTEyMTAgYWRkICBjb25zdHJhaW50IHh5enh5eiBub3QgbnVsbApjMTsKQUxURVIg VEFCTEUKPDw8LS0tIGFib3ZlICBhbHRlciB0YWJsZSBzdGF0ZW1lbnQgc2hvdWxkIHJlcG9ydCAn bm90IG51bGwgY29uc3RyYWludApleGlzdHMnLAo8PDwtLS0tIE1heWJlIHRoaXMgcHJvYmxlbSBp cyBhIGJ1ZyA/CnBvc3RncmVzPSMgXGQrIHRlc3RfbnVsbF8yMDI1MTIxMAogICAgICAgICAgICAg ICAgICAgICAgIOaVsOaNruihqCAicHVibGljLnRlc3RfbnVsbF8yMDI1MTIxMCIKIOagj+S9jSB8 ICDnsbvlnosgICB8IOagoeWvueinhOWImSB8ICDlj6/nqbrnmoQgIHwg6aKE6K6+IHwgICDlrZjl gqggICB8IOWOi+e8qSB8IOe7n+iuoeebruaghyB8IOaPj+i/sAotLS0tLS0rLS0tLS0tLS0tKy0t LS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0KIGMxICAgfCBpbnRlZ2VyIHwgICAgICAgICAgfCBub3QgbnVsbCB8ICAgICAgfCBwbGFp biAgICB8ICAgICAgfCAgICAgICAgICB8CiBjMiAgIHwgdGV4dCAgICB8ICAgICAgICAgIHwgICAg ICAgICAgfCAgICAgIHwgZXh0ZW5kZWQgfCAgICAgIHwgICAgICAgICAgfApOb3QtbnVsbCBjb25z dHJhaW50czoKICAgICJ0ZXN0X251bGxfMjAyNTEyMTBfYzFfbm90X251bGwiIE5PVCBOVUxMICJj MSIK6K6/6Zeu5pa55rOVIGhlYXAKCnBvc3RncmVzPSMgc2VsZWN0IHZlcnNpb24oKTsKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tCiBQb3N0Z3JlU1FMIDE4LjEgb24gYWFyY2g2NC11bmtub3duLWxpbnV4LWdudSwg Y29tcGlsZWQgYnkgZ2NjIChHQ0MpIDcuMy4wLAo2NC1iaXQKKDEg6KGM6K6w5b2VKQoKcG9zdGdy ZXM9IwoK --===============6347939453300418888==--