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.94.2) (envelope-from ) id 1v9IRQ-00EsE0-DW for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Oct 2025 07:30:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v9IRP-00AacS-3q for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Oct 2025 07:30: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.94.2) (envelope-from ) id 1v9IRO-00AacC-Rb for pgsql-bugs@lists.postgresql.org; Thu, 16 Oct 2025 07:30:25 +0000 Received: from smtp83.cstnet.cn ([159.226.251.83] helo=cstnet.cn) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v9IRH-002TrK-1p for pgsql-bugs@lists.postgresql.org; Thu, 16 Oct 2025 07:30:23 +0000 Received: from cuiziyu20$otcaix.iscas.ac.cn ( [124.16.137.194] ) by ajax-webmail-APP-09 (Coremail) ; Thu, 16 Oct 2025 15:30:10 +0800 (GMT+08:00) X-Originating-IP: [124.16.137.194] Date: Thu, 16 Oct 2025 15:30:10 +0800 (GMT+08:00) X-CM-HeaderCharset: UTF-8 From: =?UTF-8?B?5bSU57Sr546J?= To: "Tom Lane" Cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19081: Inconsistent target rows seen by the UPDATE and INSERT statements within the same transaction X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2024.1-cmXT5 build 20240627(e6c6db66) Copyright (c) 2002-2025 www.mailtech.cn cnic.cn In-Reply-To: <3080220.1760030272@sss.pgh.pa.us> References: <19081-3745d3e571c420de@postgresql.org> <3080220.1760030272@sss.pgh.pa.us> Content-Transfer-Encoding: base64 Content-Type: text/plain; charset=UTF-8 MIME-Version: 1.0 Message-ID: <5eba3d4e.22dfa.199ebed21cd.Coremail.cuiziyu20@otcaix.iscas.ac.cn> X-Coremail-Locale: en_US X-CM-TRANSID: swCowAD3th8Cn_Bo_OMCAA--.28047W X-CM-SenderInfo: xfxl6xd1xsiq5rwftx30ol2u1dvotugofq/1tbiDAURB2jwgzhwlQ AAsZ X-Coremail-Antispam: 1Ur529EdanIXcx71UUUUU7IcSsGvfJ3iIAIbVAYjsxI4VW7Jw CS07vEb4IE77IF4wCS07vE1I0E4x80FVAKz4kxMIAIbVAFxVCaYxvI4VCIwcAKzIAtYxBI daVFxhVjvjDU= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksCgpUaGFuayB5b3UgZm9yIHlvdXIgZXhwbGFuYXRpb24uIEhvd2V2ZXIsIGZvciB0aGUgVVBE QVRFIHN0YXRlbWVudCDigJxVUERBVEUgdDAgU0VUIGMxID0gOSwgYzIgPSA5IFdIRVJFIGMyID0g NTvigJ0gaW4gdHJhbnNhY3Rpb24gMiwgd2h5IGRvZXMgdGhlIFVQREFURSBzdGF0ZW1lbnQgaW4g dHJhbnNhY3Rpb24gMiBpbiB0aGUgZmlyc3QgY2FzZSBmYWlsIHRvIG1hdGNoIHRoZSByb3cgdGhh dCB3YXMgY2hhbmdlZCB0byAoNSwgNSkgaW4gdGhlIGNvbW1pdHRlZCB0cmFuc2FjdGlvbiAxPyBJ biB0aGUgc2Vjb25kIGNhc2UsIHdoeSBkb2VzIHRoZSBVUERBVEUgc3RhdGVtZW50IGluIHRyYW5z YWN0aW9uIDIgcmVwb3J0IGFuIGVycm9yIOKAnGNvdWxkIG5vdCBzZXJpYWxpemUgYWNjZXNzIGR1 ZSB0byBjb25jdXJyZW50IHVwZGF0ZeKAnT8KCkJlc3QgcmVnYXJkcywKWml5dSBDdWkK