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 1lCLi7-0002wc-Uc for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Feb 2021 12:13:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lCLi6-0000SF-CN for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Feb 2021 12:13:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lCKxA-0008Qf-2y for pgsql-bugs@lists.postgresql.org; Wed, 17 Feb 2021 11:25:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lCKx8-00037i-4O for pgsql-bugs@lists.postgresql.org; Wed, 17 Feb 2021 11:25:07 +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=a0l3DrQlrTYv/gqASdRv5SrN3pEJE/Gv0Tkp1Kce8Rw=; b=7IrlnDdkIjldcrCv3uwLOVWmpr 9tncGEapTpk+NRpoBI8qVzuNV89nnk3qUfmc06xJjdyMhPTYbv5pL5QtuNMhBrU6gA/7Vx/rEUY5/ /F5XlhBPe6IlMZyX5gECa1TM1M0lemXWDwEBQR5RUGcGHmRE1HuaQ3VMiOuV12Fw9zyh2yCBHZTSL zfma+P2MA5oaJTkTuq7P+YTQSnE32E3HZtd+h36UpycvnAgaIzmhprS6QJ8kf7IxwqRdBH/LxhOtT uz68Prt7X6Ht/gucCObF0T1uAEbRIGLuciUDajC8Vzz3H6AWj6Fx4uhb35WKaCETveSmhlIRP8s5G J1VdZKDg==; 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 1lCKx6-0001Ns-DM for pgsql-bugs@lists.postgresql.org; Wed, 17 Feb 2021 11:25:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lCKx4-0006Z5-Hd for pgsql-bugs@lists.postgresql.org; Wed, 17 Feb 2021 11:25:02 +0000 Content-Type: multipart/mixed; boundary="===============5679803438206452878==" MIME-Version: 1.0 Subject: BUG #16871: Insert with wrong key field, causing later crash of DB. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: david@littleriver.ca Reply-To: david@littleriver.ca, pgsql-bugs@lists.postgresql.org Date: Wed, 17 Feb 2021 11:24:53 +0000 Message-ID: <16871-aeb175c060566417@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5679803438206452878== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjg3MQpMb2dnZWQgYnk6ICAgICAgICAgIERhdmlkIFdhZGR5CkVtYWls IGFkZHJlc3M6ICAgICAgZGF2aWRAbGl0dGxlcml2ZXIuY2EKUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Mi42Ck9wZXJhdGluZyBzeXN0ZW06ICAgbGludXgKRGVzY3JpcHRpb246ICAgICAgICAKClRoaXMg aGFzIGhhcHBlbmVkIHRocmVlIHRpbWVzIHRvIG1lIG92ZXIgdGhlIGxhc3QgZmV3IG1vbnRocy4g IERhdGFiYXNlCmNyYXNoZXMgbGF0ZXIgb24gaW5zZXJ0IHdpdGggZmF1bHR5IGNoYXJbMzJdIGtl eSBmaWVsZCwgbWF0dGhldyB2cyBwcm9wZXIKa2V5IG9mIG1hdHQuICANCg0KUG9zdGdyZVNRTCAx Mi42IChVYnVudHUgMTIuNi0wdWJ1bnR1MC4yMC4wNC4xKSBvbiB4ODZfNjQtcGMtbGludXgtZ251 LApjb21waWxlZCBieSBnY2MgKFVidW50dSA5LjMuMC0xN3VidW50dTF+MjAuMDQpIDkuMy4wLCA2 NC1iaXQNCg0KMjAyMS0wMi0xNiAxMDo1ODoxMyBBU1QgU1RBVEVNRU5UOiAgSU5TRVJUIElOVE8K Ym92aW5lbWFuYWdlbWVudC5tZWRpY2luZV9hZG1pbmlzdGVyZWQgCihib3ZpbmVfaWQsbWVkaWNp bmVfaW5kZXgsc2NoZWR1bGVkX2V2ZW50X3RpbWUsZG9zYWdlLGRvc2FnZV91bml0LGxvY2F0aW9u LG5vdGUsbWVkaWNhbF9jYXNlX2lkLHNjaGVkdWxlZF91c2VyaWQsY2FsZW5kYXJfZXZlbnRfaWQs cHJvdG9jb2xfdXVpZCx1dWlkKQpWQUxVRVMgKCQxLCQyLCQzLCQ0LCQ1LCQ2LCQ3LCQ4LCQ5LCQx MCwkMTEsJDEyKQ0KMjAyMS0wMi0xNiAxMDo1ODoxNSBBU1QgRVJST1I6ICBpbnZhbGlkIGlucHV0 IHN5bnRheCBmb3IgdHlwZSB1dWlkOiAiMiINCjIwMjEtMDItMTYgMTA6NTg6MTUgQVNUIFNUQVRF TUVOVDogIElOU0VSVCBJTlRPCmJvdmluZW1hbmFnZW1lbnQubWVkaWNpbmVfYWRtaW5pc3RlcmVk IAooYm92aW5lX2lkLG1lZGljaW5lX2luZGV4LHNjaGVkdWxlZF9ldmVudF90aW1lLGRvc2FnZSxk b3NhZ2VfdW5pdCxsb2NhdGlvbixub3RlLG1lZGljYWxfY2FzZV9pZCxzY2hlZHVsZWRfdXNlcmlk LGNhbGVuZGFyX2V2ZW50X2lkLHByb3RvY29sX3V1aWQsdXVpZCkKVkFMVUVTICgkMSwkMiwkMywk NCwkNSwkNiwkNywkOCwkOSwkMTAsJDExLCQxMikNCjIwMjEtMDItMTYgMTA6NTg6MTcgQVNUIEVS Uk9SOiAgaW52YWxpZCBpbnB1dCBzeW50YXggZm9yIHR5cGUgdXVpZDogIjIiDQoyMDIxLTAyLTE2 IDEwOjU4OjE3IEFTVCBTVEFURU1FTlQ6ICBJTlNFUlQgSU5UTwpib3ZpbmVtYW5hZ2VtZW50Lm1l ZGljaW5lX2FkbWluaXN0ZXJlZCAKKGJvdmluZV9pZCxtZWRpY2luZV9pbmRleCxzY2hlZHVsZWRf ZXZlbnRfdGltZSxkb3NhZ2UsZG9zYWdlX3VuaXQsbG9jYXRpb24sbm90ZSxtZWRpY2FsX2Nhc2Vf aWQsc2NoZWR1bGVkX3VzZXJpZCxjYWxlbmRhcl9ldmVudF9pZCxwcm90b2NvbF91dWlkLHV1aWQp ClZBTFVFUyAoJDEsJDIsJDMsJDQsJDUsJDYsJDcsJDgsJDksJDEwLCQxMSwkMTIpDQoyMDIxLTAy LTE3IDAwOjI1OjI5IEFTVCBFUlJPUjogIGluc2VydCBvciB1cGRhdGUgb24gdGFibGUgImVtcGxv eWVlX3NoaWZ0Igp2aW9sYXRlcyBmb3JlaWduIGtleSBjb25zdHJhaW50ICJlbXBsb3llZV9zaGlm dF91c2VyaWRfZmtleSINCjIwMjEtMDItMTcgMDA6MjU6MjkgQVNUIERFVEFJTDogIEtleSAodXNl cmlkKT0obWF0dGhldyAgICAgICAgICAgICAgICAgICAgICAKICApIGlzIG5vdCBwcmVzZW50IGlu IHRhYmxlICJ1c2VycyIuDQoyMDIxLTAyLTE3IDAwOjI1OjI5IEFTVCBTVEFURU1FTlQ6ICBJTlNF UlQgSU5UTyBiYXRjaC5lbXBsb3llZV9zaGlmdAoodXNlcmlkLCBkYXRlLCBzaGlmdCxtaWxraW5n X251bWJlcikgVkFMVUVTICgnbWF0dGhldycsICcyMDE5LTA5LTE0JywKJ2FtJywxKTsNCjIwMjEt MDItMTcgMDY6MjM6MDkgQVNUIExPRzogIHJlY2VpdmVkIGZhc3Qgc2h1dGRvd24gcmVxdWVzdA0K MjAyMS0wMi0xNyAwNjoyMzowOSBBU1QgTE9HOiAgYWJvcnRpbmcgYW55IGFjdGl2ZSB0cmFuc2Fj dGlvbnMNCjIwMjEtMDItMTcgMDY6MjM6MDkgQVNUIEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVj dGlvbiBkdWUgdG8gYWRtaW5pc3RyYXRvcgpjb21tYW5kDQoyMDIxLTAyLTE3IDA2OjIzOjA5IEFT VCBGQVRBTDogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gZHVlIHRvIGFkbWluaXN0cmF0b3IKY29t bWFuZA0KMjAyMS0wMi0xNyAwNjoyMzowOSBBU1QgTE9HOiAgYmFja2dyb3VuZCB3b3JrZXIgImxv Z2ljYWwgcmVwbGljYXRpb24KbGF1bmNoZXIiIChQSUQgNDUzNCkgZXhpdGVkIHdpdGggZXhpdCBj b2RlIDENCjIwMjEtMDItMTcgMDY6MjM6MDkgQVNUIEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVj dGlvbiBkdWUgdG8gYWRtaW5pc3RyYXRvcgpjb21tYW5kDQoyMDIxLTAyLTE3IDA2OjIzOjA5IEFT VCBMT0c6ICBzaHV0dGluZyBkb3duDQoyMDIxLTAyLTE3IDA2OjIzOjEwIEFTVCBMT0c6ICBkYXRh YmFzZSBzeXN0ZW0gaXMgc2h1dCBkb3duDQoyMDIxLTAyLTE3IDA3OjA5OjI5IEFTVCBMT0c6ICBz dGFydGluZyBQb3N0Z3JlU1FMIDEyLjYgKFVidW50dQoxMi42LTB1YnVudHUwLjIwLjA0LjEpIG9u IHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1CjkuMy4wLTE3dWJ1 bnR1MX4yMC4wNCkgOS4zLjAsIDY0LWJpdA0KMjAyMS0wMi0xNyAwNzowOToyOSBBU1QgTE9HOiAg bGlzdGVuaW5nIG9uIElQdjQgYWRkcmVzcyAiMC4wLjAuMCIsIHBvcnQKNTQzMg0KMjAyMS0wMi0x NyAwNzowOToyOSBBU1QgTE9HOiAgbGlzdGVuaW5nIG9uIElQdjYgYWRkcmVzcyAiOjoiLCBwb3J0 IDU0MzINCjIwMjEtMDItMTcgMDc6MDk6MjkgQVNUIExPRzogIGxpc3RlbmluZyBvbiBVbml4IHNv Y2tldAoiL3Zhci9ydW4vcG9zdGdyZXNxbC8ucy5QR1NRTC41NDMyIg0KMjAyMS0wMi0xNyAwNzow OToyOSBBU1QgTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIHdhcyBzaHV0IGRvd24gYXQgMjAyMS0wMi0x NwowNjoyMzoxMCBBU1QNCjIwMjEtMDItMTcgMDc6MDk6MjkgQVNUIExPRzogIGRhdGFiYXNlIHN5 c3RlbSBpcyByZWFkeSB0byBhY2NlcHQgY29ubmVjdGlvbnMKCg== --===============5679803438206452878==--