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 1phWkG-0005he-QP for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Mar 2023 14:25:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phWkF-0007DD-Oe for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Mar 2023 14:25:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phWLT-0008Ky-2x for pgsql-bugs@lists.postgresql.org; Wed, 29 Mar 2023 14:00:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phWLN-0007HH-SS for pgsql-bugs@lists.postgresql.org; Wed, 29 Mar 2023 14:00:08 +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=lfIQfAwnEwEnirKmwHiOjPr2ZQ5IhAP5uU7QZb/g5U4=; b=3YrYFrppCKdvuNwsuRKxT8KnUr g5QcGAZ/Rf2EqHBeWpCGzgXJozqETLLVWbvi20hATXlhtVoPGz/XyCVkAKMN/2wBzmHWujmJuaVAX 6lN/N4BwUAdNtVm1t1k3pJrFWDVpNf5fVVLOZrdpIkYNwRRlGkp6QhvQbeOs51I9TWY0EBo5UlfBi dDvPVE/FhjO5OtmF1swX5tRfVvgEnluX7CPTPtcPcNo1TONUo30oMNKM17h0Bc6XPRN3G2c8kQOjt HCeiY5hvn8Xhlcreu9Y83WrutIxFqADu+FnYbcwgGs5V/iZf2qti6s7/JlPSv7SXOTrV1ikXxO6NU ze84RdKg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phWLM-0005zP-Pe for pgsql-bugs@lists.postgresql.org; Wed, 29 Mar 2023 14:00:04 +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 1phWLK-0018M8-U7 for pgsql-bugs@lists.postgresql.org; Wed, 29 Mar 2023 14:00:02 +0000 Content-Type: multipart/mixed; boundary="===============7848603226261148729==" MIME-Version: 1.0 Subject: BUG #17877: Referencing a system column in a foreign key 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: Wed, 29 Mar 2023 14:00:01 +0000 Message-ID: <17877-4bcc658e33df6de1@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 --===============7848603226261148729== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg3NwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBxdWVyeToNCkNSRUFURSBUQUJMRSBwdCh0aWQgb2lkLCBpZCBp bnQsIFBSSU1BUlkgS0VZKHRpZCwgaWQpKTsNCkNSRUFURSBUQUJMRSBmdChpZCBpbnQsIEZPUkVJ R04gS0VZICh0YWJsZW9pZCwgaWQpIFJFRkVSRU5DRVMgcHQpOw0KDQpwcm9kdWNlcyBhIHZhbGdy aW5kLWRldGVjdGVkIGVycm9yOg0KPT0wMDowMDowMDowNC4xNzMgMzkxMTg2MD09IEludmFsaWQg cmVhZCBvZiBzaXplIDENCj09MDA6MDA6MDA6MDQuMTczIDM5MTE4NjA9PSAgICBhdCAweDNCMDMy QzogQVRBZGRGb3JlaWduS2V5Q29uc3RyYWludAoodGFibGVjbWRzLmM6OTI0MikNCj09MDA6MDA6 MDA6MDQuMTczIDM5MTE4NjA9PSAgICBieSAweDNCMjEzMjogQVRFeGVjQWRkQ29uc3RyYWludAoo dGFibGVjbWRzLmM6ODg3NSkNCj09MDA6MDA6MDA6MDQuMTczIDM5MTE4NjA9PSAgICBieSAweDNC OEQ3MzogQVRFeGVjQ21kICh0YWJsZWNtZHMuYzo1MDMxKQ0KPT0wMDowMDowMDowNC4xNzMgMzkx MTg2MD09ICAgIGJ5IDB4M0I5M0Y1OiBBVFJld3JpdGVDYXRhbG9ncwoodGFibGVjbWRzLmM6NDg3 NCkNCj09MDA6MDA6MDA6MDQuMTczIDM5MTE4NjA9PSAgICBieSAweDNCOTYxMzogQVRDb250cm9s bGVyCih0YWJsZWNtZHMuYzo0NDUxKQ0KPT0wMDowMDowMDowNC4xNzMgMzkxMTg2MD09ICAgIGJ5 IDB4M0I5NjlEOiBBbHRlclRhYmxlICh0YWJsZWNtZHMuYzo0MDk3KQ0KPT0wMDowMDowMDowNC4x NzMgMzkxMTg2MD09ICAgIGJ5IDB4NTk2QUQ2OiBQcm9jZXNzVXRpbGl0eVNsb3cKKHV0aWxpdHku YzoxMzI1KQ0KPT0wMDowMDowMDowNC4xNzMgMzkxMTg2MD09ICAgIGJ5IDB4NTk2NTg0OiBzdGFu ZGFyZF9Qcm9jZXNzVXRpbGl0eQoodXRpbGl0eS5jOjEwNzQpDQo9PTAwOjAwOjAwOjA0LjE3MyAz OTExODYwPT0gICAgYnkgMHg1OTY2NkQ6IFByb2Nlc3NVdGlsaXR5ICh1dGlsaXR5LmM6NTMwKQ0K PT0wMDowMDowMDowNC4xNzMgMzkxMTg2MD09ICAgIGJ5IDB4NTk2OTZCOiBQcm9jZXNzVXRpbGl0 eVNsb3cKKHV0aWxpdHkuYzoxMjUyKQ0KPT0wMDowMDowMDowNC4xNzMgMzkxMTg2MD09ICAgIGJ5 IDB4NTk2NTg0OiBzdGFuZGFyZF9Qcm9jZXNzVXRpbGl0eQoodXRpbGl0eS5jOjEwNzQpDQo9PTAw OjAwOjAwOjA0LjE3MyAzOTExODYwPT0gICAgYnkgMHg1OTY2NkQ6IFByb2Nlc3NVdGlsaXR5ICh1 dGlsaXR5LmM6NTMwKQ0KPT0wMDowMDowMDowNC4xNzMgMzkxMTg2MD09ICBBZGRyZXNzIDB4NGJm NTEyZGMgaXMgMTEzLDUxNiBieXRlcyBpbnNpZGUgYQpyZWNlbnRseSByZS1hbGxvY2F0ZWQgYmxv Y2sgb2Ygc2l6ZSA1MjQsMjg4IGFsbG9jJ2QNCi4uLg0KMjAyMy0wMy0yOSAxNjowMDoyOS4wNjgg TVNLfHx8NjQyNDM2NjkuM2JiMDZlfExPRzogIHNlcnZlciBwcm9jZXNzIChQSUQKMzkxMTg2MCkg ZXhpdGVkIHdpdGggZXhpdCBjb2RlIDENCjIwMjMtMDMtMjkgMTY6MDA6MjkuMDY4IE1TS3x8fDY0 MjQzNjY5LjNiYjA2ZXxERVRBSUw6ICBGYWlsZWQgcHJvY2VzcyB3YXMKcnVubmluZzogQ1JFQVRF IFRBQkxFIGZ0KGlkIGludCwgRk9SRUlHTiBLRVkgKHRhYmxlb2lkLCBpZCkgUkVGRVJFTkNFUwpw dCk7DQoNCkhlcmUgaW4gQVRBZGRGb3JlaWduS2V5Q29uc3RyYWludCgpOg0KCS8qDQoJICogQ2hl Y2sgc29tZSB0aGluZ3MgZm9yIGdlbmVyYXRlZCBjb2x1bW5zLg0KCSAqLw0KCWZvciAoaSA9IDA7 IGkgPCBudW1ma3M7IGkrKykNCgl7DQoJCWNoYXIJCWF0dGdlbmVyYXRlZCA9IFR1cGxlRGVzY0F0 dHIoUmVsYXRpb25HZXREZXNjcihyZWwpLCBma2F0dG51bVtpXSAtCjEpLT5hdHRnZW5lcmF0ZWQ7 DQoNCgkJaWYgKGF0dGdlbmVyYXRlZCkNCi4uLg0Kd2UgaGF2ZSBma2F0dG51bVtpXSA9IC02IGZv ciB0aGUgYXR0cmlidXRlICJ0YWJsZW9pZCIsIGJ1dCBUdXBsZURlc2NBdHRyKCkNCmNhbid0IGhh bmRsZSBzeXN0ZW0gYXR0cmlidXRlcy4NCg0KSSd2ZSBsb29rZWQgYXQgZmMyMmI2NjIzIGFuZCBm b3VuZCBubyBvdGhlciBUdXBsZURlc2NBdHRyKCkgY2FsbHMgd2hlcmUNCmF0dG51bSBjYW4gYmUg bmVnYXRpdmUuDQoNClRob3VnaCBtYXliZSBpdCBpcyBhIG5vbnNlbnNlIHRvIHVzZSB0YWJsZW9p ZCBpbiBhIHN1Y2ggd2F5Lg0KQnV0IGlmIG5vdCwgc29tZW9uZSBjYW4gdHJ5IHRvIG1vdmUgb24g d2l0aG91dCB2YWxncmluZDoNCkNSRUFURSBUQUJMRSBwdCh0aWQgb2lkLCBpZCBpbnQsIFBSSU1B UlkgS0VZKHRpZCwgaWQpKTsNCkNSRUFURSBUQUJMRSBmdChpZCBpbnQsIEZPUkVJR04gS0VZICh0 YWJsZW9pZCwgaWQpIFJFRkVSRU5DRVMgcHQpOw0KSU5TRVJUIElOVE8gcHQgU0VMRUNUIG9pZCwg MSBGUk9NIHBnX2NsYXNzIFdIRVJFIHJlbG5hbWUgPSAnZnQnOw0KSU5TRVJUIElOVE8gZnQgVkFM VUVTKDEpOw0KDQphbmQgZ2V0Og0KLi4uDQojNSAgMHgwMDAwNTU3NDg1MDM3MjM4IGluIEV4Y2Vw dGlvbmFsQ29uZGl0aW9uIChjb25kaXRpb25OYW1lPTB4NTU3NDg1MjQ1ZjE4CiJhdHRudW0gPiAw IiwgDQogICAgZXJyb3JUeXBlPTB4NTU3NDg1MjQ1ZjBjICJCYWRBcmd1bWVudCIsIA0KICAgIGZp bGVOYW1lPTB4NTU3NDg1MjQ1ZWUwICIuLi8uLi8uLi8uLi9zcmMvaW5jbHVkZS9leGVjdXRvci90 dXB0YWJsZS5oIiwKbGluZU51bWJlcj0zNjkpIGF0IGFzc2VydC5jOjY5DQojNiAgMHgwMDAwNTU3 NDg0ZjkzODQ2IGluIHNsb3RfYXR0aXNudWxsIChzbG90PTB4NTU3NDg1ZTY0NDIwLCBhdHRudW09 LTYpDQogICAgYXQgLi4vLi4vLi4vLi4vc3JjL2luY2x1ZGUvZXhlY3V0b3IvdHVwdGFibGUuaDoz NjkNCiM3ICAweDAwMDA1NTc0ODRmOTkxM2MgaW4gcmlfTnVsbENoZWNrICh0dXBEZXNjPTB4N2Zh Mjk3MzYxYWE4LApzbG90PTB4NTU3NDg1ZTY0NDIwLCANCiAgICByaWluZm89MHg1NTc0ODVlN2Fi ODAsIHJlbF9pc19waz1mYWxzZSkgYXQgcmlfdHJpZ2dlcnMuYzoyNjQ4DQojOCAgMHgwMDAwNTU3 NDg0ZjkzYmFkIGluIFJJX0ZLZXlfY2hlY2sgKHRyaWdkYXRhPTB4N2ZmZmM2YWM4OTgwKSBhdApy aV90cmlnZ2Vycy5jOjI4MA0KIzkgIDB4MDAwMDU1NzQ4NGY5NDBkYiBpbiBSSV9GS2V5X2NoZWNr X2lucyAoZmNpbmZvPTB4N2ZmZmM2YWM4N2MwKSBhdApyaV90cmlnZ2Vycy5jOjQzNA0KIzEwIDB4 MDAwMDU1NzQ4NGJiOWJhZiBpbiBFeGVjQ2FsbFRyaWdnZXJGdW5jICh0cmlnZGF0YT0weDdmZmZj NmFjODk4MCwKdGdpbmR4PTAsIGZpbmZvPTB4NTU3NDg1ZTYzODc4LCANCiAgICBpbnN0cj0weDAs IHBlcl90dXBsZV9jb250ZXh0PTB4NTU3NDg1ZTcwZjYwKSBhdCB0cmlnZ2VyLmM6MjQzNQ0KIzEx IDB4MDAwMDU1NzQ4NGJiZDY1MyBpbiBBZnRlclRyaWdnZXJFeGVjdXRlIChlc3RhdGU9MHg1NTc0 ODVlNjJmZjAsCmV2ZW50PTB4NTU3NDg1ZTZmMDkwLCANCiAgICByZWxJbmZvPTB4NTU3NDg1ZTYz NDgwLCBzcmNfcmVsSW5mbz0weDU1NzQ4NWU2MzQ4MCwKZHN0X3JlbEluZm89MHg1NTc0ODVlNjM0 ODAsIA0KICAgIHRyaWdkZXNjPTB4NTU3NDg1ZTYzNjk4LCBmaW5mbz0weDU1NzQ4NWU2Mzg3OCwg aW5zdHI9MHgwLApwZXJfdHVwbGVfY29udGV4dD0weDU1NzQ4NWU3MGY2MCwgDQogICAgdHJpZ190 dXBsZV9zbG90MT0weDAsIHRyaWdfdHVwbGVfc2xvdDI9MHgwKSBhdCB0cmlnZ2VyLmM6NDU0Ng0K IzEyIDB4MDAwMDU1NzQ4NGJiZGM2OCBpbiBhZnRlclRyaWdnZXJJbnZva2VFdmVudHMgKGV2ZW50 cz0weDU1NzQ4NWQ4YmRiMCwKZmlyaW5nX2lkPTEsIA0KICAgIGVzdGF0ZT0weDU1NzQ4NWU2MmZm MCwgZGVsZXRlX29rPWZhbHNlKSBhdCB0cmlnZ2VyLmM6NDc4NQ0KIzEzIDB4MDAwMDU1NzQ4NGJi ZTViNSBpbiBBZnRlclRyaWdnZXJFbmRRdWVyeSAoZXN0YXRlPTB4NTU3NDg1ZTYyZmYwKSBhdAp0 cmlnZ2VyLmM6NTE0MA0KIzE0IDB4MDAwMDU1NzQ4NGJmNjk2YiBpbiBzdGFuZGFyZF9FeGVjdXRv ckZpbmlzaCAocXVlcnlEZXNjPTB4NTU3NDg1ZTUzYzYwKQphdCBleGVjTWFpbi5jOjQzOA0KIzE1 IDB4MDAwMDU1NzQ4NGJmNjgyMSBpbiBFeGVjdXRvckZpbmlzaCAocXVlcnlEZXNjPTB4NTU3NDg1 ZTUzYzYwKSBhdApleGVjTWFpbi5jOjQwNg0KIzE2IDB4MDAwMDU1NzQ4NGU2ZjY0OSBpbiBQcm9j ZXNzUXVlcnkgKHBsYW49MHg1NTc0ODVlNDg3OTgsIA0KICAgIHNvdXJjZVRleHQ9MHg1NTc0ODVk Njg4NzAgIklOU0VSVCBJTlRPIGZ0IFZBTFVFUygxKTsiLCBwYXJhbXM9MHgwLApxdWVyeUVudj0w eDAsIGRlc3Q9MHg1NTc0ODVlNDg4ODgsIA0KICAgIHFjPTB4N2ZmZmM2YWM4ZTEwKSBhdCBwcXVl cnkuYzoxOTMKCg== --===============7848603226261148729==--