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 1tQK0F-001hfc-2a for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Dec 2024 05:32:16 +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 1tQK0E-00BLq2-By for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Dec 2024 05:32:14 +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 1tQK0E-00BLpu-1t for pgsql-bugs@lists.postgresql.org; Wed, 25 Dec 2024 05:32:13 +0000 Received: from zg8tmtyylji0my4xnjqumte4.icoremail.net ([162.243.164.118]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tQK0A-001UiZ-LA for pgsql-bugs@lists.postgresql.org; Wed, 25 Dec 2024 05:32:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=stu.xidian.edu.cn; s=dkim; h=Received:Date:From:To:Cc:Subject: In-Reply-To:References:Content-Type:MIME-Version:Message-ID; bh=FNWAZUarouV8FYHGb4Qw0vac+IGDS0kfDjKNQ/tYNHk=; b=RQFlHgykDPkC2 HGSw57UwsfUDYG11QRHbAaiN8g+6CGZ2yhGa3Ttl0HgC9DfQAi0ZLBv7PHlWUTmp LTLwKcsXggXf239651ULKkj30xkrgi0Zri8eEmRQd/OKt7GxzFwyT94IoeOnE9xo P7lieFwytmU4IqMZb0L8oJslHYhTFw= Received: from yrshen$stu.xidian.edu.cn ( [111.18.244.233] ) by ajax-webmail-hzbj-edu-front-2.icoremail.net (Coremail) ; Wed, 25 Dec 2024 13:32:08 +0800 (GMT+08:00) X-Originating-IP: [111.18.244.233] Date: Wed, 25 Dec 2024 13:32:08 +0800 (GMT+08:00) X-CM-HeaderCharset: UTF-8 From: yrshen@stu.xidian.edu.cn To: "Greg Sabino Mullane" Cc: pgsql-bugs@lists.postgresql.org Subject: Re: Re: BUG #18750: Inappropriate update when it is blocked in RC X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2023.3-cmXT6 build 20231031(c559f6e3) Copyright (c) 2002-2024 www.mailtech.cn mispb-8dfce572-2f24-404d-b59d-0dd2e304114c-icoremail.cn In-Reply-To: References: <18750-e0a79ec68de35cec@postgresql.org> Content-Type: multipart/alternative; boundary="----=_Part_1939_951113358.1735104728090" MIME-Version: 1.0 Message-ID: X-Coremail-Locale: zh_CN X-CM-TRANSID: ArQMCgCnQdDYmGtn+ggEAA--.376W X-CM-SenderInfo: x1uvxvvq6v33wo0lvxldqovvfxof0/1tbiAQELAGbQzOMIsgARs5 X-Coremail-Antispam: 1Ur529EdanIXcx71UUUUU7IcSsGvfJ3iIAIbVAYjsxI4VWxJw CS07vEb4IE77IF4wCS07vE1I0E4x80FVAKz4kxMIAIbVAFxVCaYxvI4VCIwcAKzIAtYxBI daVFxhVjvjDU= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1939_951113358.1735104728090 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 SSdtIHNvIHNvcnJ5IHRoYXQgSSBmb3Jnb3QgdG8gcHJvdmlkZSB5b3Ugd2l0aCB0aGUgdmFsdWUg b2YgaW5pdGlhbCB0YWJsZSB0LiBUaGUgdGFibGUgaXMgY3JlYXRlZCBhcyBmb2xsb3dzOgovKiBp bml0ICovIENSRUFURSBUQUJMRSB0KGEgSU5ULCBiIElOVCk7Ci8qIGluaXQgKi8gSU5TRVJUIElO VE8gdCBWQUxVRVMgKG51bGwsIDEpLCAoMSwgMSk7CgoyMDI0LTEyLTI1IDAxOjI0OjA3ICJHcmVn IFNhYmlubyBNdWxsYW5lIiA8aHRhbWZpZHNAZ21haWwuY29tPiDlhpnpgZPvvJoKSXQgd2lsbCBy ZS1ldmFsdWF0ZSB0aGUgcm93cyBpdCBpcyBhbHJlYWR5IHNsYXRlZCB0byB1cGRhdGUsIGl0IGlz IG5vdCBnb2luZyB0byByZS1ydW4gdGhlIHdob2xlIHF1ZXJ5IGFuZCBnZXQgYSBmcmVzaCBsaXN0 IG9mIHJvd3MgdG8gdXBkYXRlLiBIZXJlJ3MgdHdvIG90aGVyIGV4YW1wbGVzLiBVcHBlcmNhc2Ug aXMgbWVzc2FnZXMgcmV0dXJuZWQgdG8gcHNxbCBmcm9tIHRoZSBzZXJ2ZXIuCgoKY3JlYXRlIHRh YmxlIHQgKGlkIGludCk7Cmluc2VydCBpbnRvIHQgdmFsdWVzICgxKSwoMik7CgoKLyogdHgxICov IGJlZ2luOyAtLSBpc29sYXRpb24gbGV2ZWwgZG9lcyBub3QgbWF0dGVyCi8qIHR4MSAqLyBzZWxl Y3QgKiBmcm9tIHQgZm9yIHVwZGF0ZTsgLS0gbGlnaHR3ZWlnaHQgbG9jayBvbiBhbGwgcm93cwoK LyogdHgyICovIGJlZ2luIHRyYW5zYWN0aW9uIGlzb2xhdGlvbiBsZXZlbCByZWFkIGNvbW1pdHRl ZDsKLyogdHgyICovIHVwZGF0ZSB0IHNldCBpZD05OTkgd2hlcmUgaWQgPSAyOyAtLSBoYW5ncywg d2FpdGluZyBmb3IgdGhlIGxvY2sKLyogdHgxICovIHVwZGF0ZSB0IHNldCBpZCA9IDQ7IC0tIHRo ZSB3aGVyZSBjbGF1c2UgaXMgbm93IG5vIGxvbmdlciB0cnVlIGZvciB0aGF0IHJvdwovKiB0eDEg Ki8gVVBEQVRFIDIgLS0gc2VydmVyIHNheXMgd2UgaGF2ZSB1cGRhdGVkIHR3byByb3dzCi8qIHR4 MSAqLyBjb21taXQ7CgovKiB0eDIgKi8gVVBEQVRFIDAgLS0gc2VydmVyIHNheXMgdGhhdCByb3cg bm8gbG9uZ2VyIG1lZXRzIHRoZSBXSEVSRSBjbGF1c2UsIHNvIG5vIHVwZGF0ZQovKiB0eDIgKi8g dXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9IDI7Ci8qIHR4MiAqLyBVUERBVEUgMCAtLSBl dmVyeXRoaW5nIGlzIGEgNAovKiB0eDIgKi8gdXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9 IDQ7Ci8qIHR4MiAqLyBVUERBVEUgMgoKCgoKdHJ1bmNhdGUgdGFibGUgdDsKaW5zZXJ0IGludG8g dCB2YWx1ZXMgKDEpLCgyKTsKCgovKiB0eDEgKi8gYmVnaW47IHNlbGVjdCAqIGZyb20gdCBmb3Ig dXBkYXRlOwovKiB0eDIgKi8gYmVnaW4gdHJhbnNhY3Rpb24gaXNvbGF0aW9uIGxldmVsIHJlYWQg Y29tbWl0dGVkOwovKiB0eDIgKi8gdXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9IDI7IC0t IGhhbmdzLCB3YWl0aW5nIGZvciB0aGUgbG9jawovKiB0eDEgKi8gdXBkYXRlIHQgc2V0IGlkID0g MjsgLS0gbm93IGhhdmUgdHdvIHJvd3MgdGhhdCBtYXRjaCB0aGUgd2hlcmUgY2xhdXNlCi8qIHR4 MSAqLyBVUERBVEUgMiAtLSBzZXJ2ZXIgc2F5cyB3ZSBoYXZlIHVwZGF0ZWQgdHdvIHJvd3MKLyog dHgxICovIGNvbW1pdDsKCi8qIHR4MiAqLyBVUERBVEUgMSAtLSBzZXJ2ZXIgdmVyaWZpZXMgb3Vy IG9yaWdpbmFsIHJvdyBpcyBzdGlsbCB2YWxpZCwgYnV0IGRvZXMgbm90IHVwZGF0ZSB0aGUgIm5l dyIgMgovKiB0eDIgKi8gdXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9IDI7IC0tIGZyZXNo IGxvb2sgYXQgYWxsIHRoZSByb3dzCi8qIHR4MiAqLyBVUERBVEUgMSAtLSB3ZSBoYXZlIHVwZGF0 ZWQgdGhlICJuZXciIDIKLyogdHgyICovIHVwZGF0ZSB0IHNldCBpZD05OTkgd2hlcmUgaWQgPSAy OwovKiB0eDIgKi8gVVBEQVRFIDAgLS0gbm90aGluZyBsZWZ0CgoKSWYgeW91IHNldCB0aGUgc2Vj b25kIHRyYW5zYWN0aW9uIHRvICJyZXBlYXRhYmxlIHJlYWQiLCB5b3Ugd2lsbCBmaW5kIHRoYXQg dGhlIGFib3ZlIHNjZW5hcmlvIHdpbGwgcmVzdWx0IGluIGEgImNvdWxkIG5vdCBzZXJpYWxpemUg YWNjZXNzIGR1ZSB0byBjb25jdXJyZW50IHVwZGF0ZSIgZXJyb3IsIHdoaWNoLCBpbiBteSBvcGlu aW9uLCBpcyBhIG1vcmUgc2FuZSByZXN1bHQuIE9uZSBvZiB0aGUgbWFueSByZWFzb25zIEkgdGVu ZCB0byBhdm9pZCAicmVhZCBjb21taXR0ZWQiLiAKCgpDaGVlcnMsCkdyZWcKCg== ------=_Part_1939_951113358.1735104728090 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 SSdtJm5ic3A7c28mbmJzcDtzb3JyeSZuYnNwO3RoYXQmbmJzcDtJJm5ic3A7Zm9yZ290Jm5ic3A7 dG8mbmJzcDtwcm92aWRlJm5ic3A7eW91Jm5ic3A7d2l0aCZuYnNwO3RoZSZuYnNwO3ZhbHVlJm5i c3A7b2YmbmJzcDtpbml0aWFsJm5ic3A7dGFibGUmbmJzcDt0LiZuYnNwO1RoZSZuYnNwO3RhYmxl Jm5ic3A7aXMmbmJzcDtjcmVhdGVkJm5ic3A7YXMmbmJzcDtmb2xsb3dzOjxicj4vKiZuYnNwO2lu aXQmbmJzcDsqLyZuYnNwO0NSRUFURSZuYnNwO1RBQkxFJm5ic3A7dChhJm5ic3A7SU5ULCZuYnNw O2ImbmJzcDtJTlQpOzxicj4vKiZuYnNwO2luaXQmbmJzcDsqLyZuYnNwO0lOU0VSVCZuYnNwO0lO VE8mbmJzcDt0Jm5ic3A7VkFMVUVTJm5ic3A7KG51bGwsJm5ic3A7MSksJm5ic3A7KDEsJm5ic3A7 MSk7PGJyPjxicj4yMDI0LTEyLTI1IDAxOjI0OjA3IDxhIGhyZWY9Im1haWx0bzomcXVvdDtHcmVn IFNhYmlubyBNdWxsYW5lJnF1b3Q7ICZsdDtodGFtZmlkc0BnbWFpbC5jb20mZ3Q7Ij4iR3JlZyBT YWJpbm8gTXVsbGFuZSIgJmx0O2h0YW1maWRzQGdtYWlsLmNvbSZndDs8L2E+IOWGmemBk++8mjxi bG9ja3F1b3RlIG5hbWU9InJlcGx5Q29udGVudCIgc3R5bGU9InBhZGRpbmctbGVmdDogMWV4O21h cmdpbjogMCAwIDAgMC44ZXg7Ym9yZGVyLWxlZnQ6IDFweCBzb2xpZCAjY2NjOyI+PGRpdj48ZGl2 IGRpcj0ibHRyIj5JdCB3aWxsIHJlLWV2YWx1YXRlIHRoZSByb3dzIGl0IGlzIGFscmVhZHkgc2xh dGVkIHRvIHVwZGF0ZSwgaXQgaXMgbm90IGdvaW5nIHRvIHJlLXJ1biB0aGUgd2hvbGUgcXVlcnkg YW5kIGdldCBhIGZyZXNoIGxpc3Qgb2Ygcm93cyB0byB1cGRhdGUuIEhlcmUncyB0d28gb3RoZXIm bmJzcDtleGFtcGxlcy4gVXBwZXJjYXNlJm5ic3A7aXMgbWVzc2FnZXMgcmV0dXJuZWQgdG8gcHNx bCBmcm9tIHRoZSBzZXJ2ZXIuPGRpdj48YnI+PC9kaXY+PGRpdj5jcmVhdGUgdGFibGUmbmJzcDt0 IChpZCBpbnQpOzwvZGl2PjxkaXY+aW5zZXJ0IGludG8gdCB2YWx1ZXMgKDEpLCgyKTs8L2Rpdj48 ZGl2Pjxicj48L2Rpdj48ZGl2Pi8qIHR4MSAqLyBiZWdpbjsgLS0gaXNvbGF0aW9uIGxldmVsIGRv ZXMgbm90IG1hdHRlcjwvZGl2Pi8qIHR4MSAqLyBzZWxlY3QgKiBmcm9tIHQgZm9yIHVwZGF0ZTsg LS0gbGlnaHR3ZWlnaHQgbG9jayBvbiBhbGwgcm93czxicj48ZGl2Pi8qIHR4MiAqLyBiZWdpbiB0 cmFuc2FjdGlvbiBpc29sYXRpb24gbGV2ZWwgcmVhZCBjb21taXR0ZWQ7PC9kaXY+PGRpdj4vKiB0 eDIgKi8gdXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9IDI7IC0tIGhhbmdzLCB3YWl0aW5n IGZvciB0aGUgbG9jazwvZGl2PjxkaXY+LyogdHgxICovIHVwZGF0ZSB0IHNldCBpZCA9IDQ7IC0t IHRoZSB3aGVyZSBjbGF1c2UgaXMgbm93IG5vIGxvbmdlciB0cnVlIGZvciB0aGF0IHJvdzwvZGl2 PjxkaXY+LyogdHgxICovIFVQREFURSAyIC0tIHNlcnZlciBzYXlzIHdlIGhhdmUgdXBkYXRlZCB0 d28gcm93czwvZGl2PjxkaXY+LyogdHgxICovIGNvbW1pdDs8YnI+PC9kaXY+PGRpdj48ZGl2Pi8q IHR4MiAqLyZuYnNwO1VQREFURSAwIC0tIHNlcnZlciBzYXlzIHRoYXQgcm93IG5vIGxvbmdlciBt ZWV0cyB0aGUgV0hFUkUgY2xhdXNlLCBzbyBubyB1cGRhdGU8L2Rpdj48ZGl2PjxkaXY+PGRpdj4v KiB0eDIgKi8gdXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9IDI7PC9kaXY+PGRpdj4vKiB0 eDIgKi8mbmJzcDtVUERBVEUgMCAtLSBldmVyeXRoaW5nIGlzIGEgNDwvZGl2PjxkaXY+PGRpdj4v KiB0eDIgKi8gdXBkYXRlIHQgc2V0IGlkPTk5OSB3aGVyZSBpZCA9IDQ7PC9kaXY+PC9kaXY+PGRp dj4vKiB0eDIgKi8mbmJzcDtVUERBVEUgMjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjxkaXY+PGJy PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGRpdj50cnVuY2F0ZSB0YWJsZSB0OzwvZGl2Pjxk aXY+PGRpdj5pbnNlcnQgaW50byB0IHZhbHVlcyAoMSksKDIpOzwvZGl2PjxkaXY+PGJyPjwvZGl2 PjwvZGl2PjwvZGl2PjxkaXY+PGRpdj4vKiB0eDEgKi8gYmVnaW47IHNlbGVjdCAqIGZyb20gdCBm b3IgdXBkYXRlOzwvZGl2PjxkaXY+LyogdHgyICovIGJlZ2luIHRyYW5zYWN0aW9uIGlzb2xhdGlv biBsZXZlbCByZWFkIGNvbW1pdHRlZDs8L2Rpdj48ZGl2Pi8qIHR4MiAqLyB1cGRhdGUgdCBzZXQg aWQ9OTk5IHdoZXJlIGlkID0gMjsgLS0gaGFuZ3MsIHdhaXRpbmcgZm9yIHRoZSBsb2NrPC9kaXY+ PGRpdj4vKiB0eDEgKi8gdXBkYXRlIHQgc2V0IGlkID0gMjsgLS0gbm93IGhhdmUgdHdvIHJvd3Mg dGhhdCBtYXRjaCB0aGUgd2hlcmUgY2xhdXNlPC9kaXY+PGRpdj4vKiB0eDEgKi8gVVBEQVRFIDIg LS0gc2VydmVyIHNheXMgd2UgaGF2ZSB1cGRhdGVkIHR3byByb3dzPC9kaXY+PGRpdj4vKiB0eDEg Ki8gY29tbWl0Ozxicj48L2Rpdj48ZGl2Pi8qIHR4MiAqLyZuYnNwO1VQREFURSAxIC0tIHNlcnZl ciB2ZXJpZmllcyBvdXIgb3JpZ2luYWwgcm93IGlzIHN0aWxsIHZhbGlkLCBidXQgZG9lcyBub3Qg dXBkYXRlIHRoZSAibmV3IiAyPC9kaXY+PGRpdj48ZGl2Pi8qIHR4MiAqLyB1cGRhdGUgdCBzZXQg aWQ9OTk5IHdoZXJlIGlkID0gMjsgLS0gZnJlc2ggbG9vayBhdCBhbGwgdGhlIHJvd3M8L2Rpdj48 ZGl2Pi8qIHR4MiAqLyZuYnNwO1VQREFURSAxIC0tIHdlIGhhdmUgdXBkYXRlZCB0aGUgIm5ldyIg MjwvZGl2PjwvZGl2PjwvZGl2PjxkaXY+PGRpdj48ZGl2Pi8qIHR4MiAqLyB1cGRhdGUgdCBzZXQg aWQ9OTk5IHdoZXJlIGlkID0gMjs8L2Rpdj48ZGl2Pi8qIHR4MiAqLyZuYnNwO1VQREFURSAwIC0t IG5vdGhpbmcgbGVmdDwvZGl2PjwvZGl2PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+SWYgeW91 IHNldCB0aGUgc2Vjb25kIHRyYW5zYWN0aW9uIHRvICJyZXBlYXRhYmxlIHJlYWQiLCB5b3Ugd2ls bCBmaW5kIHRoYXQgdGhlIGFib3ZlIHNjZW5hcmlvIHdpbGwgcmVzdWx0IGluIGEgImNvdWxkIG5v dCBzZXJpYWxpemUgYWNjZXNzIGR1ZSB0byBjb25jdXJyZW50IHVwZGF0ZSIgZXJyb3IsIHdoaWNo LCBpbiBteSBvcGluaW9uLCBpcyBhIG1vcmUgc2FuZSByZXN1bHQuIE9uZSBvZiB0aGUgbWFueSBy ZWFzb25zIEkgdGVuZCB0byBhdm9pZCAicmVhZCBjb21taXR0ZWQiLiZuYnNwOzwvZGl2PjxkaXY+ PGJyPjwvZGl2PjxkaXY+Q2hlZXJzLDwvZGl2PjxkaXY+R3JlZzwvZGl2PjxkaXY+PGJyPjwvZGl2 PjwvZGl2Pgo8L2Rpdj48L2Jsb2NrcXVvdGU+ ------=_Part_1939_951113358.1735104728090--