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 1pd7Nv-0004jr-Kv for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Mar 2023 10:32:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pd7Nu-0004Dc-8Y for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Mar 2023 10:32:30 +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 1pczwx-00074I-MV for pgsql-bugs@lists.postgresql.org; Fri, 17 Mar 2023 02:36:12 +0000 Received: from m126.mail.126.com ([220.181.12.37] helo=126.com) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pczwn-0008TL-WF for pgsql-bugs@lists.postgresql.org; Fri, 17 Mar 2023 02:36:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=wD8X4Fh1+10wOQmPat0i3xd9sS/grTQmOfqjDe2HU3I=; b=Y 8raPWKDPDm/wGgvTwyw+Ipmi6d7wvF+7WExZaPy9H5zhFiWHjvgWXpco1zR4m2FT Ik/Ii5bzhi5bN052KSxHuSDG7yR64vyR711b2u3U5BvvrGaPswAslOvd8N079/xt /PVr/pcEY3Yn1ENG7tPrUXsChDFpl8PM4THvGHDizg= Received: from digoal$126.com ( [140.205.11.15] ) by ajax-webmail-wmsvr22 (Coremail) ; Fri, 17 Mar 2023 10:34:53 +0800 (CST) X-Originating-IP: [140.205.11.15] Date: Fri, 17 Mar 2023 10:34:53 +0800 (CST) From: =?UTF-8?B?5b635ZOl?= To: "jian he" Cc: pgsql-bugs@lists.postgresql.org Subject: Re:Re: BUG #17845: insert into on conflict bug . X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2023 www.mailtech.cn 126com In-Reply-To: References: <17845-fee889ae7e226a76@postgresql.org> Content-Type: multipart/alternative; boundary="----=_Part_28420_1608202917.1679020493145" MIME-Version: 1.0 Message-ID: <5a1545f3.1e8a.186ed6b8959.Coremail.digoal@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: _____wBnb+7O0RNk8OIJAA--.41942W X-CM-SenderInfo: 5glj0tbo6rjloofrz/1tbiJBM1l1pEHH6d9gABsD X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_28420_1608202917.1679020493145 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 SW4gdGhpcyBjYXNlLCBgd2hlcmUgYS50cyA8IGV4Y2x1ZGUuIHRzYCBhbmQgYG9yZGVyIGJ5IHRz IGRlc2NgIGFyZSB1c2VkLiBUaGUgdHMgb2YgdGhlIHR1cGxlIGluc2VydGVkIGZpcnN0IGlzIHRo ZSBsYXJnZXN0LiBTbyB3aHkgdGhyb3cgYW4gZXJyb3I/IFRocm93aW5nIGFuIGVycm9yIGhlcmUg aXMgb2J2aW91c2x5IG5vdCBsb2dpY2FsbHkgY29ycmVjdC4KCgoK5ZyoIDIwMjMtMDMtMTYgMjI6 Mjg6MjfvvIwiamlhbiBoZSIgPGppYW4udW5pdmVyc2FsaXR5QGdtYWlsLmNvbT4g5YaZ6YGT77ya CgoKCgoKT24gVGh1LCBNYXIgMTYsIDIwMjMgYXQgNTo0MuKAr1BNIFBHIEJ1ZyByZXBvcnRpbmcg Zm9ybSA8bm9yZXBseUBwb3N0Z3Jlc3FsLm9yZz4gd3JvdGU6CgpUaGUgZm9sbG93aW5nIGJ1ZyBo YXMgYmVlbiBsb2dnZWQgb24gdGhlIHdlYnNpdGU6CgpCdWcgcmVmZXJlbmNlOiAgICAgIDE3ODQ1 CkxvZ2dlZCBieTogICAgICAgICAgWmhvdSBEaWdvYWwKRW1haWwgYWRkcmVzczogICAgICBkaWdv YWxAMTI2LmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE1LjIKT3BlcmF0aW5nIHN5c3RlbTogICBt YWNvcwpEZXNjcmlwdGlvbjogICAgICAgCgppbnNlcnQgaW50byBvbiBjb25mbGljdCBidWcgLgpJ biB0aGUgZm9sbG93aW5nIGluc2VydCBzdGF0ZW1lbnQsIHRoZSByb3cgaGFzIG5vdCBiZWVuIHVw ZGF0ZWQgbXVsdGlwbGUKdGltZXMsIHdoeSBpcyBpdCBzdGlsbCBzaG93aW5nIGFuIGVycm9yPwoK YGBgCmNyZWF0ZSB0YWJsZSBhIChpZCBpbnQgcHJpbWFyeSBrZXksIGluZm8gdGV4dCwgdHMgZGF0 ZSk7CgoKaW5zZXJ0IGludG8gYQpzZWxlY3QgKiBmcm9tICh2YWx1ZXMgKDEsJ2EnLGRhdGUgJzIw MjItMDEtMDEnKSwoMSwnYicsZGF0ZQonMjAyMi0wMS0wMicpLCgxLCdjJyxkYXRlICcyMDIyLTAx LTAzJykpIGFzIHQgKGlkLGluZm8sdHMpIG9yZGVyIGJ5IHRzCmRlc2MKb24gY29uZmxpY3QgKGlk KQpkbyB1cGRhdGUgc2V0IGluZm89ZXhjbHVkZWQuaW5mbywgdHM9ZXhjbHVkZWQudHMgd2hlcmUg YS50cyA8IGV4Y2x1ZGVkLnRzIDsKCgoKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBR VUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQogSW5zZXJ0IG9uIGEgIChjb3N0PTAuMDYuLjAuMTAgcm93cz0wIHdpZHRoPTApCiAgIENvbmZs aWN0IFJlc29sdXRpb246IFVQREFURQogICBDb25mbGljdCBBcmJpdGVyIEluZGV4ZXM6IGFfcGtl eQogICBDb25mbGljdCBGaWx0ZXI6IChhLnRzIDwgZXhjbHVkZWQudHMpCiAgIC0+ICBTb3J0ICAo Y29zdD0wLjA2Li4wLjA3IHJvd3M9MyB3aWR0aD00MCkKICAgICAgICAgU29ydCBLZXk6ICIqVkFM VUVTKiIuY29sdW1uMyBERVNDCiAgICAgICAgIC0+ICBWYWx1ZXMgU2NhbiBvbiAiKlZBTFVFUyoi ICAoY29zdD0wLjAwLi4wLjA0IHJvd3M9MyB3aWR0aD00MCkKKDcgcm93cykKCgpFUlJPUjogIDIx MDAwOiBPTiBDT05GTElDVCBETyBVUERBVEUgY29tbWFuZCBjYW5ub3QgYWZmZWN0IHJvdyBhIHNl Y29uZAp0aW1lCkhJTlQ6ICBFbnN1cmUgdGhhdCBubyByb3dzIHByb3Bvc2VkIGZvciBpbnNlcnRp b24gd2l0aGluIHRoZSBzYW1lIGNvbW1hbmQKaGF2ZSBkdXBsaWNhdGUgY29uc3RyYWluZWQgdmFs dWVzLgpMT0NBVElPTjogIEV4ZWNPbkNvbmZsaWN0VXBkYXRlLCBub2RlTW9kaWZ5VGFibGUuYzoy MDU0CmBgYAoKCgoKaXQncyBleHBlY3RlZCBiZWhhdmlvci4KClNlZSB0aGUgdGVzdCBleHBlY3Rl ZCByZXN1bHQgaW4gc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbnNlcnRfY29uZmxpY3Qub3V0 LCBiZWdpbiB3aXRoIGxpbmUgNjk0Lg== ------=_Part_28420_1608202917.1679020493145 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 SW4gdGhpcyBjYXNlLCBgd2hlcmUgYS50cyAmbHQ7IGV4Y2x1ZGUuIHRzYCBhbmQgYG9yZGVyIGJ5 IHRzIGRlc2NgIGFyZSB1c2VkLiBUaGUgdHMgb2YgdGhlIHR1cGxlIGluc2VydGVkIGZpcnN0IGlz IHRoZSBsYXJnZXN0LiBTbyB3aHkgdGhyb3cgYW4gZXJyb3I/IFRocm93aW5nIGFuIGVycm9yIGhl cmUgaXMgb2J2aW91c2x5IG5vdCBsb2dpY2FsbHkgY29ycmVjdC48YnI+PGJyPjxwPuWcqCAyMDIz LTAzLTE2IDIyOjI4OjI377yMImppYW4gaGUiICZsdDtqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5j b20mZ3Q7IOWGmemBk++8mjwvcD48YmxvY2txdW90ZSBpZD0iaXNSZXBseUNvbnRlbnQiIHN0eWxl PSJQQURESU5HLUxFRlQ6IDFleDsgTUFSR0lOOiAwcHggMHB4IDBweCAwLjhleDsgQk9SREVSLUxF RlQ6ICNjY2MgMXB4IHNvbGlkIj48ZGl2IGRpcj0ibHRyIj48ZGl2IGRpcj0ibHRyIj48ZGl2IGNs YXNzPSJnbWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1pbHk6dmVyZGFuYSxzYW5zLXNlcmlm Ij48YnI+PC9kaXY+PC9kaXY+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX3F1b3RlIj48ZGl2IGRpcj0i bHRyIiBjbGFzcz0iZ21haWxfYXR0ciI+T24gVGh1LCBNYXIgMTYsIDIwMjMgYXQgNTo0MuKAr1BN IFBHIEJ1ZyByZXBvcnRpbmcgZm9ybSAmbHQ7PGEgaHJlZj0ibWFpbHRvOm5vcmVwbHlAcG9zdGdy ZXNxbC5vcmciIHRhcmdldD0iX2JsYW5rIj5ub3JlcGx5QHBvc3RncmVzcWwub3JnPC9hPiZndDsg d3JvdGU6PGJyPjwvZGl2PjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1h cmdpbjowcHggMHB4IDBweCAwLjhleDtib3JkZXItbGVmdDoxcHggc29saWQgcmdiKDIwNCwyMDQs MjA0KTtwYWRkaW5nLWxlZnQ6MWV4Ij5UaGUgZm9sbG93aW5nIGJ1ZyBoYXMgYmVlbiBsb2dnZWQg b24gdGhlIHdlYnNpdGU6PGJyPgo8YnI+CkJ1ZyByZWZlcmVuY2U6Jm5ic3A7ICZuYnNwOyAmbmJz cDsgMTc4NDU8YnI+CkxvZ2dlZCBieTombmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 IFpob3UgRGlnb2FsPGJyPgpFbWFpbCBhZGRyZXNzOiZuYnNwOyAmbmJzcDsgJm5ic3A7IDxhIGhy ZWY9Im1haWx0bzpkaWdvYWxAMTI2LmNvbSIgdGFyZ2V0PSJfYmxhbmsiPmRpZ29hbEAxMjYuY29t PC9hPjxicj4KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNS4yPGJyPgpPcGVyYXRpbmcgc3lzdGVtOiZu YnNwOyAmbmJzcDttYWNvczxicj4KRGVzY3JpcHRpb246Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i c3A7IDxicj4KPGJyPgppbnNlcnQgaW50byBvbiBjb25mbGljdCBidWcgLjxicj4KSW4gdGhlIGZv bGxvd2luZyBpbnNlcnQgc3RhdGVtZW50LCB0aGUgcm93IGhhcyBub3QgYmVlbiB1cGRhdGVkIG11 bHRpcGxlPGJyPgp0aW1lcywgd2h5IGlzIGl0IHN0aWxsIHNob3dpbmcgYW4gZXJyb3I/PGJyPgo8 YnI+CmBgYDxicj4KY3JlYXRlIHRhYmxlIGEgKGlkIGludCBwcmltYXJ5IGtleSwgaW5mbyB0ZXh0 LCB0cyBkYXRlKTs8YnI+Cjxicj4KPGJyPgppbnNlcnQgaW50byBhIDxicj4Kc2VsZWN0ICogZnJv bSAodmFsdWVzICgxLCdhJyxkYXRlICcyMDIyLTAxLTAxJyksKDEsJ2InLGRhdGU8YnI+CicyMDIy LTAxLTAyJyksKDEsJ2MnLGRhdGUgJzIwMjItMDEtMDMnKSkgYXMgdCAoaWQsaW5mbyx0cykgb3Jk ZXIgYnkgdHM8YnI+CmRlc2M8YnI+Cm9uIGNvbmZsaWN0IChpZCkgPGJyPgpkbyB1cGRhdGUgc2V0 IGluZm89PGEgaHJlZj0iaHR0cDovL2V4Y2x1ZGVkLmluZm8iIHJlbD0ibm9yZWZlcnJlciIgdGFy Z2V0PSJfYmxhbmsiPmV4Y2x1ZGVkLmluZm88L2E+LCB0cz1leGNsdWRlZC50cyB3aGVyZSBhLnRz ICZsdDsgZXhjbHVkZWQudHMgOzxicj4KPGJyPgo8YnI+Cjxicj4KJm5ic3A7ICZuYnNwOyAmbmJz cDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNw OyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IFFVRVJZIFBMQU4mbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJz cDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgPGJyPgotLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLTxicj4KJm5ic3A7SW5zZXJ0IG9uIGEmbmJzcDsgKGNvc3Q9MC4wNi4uMC4xMCBy b3dzPTAgd2lkdGg9MCk8YnI+CiZuYnNwOyAmbmJzcDtDb25mbGljdCBSZXNvbHV0aW9uOiBVUERB VEU8YnI+CiZuYnNwOyAmbmJzcDtDb25mbGljdCBBcmJpdGVyIEluZGV4ZXM6IGFfcGtleTxicj4K Jm5ic3A7ICZuYnNwO0NvbmZsaWN0IEZpbHRlcjogKGEudHMgJmx0OyBleGNsdWRlZC50cyk8YnI+ CiZuYnNwOyAmbmJzcDstJmd0OyZuYnNwOyBTb3J0Jm5ic3A7IChjb3N0PTAuMDYuLjAuMDcgcm93 cz0zIHdpZHRoPTQwKTxicj4KJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwO1NvcnQg S2V5OiAiKlZBTFVFUyoiLmNvbHVtbjMgREVTQzxicj4KJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOy0mZ3Q7Jm5ic3A7IFZhbHVlcyBTY2FuIG9uICIqVkFMVUVTKiImbmJzcDsgKGNv c3Q9MC4wMC4uMC4wNCByb3dzPTMgd2lkdGg9NDApPGJyPgooNyByb3dzKTxicj4KPGJyPgo8YnI+ CkVSUk9SOiZuYnNwOyAyMTAwMDogT04gQ09ORkxJQ1QgRE8gVVBEQVRFIGNvbW1hbmQgY2Fubm90 IGFmZmVjdCByb3cgYSBzZWNvbmQ8YnI+CnRpbWU8YnI+CkhJTlQ6Jm5ic3A7IEVuc3VyZSB0aGF0 IG5vIHJvd3MgcHJvcG9zZWQgZm9yIGluc2VydGlvbiB3aXRoaW4gdGhlIHNhbWUgY29tbWFuZDxi cj4KaGF2ZSBkdXBsaWNhdGUgY29uc3RyYWluZWQgdmFsdWVzLjxicj4KTE9DQVRJT046Jm5ic3A7 IEV4ZWNPbkNvbmZsaWN0VXBkYXRlLCBub2RlTW9kaWZ5VGFibGUuYzoyMDU0PGJyPgpgYGA8YnI+ Cjxicj4KPC9ibG9ja3F1b3RlPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGRpdiBzdHlsZT0i Zm9udC1mYW1pbHk6dmVyZGFuYSxzYW5zLXNlcmlmIiBjbGFzcz0iZ21haWxfZGVmYXVsdCI+aXQn cyBleHBlY3RlZCBiZWhhdmlvci48YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6dmVy ZGFuYSxzYW5zLXNlcmlmIiBjbGFzcz0iZ21haWxfZGVmYXVsdCI+U2VlIHRoZSB0ZXN0IGV4cGVj dGVkIHJlc3VsdCBpbiBzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luc2VydF9jb25mbGljdC5v dXQsIGJlZ2luIHdpdGggbGluZSA2OTQuPC9kaXY+PC9kaXY+PHNwYW4+PHNwYW4gY2xhc3M9Imdt YWlsX2RlZmF1bHQiIHN0eWxlPSJmb250LWZhbWlseTp2ZXJkYW5hLHNhbnMtc2VyaWYiPjwvc3Bh bj48L3NwYW4+PC9kaXY+CjwvYmxvY2txdW90ZT4= ------=_Part_28420_1608202917.1679020493145--