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 1v6t5C-00BLsP-DH for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Oct 2025 16:01:34 +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 1v6t5A-006xFt-5D for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Oct 2025 16:01:33 +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 1v6spK-006WZd-PZ for pgsql-bugs@lists.postgresql.org; Thu, 09 Oct 2025 15:45:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v6spH-001G4i-1S for pgsql-bugs@lists.postgresql.org; Thu, 09 Oct 2025 15:45:11 +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=+GW7tsZmo9MEmDOv5lZ9B0czSh3qC3C4TxzzsS8fiqM=; b=59eZRflI9hvFxL37+R+eSI4tGW lTtfsp5xu9gQLWXTSJg81ubHndQY+429RrfpuXPuIsd6OnNQltCxrWNdP+TBOiepWVvhUEQH930Gm Umt1WQei1lje1aCrH8DiW7CDceDrTQv6PNoytqRb5eqlEh3x7xFIFXSZZZEyWHp3fSt04zDnLYWjQ SFSc1El3WmdGJGgma2vROo2B1bpZoDX90ZTnPvKqlzZZjFAPbLbz/nuAuDSrawygNAvVhjWJ8SZ2Y trgHNDSK6f3187CzU4p2n9l3QxFxPlPrUg+b3/KpP8M3smuduBF52rv2LFPMeMfRYTjcodL99RNzc +1CWYXmQ==; 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.94.2) (envelope-from ) id 1v6spF-002PJe-Mw for pgsql-bugs@lists.postgresql.org; Thu, 09 Oct 2025 15:45:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v6spD-008Oj8-1p for pgsql-bugs@lists.postgresql.org; Thu, 09 Oct 2025 15:45:03 +0000 Content-Type: multipart/mixed; boundary="===============4942321284925521563==" MIME-Version: 1.0 Subject: BUG #19081: Inconsistent target rows seen by the UPDATE and INSERT statements within the same transaction To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cuiziyu20@otcaix.iscas.ac.cn Reply-To: cuiziyu20@otcaix.iscas.ac.cn, pgsql-bugs@lists.postgresql.org Date: Thu, 09 Oct 2025 15:44:15 +0000 Message-ID: <19081-3745d3e571c420de@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 --===============4942321284925521563== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA4MQpMb2dnZWQgYnk6ICAgICAgICAgIFppeXUgQ3VpCkVtYWlsIGFk ZHJlc3M6ICAgICAgY3Vpeml5dTIwQG90Y2FpeC5pc2Nhcy5hYy5jbgpQb3N0Z3JlU1FMIHZlcnNp b246IDE4LjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUtMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkF0IHRoZSBSZXBlYXRhYmxlIFJlYWQgaXNvbGF0aW9uIGxldmVsLCB0aGUgdGFyZ2V0 IHJvd3Mgc2VlbiBieSBVUERBVEUgYW5kCklOU0VSVCB3aXRoaW4gdGhlIHNhbWUgdHJhbnNhY3Rp b24gYXJlIGluY29uc2lzdGVudC4KClN0ZXBzIHRvIHJlcHJvZHVjZToKLyogaW5pdCAqLyBDUkVB VEUgVEFCTEUgdDAgKGMxIElOVCBQUklNQVJZIEtFWSwgYzIgSU5UKTsKLyogaW5pdCAqLyBJTlNF UlQgSU5UTyB0MCAoYzEsIGMyKSBWQUxVRVMgKDAsIDApOwoKIC0tIFRSQU5TQUNUSU9OIDE7CkJF R0lOOwpVUERBVEUgdDAgU0VUIGMxID0gNSwgYzIgPSA1IFdIRVJFIGMyID0gMDsKQ09NTUlUOwoK IC0tIFRSQU5TQUNUSU9OIDI7CkJFR0lOOwpJTlNFUlQgSU5UTyB0MCAoYzEsIGMyKSBWQUxVRVMg KDIsIDIpOwpJTlNFUlQgSU5UTyB0MCAoYzEsIGMyKSBWQUxVRVMgKDAsIDEyKTsKVVBEQVRFIHQw IFNFVCBjMSA9IDksIGMyID0gOSBXSEVSRSBjMiA9IDU7CkNPTU1JVDsKCi0tIFN1Ym1pdCBPcmRl cgovKiBUMSAqLyBCRUdJTjsKLyogVDEgKi8gVVBEQVRFIHQwIFNFVCBjMSA9IDUsIGMyID0gNSBX SEVSRSBjMiA9IDA7Ci8qIFQyICovIEJFR0lOOwovKiBUMiAqLyBJTlNFUlQgSU5UTyB0MCAoYzEs IGMyKSBWQUxVRVMgKDIsIDIpOwovKiBUMSAqLyBDT01NSVQ7Ci8qIFQyICovIElOU0VSVCBJTlRP IHQwIChjMSwgYzIpIFZBTFVFUyAoMCwgMTIpOwovKiBUMiAqLyBVUERBVEUgdDAgU0VUIGMxID0g OSwgYzIgPSA5IFdIRVJFIGMyID0gNTsKLyogVDIgKi8gQ09NTUlUOwoKU0VMRUNUICogRlJPTSB0 MDsKCiBjMSB8IGMyCi0tLS0rLS0tLQogIDUgfCAgNQogIDIgfCAgMgogIDAgfCAxMgoKQWZ0ZXIg dHJhbnNhY3Rpb24gMSB3YXMgY29tbWl0dGVkLCB0aGUgc2Vjb25kIElOU0VSVCBpbiB0cmFuc2Fj dGlvbiAyCnN1Y2Nlc3NmdWxseSBpbnNlcnRlZCB0aGUgdmFsdWUgKDAsIDEyKSBiZWNhdXNlIHRy YW5zYWN0aW9uIDEgaGFkIHVwZGF0ZWQKdGhlIHJvdyAoMCwgMCkuIEhvd2V2ZXIsIHRoZSBVUERB VEUgaW4gdHJhbnNhY3Rpb24gMiBkaWQgbm90IHVwZGF0ZSB0aGUgcm93Cig1LCA1KSB0aGF0IHdl cmUgdXBkYXRlZCBpbiB0cmFuc2FjdGlvbiAxLgpUaGUgZmluYWwgZGF0YWJhc2UgcmVzdWx0IHNl ZW1zIHRvIGluZGljYXRlIHRoYXQgdGhlIHNlY29uZCBJTlNFUlQgaW4KdHJhbnNhY3Rpb24gMiBj YW4gc2VlIHRoZSB1cGRhdGUgbWFkZSBieSB0cmFuc2FjdGlvbiAxLCBidXQgdGhlIFVQREFURSBp bgp0cmFuc2FjdGlvbiAyIGNhbm5vdCBzZWUgdGhlIHVwZGF0ZSBtYWRlIGJ5IHRyYW5zYWN0aW9u IDEuIFdoeSBkbyB0aGVzZSB0d28Kc3RhdGVtZW50cyBzaG93IGRpZmZlcmVudCBlZmZlY3RzIHdo ZW4gZXhwb3NlZCB0byB0aGUgaW5mbHVlbmNlIG9mCnRyYW5zYWN0aW9uIDE/CgpBbm90aGVyIGNh c2U6Ci8qIGluaXQgKi8gQ1JFQVRFIFRBQkxFIHQwIChjMSBJTlQgUFJJTUFSWSBLRVksIGMyIElO VCk7Ci8qIGluaXQgKi8gSU5TRVJUIElOVE8gdDAgKGMxLCBjMikgVkFMVUVTICgwLCAwKTsKCiAt LSBUUkFOU0FDVElPTiAxOwpCRUdJTjsKVVBEQVRFIHQwIFNFVCBjMSA9IDUsIGMyID0gNSBXSEVS RSBjMiA9IDA7CkNPTU1JVDsKCiAtLSBUUkFOU0FDVElPTiAyOwpCRUdJTjsKSU5TRVJUIElOVE8g dDAgKGMxLCBjMikgVkFMVUVTICgyLCAyKTsKSU5TRVJUIElOVE8gdDAgKGMxLCBjMikgVkFMVUVT ICg2LCAxMik7ClVQREFURSB0MCBTRVQgYzEgPSA5LCBjMiA9IDkgV0hFUkUgYzIgPSAwOwpDT01N SVQ7CgotLSBTdWJtaXQgT3JkZXIKLyogVDEgKi8gQkVHSU47Ci8qIFQxICovIFVQREFURSB0MCBT RVQgYzEgPSA1LCBjMiA9IDUgV0hFUkUgYzIgPSAwOwovKiBUMiAqLyBCRUdJTjsKLyogVDIgKi8g SU5TRVJUIElOVE8gdDAgKGMxLCBjMikgVkFMVUVTICgyLCAyKTsKLyogVDEgKi8gQ09NTUlUOwov KiBUMiAqLyBJTlNFUlQgSU5UTyB0MCAoYzEsIGMyKSBWQUxVRVMgKDYsIDEyKTsKLyogVDIgKi8g VVBEQVRFIHQwIFNFVCBjMSA9IDksIGMyID0gOSBXSEVSRSBjMiA9IDA7Ci0tIEVSUk9SOiAgY291 bGQgbm90IHNlcmlhbGl6ZSBhY2Nlc3MgZHVlIHRvIGNvbmN1cnJlbnQgdXBkYXRlCi8qIFQyICov IENPTU1JVDsKClNFTEVDVCAqIEZST00gdDA7CgogYzEgfCBjMgotLS0tKy0tLS0KICA1IHwgIDUK CkFsdGhvdWdoIHRyYW5zYWN0aW9uIDEgaGFzIGJlZW4gY29tbWl0dGVkLCAgdGhlIFVQREFURSBp biB0cmFuc2FjdGlvbiAyCnN0aWxsIGNvbmZsaWN0cyB3aXRoIHRyYW5zYWN0aW9uIDEgYW5kIHJl cG9ydHMgYW4gZXJyb3IgImNvdWxkIG5vdCBzZXJpYWxpemUKYWNjZXNzIGR1ZSB0byBjb25jdXJy ZW50IHVwZGF0ZSIuIFdoeSB3YXMgdHJhbnNhY3Rpb24gMiBhZmZlY3RlZCBieSB0aGUKVVBEQVRF IGluIHRyYW5zYWN0aW9uIDEgYXQgdGhpcyB0aW1lPwoK --===============4942321284925521563==--