Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kg2TS-0001wb-Ot for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Nov 2020 09:12:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kg2TO-0000cw-Qi for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Nov 2020 09:12:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfz9V-0005Oa-5H for pgsql-bugs@lists.postgresql.org; Fri, 20 Nov 2020 05:40:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfz9T-000137-6K for pgsql-bugs@lists.postgresql.org; Fri, 20 Nov 2020 05:40:08 +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=XLTW6Flmscb653/ZpKY29gr9W6VoOTtdF0TIYiZCN04=; b=LigY+HzVTl6sZ47FXqpM1874wT n0sEIbPm/EVoma8G2FbxD9r7D00UCMNgH7Ml4PbYNHIU8M5ktiWgsrVRQDHsiMJNTHfP6kewkwFi+ SPiLGLSkVRVRfrBqJpLaaggFiMh0G3crAz0UHC8GOmI5jHITuPBkEUS1ma864sfDbR9gXK5lnyh4V LctkSZwJUfQ2KNI9hWQoARTmiy7Fv43gKyl3nSmy3lrtYcsF/HCEto0pRDEQfj2PklN9rFV1FUBqb GaQDzhXWJ+LuoW4AeHNH1JUpGkvvCGBlfSHzpIAP+nG2HNq0KcNjUW8PhCM3vETL5NeDLxF1ZZttj nv997hag==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfz9R-0002vq-Bi for pgsql-bugs@lists.postgresql.org; Fri, 20 Nov 2020 05:40:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kfz9O-0003rX-2X for pgsql-bugs@lists.postgresql.org; Fri, 20 Nov 2020 05:40:02 +0000 Content-Type: multipart/mixed; boundary="===============3285456741105287796==" MIME-Version: 1.0 Subject: BUG #16733: insert into on conflict(pk) do nothing error violates not-null constraint To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zhongxuchen@gmail.com Reply-To: zhongxuchen@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 20 Nov 2020 05:39:35 +0000 Message-ID: <16733-fb8b26e66710b2a1@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3285456741105287796== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjczMwpMb2dnZWQgYnk6ICAgICAgICAgIHpob25neHVjaGVuCkVtYWls IGFkZHJlc3M6ICAgICAgemhvbmd4dWNoZW5AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTIuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIGNlbnRvczgKRGVzY3JpcHRpb246ICAgICAgICAKCnNv cnJ5ICxBIHNjZW5lIHRoYXQgd2FzIG1pc3NlZCBiZWZvcmXvvIENCg0KMeOAgXBvc3RncmVzcWwg aW5zZXJ077yI77yJdmFsdWVz77yI77yJb24gY29uZmxpY3QgKHBrKSBkbyB1cGRhdGUvIGRvIG5v dGhpbmcNCuW9k+afkOS4quWtl+auteWcqOaVsOaNruW6k+S4reiuvue9ruS4um5vdCBudWxs77yM U1FMIOmUmeivryBbMjM1MDJdOiBFUlJPUjogbnVsbCB2YWx1ZSBpbiBjb2x1bW4gIm5hbWUiDQp2 aW9sYXRlcyBub3QtbnVsbCBjb25zdHJhaW50DQoNCmV4YW1wbGXvvJoNCkNSRUFURSBUQUJMRSBU RVNUMSAoDQppZCB2YXJjaGFyKDEwMCkgTk9UIE5VTEwsDQpuYW1lIHZhcmNoYXIoMTAwKSBOT1Qg TlVMTCwNCnN0YXR1cyB2YXJjaGFyKDEwMCkgTk9UIE5VTEwsDQpDT05TVFJBSU5UIHRlc3QxX3Br ZXkgUFJJTUFSWSBLRVkgKGlkKQ0KKQ0KDQpJbml0aWFsaXphdGlvbiBkYXRhDQppbnNlcnQgaW50 byBURVNUMSAoSUQsIE5BTUUsU1RBVFVTICkgdmFsdWVzKCc0JywndGVzdCcsJzYnKSA7DQoNCkVy cm9yIHNjZW5hcmlvc++8mg0KMeOAgWluc2VydCBpbnRvIFRFU1QxIGFzIHQxIChJRCwgTkFNRSxT VEFUVVMgKSB2YWx1ZXMoJzQnLG51bGwsJzYnKSBvbgpjb25mbGljdA0KKGlkKSBkbyB1cGRhdGUg c2V0IE5BTUU9Q09BTEVTQ0UoZXhjbHVkZWQuTkFNRSx0MS5OQU1FKSwNClNUQVRVUz1DT0FMRVND RShleGNsdWRlZC5TVEFUVVMsdDEuU1RBVFVTKTsNCg0KMuOAgWluc2VydCBpbnRvIFRFU1QxIGFz IHQxIChJRCwgTkFNRSxTVEFUVVMgKSB2YWx1ZXMoJzQnLG51bGwsJzYnKSBvbgpjb25mbGljdA0K KGlkKSBkbyBub3RoaW5nCgo= --===============3285456741105287796==--