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 1rC0qa-00DNX9-Ga for pgsql-bugs@arkaria.postgresql.org; Sat, 09 Dec 2023 17:10:36 +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 1rC0qZ-0025Mb-7X for pgsql-bugs@arkaria.postgresql.org; Sat, 09 Dec 2023 17:10:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBzkN-001c88-Ur for pgsql-bugs@lists.postgresql.org; Sat, 09 Dec 2023 16:00:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBzkL-009abQ-HF for pgsql-bugs@lists.postgresql.org; Sat, 09 Dec 2023 16:00:06 +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=Tt2Ov7QxguLllf0JkqX+0XV1NCNAT2LgM9Jlse+5kg4=; b=wvyjvAA4RtkK0FotOOtg8MvPF5 CQSjW/9wzVZRIjmwZUNUXOq7omPTKBRaLUXws1F35KmsMoDkzlMyruNVh5/dkBjc/PkJbXBzA0oL9 U2QW0GcYtFZREr9AAN5ECQYd7oHTeqrlXdODBbKPllTJ5MCM9AbsJ43U3MKQsP3cRwgL4hYgzI15D yXKzJ0fB+U2QLR/UTc+hd+ghDvPMGQ3HshsfWAZgPvi1NliheoYwzdE35bH86Oi7MbzRzD1cyIMUx 2ecPyZsKEbCbv4tV0wdEUUhDtZhlaYkdovgl/blUuXgPedQMvnzJTpBFtxD2loe6Vwi4DUTj/uXcu EWLndnww==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBzkL-00FlVE-0B for pgsql-bugs@lists.postgresql.org; Sat, 09 Dec 2023 16:00:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rBzkH-002I5p-TX for pgsql-bugs@lists.postgresql.org; Sat, 09 Dec 2023 16:00:03 +0000 Content-Type: multipart/mixed; boundary="===============8616748960091670042==" MIME-Version: 1.0 Subject: BUG #18238: Cross-partitition MERGE/UPDATE with delete-preventing trigger leads to incorrect memory access To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 09 Dec 2023 16:00:02 +0000 Message-ID: <18238-2f2bdc7f720180b9@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 --===============8616748960091670042== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODIzOApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTYuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0KQ1JFQVRFIFRBQkxFIHQgKGEgaW50KSBQ QVJUSVRJT04gQlkgTElTVCAoYSk7DQpDUkVBVEUgVEFCTEUgdHAxIFBBUlRJVElPTiBPRiB0IEZP UiBWQUxVRVMgSU4gKDEpOw0KQ1JFQVRFIFRBQkxFIHRwMiBQQVJUSVRJT04gT0YgdCBGT1IgVkFM VUVTIElOICgyKTsNCklOU0VSVCBJTlRPIHQgVkFMVUVTICgxKTsNCg0KQ1JFQVRFIEZVTkNUSU9O IHRmKCkgUkVUVVJOUyBUUklHR0VSIExBTkdVQUdFIHBscGdzcWwgQVMNCiAgJCQgQkVHSU4gUkVU VVJOIE5VTEw7IEVORDsgJCQ7DQoNCkNSRUFURSBUUklHR0VSIHRyIEJFRk9SRSBERUxFVEUgT04g dA0KICBGT1IgRUFDSCBST1cgRVhFQ1VURSBQUk9DRURVUkUgdGYoKTsNCg0KTUVSR0UgSU5UTyB0 IFVTSU5HIHQgc3QgT04gVFJVRSBXSEVOIE1BVENIRUQgVEhFTiBVUERBVEUgU0VUIGEgPSAyOw0K DQpleGVjdXRlZCB1bmRlciBWYWxncmluZCwgYW4gaW5jb3JyZWN0IG1lbW9yeSBhY2Nlc3MgZGV0 ZWN0ZWQ6DQoyMDIzLTEyLTA5IDEzOjMxOjM3LjE3OCBVVEN8bGF3fHJlZ3Jlc3Npb258NjU3NDQy MDcuMjlhNjcyfExPRzogIHN0YXRlbWVudDoKTUVSR0UgSU5UTyB0IFVTSU5HIHQgc3QgT04gVFJV RQ0KICAgICAgICBXSEVOIE1BVENIRUQgVEhFTiBVUERBVEUgU0VUIGEgPSAyOw0KPT0wMDowMDow MDowOC4yMDcgMjcyOTU4Nj09IENvbmRpdGlvbmFsIGp1bXAgb3IgbW92ZSBkZXBlbmRzIG9uCnVu aW5pdGlhbGlzZWQgdmFsdWUocykNCj09MDA6MDA6MDA6MDguMjA3IDI3Mjk1ODY9PSAgICBhdCAw eDQzREIzQTogSXRlbVBvaW50ZXJJc1ZhbGlkCihpdGVtcHRyLmg6ODUpDQo9PTAwOjAwOjAwOjA4 LjIwNyAyNzI5NTg2PT0gICAgYnkgMHg0M0RCM0E6IEl0ZW1Qb2ludGVyR2V0T2Zmc2V0TnVtYmVy CihpdGVtcHRyLmg6MTI2KQ0KPT0wMDowMDowMDowOC4yMDcgMjcyOTU4Nj09ICAgIGJ5IDB4NDNE QjNBOgpJdGVtUG9pbnRlckluZGljYXRlc01vdmVkUGFydGl0aW9ucyAoaXRlbXB0ci5oOjIwMCkN Cj09MDA6MDA6MDA6MDguMjA3IDI3Mjk1ODY9PSAgICBieSAweDQzREIzQTogRXhlY01lcmdlTWF0 Y2hlZAoobm9kZU1vZGlmeVRhYmxlLmM6MzA1MSkNCj09MDA6MDA6MDA6MDguMjA3IDI3Mjk1ODY9 PSAgICBieSAweDQzREU0MTogRXhlY01lcmdlCihub2RlTW9kaWZ5VGFibGUuYzoyNzYyKQ0KPT0w MDowMDowMDowOC4yMDcgMjcyOTU4Nj09ICAgIGJ5IDB4NDNFODQ2OiBFeGVjTW9kaWZ5VGFibGUK KG5vZGVNb2RpZnlUYWJsZS5jOjM4NTApDQo9PTAwOjAwOjAwOjA4LjIwNyAyNzI5NTg2PT0gICAg YnkgMHg0MTA2RkU6IEV4ZWNQcm9jTm9kZUZpcnN0CihleGVjUHJvY25vZGUuYzo0NjQpDQo9PTAw OjAwOjAwOjA4LjIwNyAyNzI5NTg2PT0gICAgYnkgMHg0MDhDQzE6IEV4ZWNQcm9jTm9kZSAoZXhl Y3V0b3IuaDoyNzMpDQo9PTAwOjAwOjAwOjA4LjIwNyAyNzI5NTg2PT0gICAgYnkgMHg0MDhDQzE6 IEV4ZWN1dGVQbGFuIChleGVjTWFpbi5jOjE2NzApDQo9PTAwOjAwOjAwOjA4LjIwNyAyNzI5NTg2 PT0gICAgYnkgMHg0MDhFODQ6IHN0YW5kYXJkX0V4ZWN1dG9yUnVuCihleGVjTWFpbi5jOjM2NSkN Cj09MDA6MDA6MDA6MDguMjA3IDI3Mjk1ODY9PSAgICBieSAweDQwOEY1RTogRXhlY3V0b3JSdW4g KGV4ZWNNYWluLmM6MzA5KQ0KPT0wMDowMDowMDowOC4yMDcgMjcyOTU4Nj09ICAgIGJ5IDB4NUYw MzJFOiBQcm9jZXNzUXVlcnkgKHBxdWVyeS5jOjE2MCkNCj09MDA6MDA6MDA6MDguMjA3IDI3Mjk1 ODY9PSAgICBieSAweDVGMEVCRDogUG9ydGFsUnVuTXVsdGkgKHBxdWVyeS5jOjEyNzcpDQo9PTAw OjAwOjAwOjA4LjIwNyAyNzI5NTg2PT0gICAgYnkgMHg1RjE0NTc6IFBvcnRhbFJ1biAocHF1ZXJ5 LmM6NzkxKQ0KPT0wMDowMDowMDowOC4yMDcgMjcyOTU4Nj09ICAgIGJ5IDB4NUVENUY0OiBleGVj X3NpbXBsZV9xdWVyeQoocG9zdGdyZXMuYzoxMjc0KQ0KPT0wMDowMDowMDowOC4yMDcgMjcyOTU4 Nj09ICAgIGJ5IDB4NUVGNTAyOiBQb3N0Z3Jlc01haW4gKHBvc3RncmVzLmM6NDYzNykNCj09MDA6 MDA6MDA6MDguMjA3IDI3Mjk1ODY9PSAgVW5pbml0aWFsaXNlZCB2YWx1ZSB3YXMgY3JlYXRlZCBi eSBhIHN0YWNrCmFsbG9jYXRpb24NCj09MDA6MDA6MDA6MDguMjA3IDI3Mjk1ODY9PSAgICBhdCAw eDNEODY2MzogR2V0VHVwbGVGb3JUcmlnZ2VyCih0cmlnZ2VyLmM6MzI4MykNCj09MDA6MDA6MDA6 MDguMjA3IDI3Mjk1ODY9PQ0KDQpXaXRob3V0IFZhbGdyaW5kLCBJIHNhdyBhIGZhaWxlZCBhc3Nl cnRpb246DQojNSAgMHgwMDAwNTYwOTUxNWI3NjZlIGluIEV4Y2VwdGlvbmFsQ29uZGl0aW9uCihj b25kaXRpb25OYW1lPWNvbmRpdGlvbk5hbWVAZW50cnk9MHg1NjA5NTE2MTMwOWEKIkl0ZW1Qb2lu dGVySXNWYWxpZChwb2ludGVyKSIsIGZpbGVOYW1lPWZpbGVOYW1lQGVudHJ5PTB4NTYwOTUxNjNk YzE4CiIuLi8uLi8uLi9zcmMvaW5jbHVkZS9zdG9yYWdlL2l0ZW1wdHIuaCIsIGxpbmVOdW1iZXI9 bGluZU51bWJlckBlbnRyeT0xMjYpCmF0IGFzc2VydC5jOjY2DQoNCmFuZA0KRVJST1I6ICBjb3Vs ZCBub3Qgb3BlbiBmaWxlICJiYXNlLzE2Mzg0LzE2MzkzLjEiICh0YXJnZXQgYmxvY2sgMzA4MTI0 NTcwMCk6CnByZXZpb3VzIHNlZ21lbnQgaXMgb25seSAxIGJsb2Nrcw0KDQpSZXByb2R1Y2VkIG9u IFJFTF8xNV9TVEFCTEUgLi4gbWFzdGVyLg0KRmlyc3QgYmFkIGNvbW1pdCBmb3IgdGhpcyBhbm9t YWx5IGlzIDkzMjFjNzljOC4KCg== --===============8616748960091670042==--