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 1kIeFA-0002b3-2T for pgsql-bugs@arkaria.postgresql.org; Wed, 16 Sep 2020 20:41:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kIeF8-0000Tm-Jn for pgsql-bugs@arkaria.postgresql.org; Wed, 16 Sep 2020 20:41:30 +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 1kIe9y-0007Jv-7X for pgsql-bugs@lists.postgresql.org; Wed, 16 Sep 2020 20:36:10 +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 1kIe9t-00017l-Eb for pgsql-bugs@lists.postgresql.org; Wed, 16 Sep 2020 20:36:09 +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=ULZ/o8ClVP690ITbJW2nQsneeukhvQDtk5VUd0keFlE=; b=qDHQHX0TYZGecH4rZJISCpQQIR 3DiNZ1j3wx+OkThoEm0hVRAUd96gY5VDK2VNvReIHctFfzVs1e0BUhq+9YTKPU5faFXN6CT5iykxM oUqIbn0jgl+L5fKPCVkyhpekMZNwuc1HVfXHgW67GGvZCngcOAhhHe9S3etwXD/gVeb+A2xqilNtC c7eo9cRSZx+rPfJuUWExb7PsqV8jZImUYIE2PYTai0lJ7FqxBHfU4FlwTUTwyRoK8u4NHQmuF2u/M 0EkkSxpvOz6e1THVRfMNmfmmVviZ+x6PPPrIz2IGmeFJNWIi1WPlDXXkT17TrHXqlGy4OFZT87dAa WSm5yN1w==; 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 1kIe9s-0000Lz-Pr for pgsql-bugs@lists.postgresql.org; Wed, 16 Sep 2020 20:36: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 1kIe9q-0005Al-F4 for pgsql-bugs@lists.postgresql.org; Wed, 16 Sep 2020 20:36:02 +0000 Content-Type: multipart/mixed; boundary="===============0736282451286431518==" MIME-Version: 1.0 Subject: BUG #16621: Unexpected Foreign Key Constraint Violation when Creating New Child Partition To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dylan@quorum.us Reply-To: dylan@quorum.us, pgsql-bugs@lists.postgresql.org Date: Wed, 16 Sep 2020 20:35:33 +0000 Message-ID: <16621-926cf657e4315eab@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 --===============0736282451286431518== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYyMQpMb2dnZWQgYnk6ICAgICAgICAgIER5bGFuIE1hbm4KRW1haWwg YWRkcmVzczogICAgICBkeWxhbkBxdW9ydW0udXMKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi40Ck9w ZXJhdGluZyBzeXN0ZW06ICAgcG9zdGdyZXM6MTIuNCBEb2NrZXIgQ29udGFpbmVyIChNYWMgT1Mp CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIZWxsbywNCg0KSSBhbSBhdHRlbXB0aW5nIHRvIGFkZCBh IHBhcnRpdGlvbiB0byBhbiBleGlzdGluZyB0YWJsZSB0aGF0IGlzIHJlZmVyZW5jZWQKYnkgYSBm b3JlaWduIGtleSwgYnV0IEkgYW0gZ2V0dGluZyBhIGNvbnN0cmFpbnQgdmlvbGF0aW9uIHdoZW4g dHJ5aW5nIHRvCm1vdmUgZGF0YSBpbnRvIHRoZSBuZXcgcGFydGl0aW9uLiAgSSdtIG5vdCBzdXJl IGlmIHRoaXMgaXMgZXhwZWN0ZWQKYmVoYXZpb3IsIGJ1dCBJIHdhcyB1bmFibGUgdG8gZmluZCBh bnkgZG9jdW1lbnRhdGlvbiBhYm91dCBpdCwgc28gbXkKYXNzdW1wdGlvbiBpcyB0aGF0IGl0J3Mg ZWl0aGVyIGFuIHVuZG9jdW1lbnRlZCBsaW1pdGF0aW9uIG9yIGEgYnVnLiAgSSBoYXZlCmEgd29y a2Fyb3VuZCAodGhlIHRoaXJkIHRyYW5zYWN0aW9uIHNob3duIGJlbG93KSwgd2hpY2ggaW52b2x2 ZXMgZHJvcHBpbmcKYWxsIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnRzIHRvIHRoZSBwYXJ0aXRpb25l ZCB0YWJsZSBiZWZvcmUgaW5zZXJ0aW5nIHRoZQpkYXRhIGFuZCBhZGRpbmcgdGhlbSBiYWNrIGFm dGVyIGluc2VydGluZyB0aGUgZGF0YSwgYnV0IG15IHVuZGVyc3RhbmRpbmcgb2YKZGVmZXJyZWQg Y29uc3RyYWludHMgaXMgdGhhdCB0aGV5IGFyZSB2YWxpZGF0ZWQgYXQgdGhlIGVuZCBvZiBhIHRy YW5zYWN0aW9uLApzbyB0aGlzIHNob3VsZG4ndCBiZSBuZWNlc3NhcnkuDQoNCkJlbG93IGlzIGEg bWluaW1hbCB3b3JraW5nIGV4YW1wbGUsIHRlc3RlZCBvbiBib3RoIDEyLjIgYW5kIDEyLjQuDQoN Ci0tIENyZWF0ZSBpbml0aWFsIHNjaGVtYSBhbmQgZGF0YQ0KQkVHSU47DQpDUkVBVEUgVEFCTEUg dG9fdGFibGUoDQogICAgaWQgaW50LA0KICAgIHBhcnRpdGlvbl9rZXkgaW50LA0KICAgIFBSSU1B UlkgS0VZIChpZCwgcGFydGl0aW9uX2tleSkNCikgUEFSVElUSU9OIEJZIExJU1QgKHBhcnRpdGlv bl9rZXkpOw0KQ1JFQVRFIFRBQkxFIHRvX3RhYmxlX19kZWZhdWx0IFBBUlRJVElPTiBPRiB0b190 YWJsZSBERUZBVUxUOw0KSU5TRVJUIElOVE8gdG9fdGFibGVfX2RlZmF1bHQgVkFMVUVTICgxLCAx KSwgKDIsIDIpOw0KDQpDUkVBVEUgVEFCTEUgZnJvbV90YWJsZSgNCiAgICBpZCBpbnQsDQogICAg cGFydGl0aW9uX2tleSBpbnQsDQogICAgdG9faWQgaW50LA0KICAgIEZPUkVJR04gS0VZICh0b19p ZCwgcGFydGl0aW9uX2tleSkgUkVGRVJFTkNFUyB0b190YWJsZSAoaWQsCnBhcnRpdGlvbl9rZXkp IERFRkVSUkFCTEUgSU5JVElBTExZIERFRkVSUkVEDQopOw0KSU5TRVJUIElOVE8gZnJvbV90YWJs ZSBWQUxVRVMgKDEsIDEsIDEpLCAoMiwgMiwgMik7DQpDT01NSVQ7DQoNCi0tIEFkZCBhIG5ldyBw YXJ0aXRpb24gdG8gdG9fdGFibGUsIG1pZ3JhdGluZyBkYXRhIGZyb20gdGhlIGRlZmF1bHQKcGFy dGl0aW9uLiAgVGhlIGZvbGxvd2luZyBjb21tYW5kIGZhaWxzIG9uIENPTU1JVCB3aXRoOg0KLS0g RVJST1I6ICB1cGRhdGUgb3IgZGVsZXRlIG9uIHRhYmxlICJ0b190YWJsZV9fZGVmYXVsdCIgdmlv bGF0ZXMgZm9yZWlnbgprZXkgY29uc3RyYWludCAiZnJvbV90YWJsZV90b19pZF9wYXJ0aXRpb25f a2V5X2ZrZXkxIiBvbiB0YWJsZQoiZnJvbV90YWJsZSINCi0tIERFVEFJTDogIEtleSAoaWQsIHBh cnRpdGlvbl9rZXkpPSgxLCAxKSBpcyBzdGlsbCByZWZlcmVuY2VkIGZyb20gdGFibGUKImZyb21f dGFibGUiLg0KQkVHSU47DQpDUkVBVEUgVEFCTEUgdG9fdGFibGVfXzEgKCBMSUtFIHRvX3RhYmxl ICk7DQpBTFRFUiBUQUJMRSB0b190YWJsZV9fMSBBREQgQ09OU1RSQUlOVCB0b190YWJsZV9fcGFy dGl0aW9uXzFfX2NoZWNrIENIRUNLCihwYXJ0aXRpb25fa2V5ID0gMSk7DQoNCldJVEggbW92ZV90 dXBsZXMgQVMgKA0KICAgIERFTEVURSBGUk9NIHRvX3RhYmxlX19kZWZhdWx0DQogICAgV0hFUkUg cGFydGl0aW9uX2tleSA9IDENCiAgICBSRVRVUk5JTkcgKg0KKSBJTlNFUlQgSU5UTyB0b190YWJs ZV9fMSAoDQogICAgU0VMRUNUICoNCiAgICBGUk9NIG1vdmVfdHVwbGVzDQopOw0KDQpBTFRFUiBU QUJMRSB0b190YWJsZSBBVFRBQ0ggUEFSVElUSU9OIHRvX3RhYmxlX18xIEZPUiBWQUxVRVMgSU4g KDEpOw0KQ09NTUlUOw0KDQoNCi0tIFRoZSBmb2xsb3dpbmcgY29kZSB3b3JrcyBhcyBleHBlY3Rl ZCwgYnV0IHJlcXVpcmVzIGRyb3BwaW5nIGFuZApyZWNyZWF0aW5nIGFsbCBmb3JlaWduIGtleSBj b25zdHJhaW50cw0KQkVHSU47DQpBTFRFUiBUQUJMRSBmcm9tX3RhYmxlIERST1AgQ09OU1RSQUlO VApmcm9tX3RhYmxlX3RvX2lkX3BhcnRpdGlvbl9rZXlfZmtleTsNCkNSRUFURSBUQUJMRSB0b190 YWJsZV9fMSAoIExJS0UgdG9fdGFibGUgKTsNCkFMVEVSIFRBQkxFIHRvX3RhYmxlX18xIEFERCBD T05TVFJBSU5UIHRvX3RhYmxlX19wYXJ0aXRpb25fMV9fY2hlY2sgQ0hFQ0sKKHBhcnRpdGlvbl9r ZXkgPSAxKTsNCg0KV0lUSCBtb3ZlX3R1cGxlcyBBUyAoDQogICAgREVMRVRFIEZST00gdG9fdGFi bGVfX2RlZmF1bHQNCiAgICBXSEVSRSBwYXJ0aXRpb25fa2V5ID0gMQ0KICAgIFJFVFVSTklORyAq DQopIElOU0VSVCBJTlRPIHRvX3RhYmxlX18xICgNCiAgICBTRUxFQ1QgKg0KICAgIEZST00gbW92 ZV90dXBsZXMNCik7DQoNCkFMVEVSIFRBQkxFIHRvX3RhYmxlIEFUVEFDSCBQQVJUSVRJT04gdG9f dGFibGVfXzEgRk9SIFZBTFVFUyBJTiAoMSk7DQpBTFRFUiBUQUJMRSBmcm9tX3RhYmxlIEFERCBD T05TVFJBSU5UIGZyb21fdGFibGVfdG9faWRfcGFydGl0aW9uX2tleV9ma2V5CkZPUkVJR04gS0VZ ICh0b19pZCwgcGFydGl0aW9uX2tleSkgUkVGRVJFTkNFUyB0b190YWJsZSAoaWQsIHBhcnRpdGlv bl9rZXkpCkRFRkVSUkFCTEUgSU5JVElBTExZIERFRkVSUkVEOw0KQ09NTUlUOw0KDQpUaGFua3Mg aW4gYWR2YW5jZSwNCkR5bGFuCgo= --===============0736282451286431518==--