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 1lGq4E-0006LQ-32 for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Mar 2021 21:27:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lGq4C-0003Lf-Oa for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Mar 2021 21:27:00 +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 1lGlzk-0006B7-5q for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 17:06:08 +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 1lGlzf-0004hv-UF for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 17:06: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=imeksWOnC33XV5cyezCYDEuG/rGSNsW2UG3exbQIN8w=; b=FQbmpHzanp9pk85Gvek9AT2b7A R1Z64sloGeRAci1rK/8notSS+VJ62pPx0EuwFTzwpweybLqcEQkoHooM7HMLokbYQsQO7VHQ1VLf6 ieWdK9HIMN0RClztcBeGbnc0yUzOh3UmBumB/scxvQkhQmXz2a47pmG6rh98QQYzShw6onjYcr4U2 x+tNd75e2i6r8FG19a1OxZlpCDvJhpyOyEZWjc85pSncA88iRJ2pbylZSSvUWcBeEyLhxE3HeiXSf zEdPVN/MvZgjTyPO6r7vMQIRtJvzAyX2evX3ksjs/BImdcDlSnfszrWeiMxQW/atYAJ/N6kKrHZg/ p+5BSIZg==; 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 1lGlzf-0007zv-I3 for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 17:06:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lGlze-00065o-E4 for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 17:06:02 +0000 Content-Type: multipart/mixed; boundary="===============6997772610799329777==" MIME-Version: 1.0 Subject: BUG #16908: Postgres (12) allows you (re)-attach partitions that violate Foreign Key constraints? To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: alex.stilwell@macquarie.com Reply-To: alex.stilwell@macquarie.com, pgsql-bugs@lists.postgresql.org Date: Mon, 01 Mar 2021 17:06:01 +0000 Message-ID: <16908-5b53ef9b31fb94c9@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 --===============6997772610799329777== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjkwOApMb2dnZWQgYnk6ICAgICAgICAgIGFsZXggc3RpbHdlbGwKRW1h aWwgYWRkcmVzczogICAgICBhbGV4LnN0aWx3ZWxsQG1hY3F1YXJpZS5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMi42Ck9wZXJhdGluZyBzeXN0ZW06ICAgVW5peApEZXNjcmlwdGlvbjogICAgICAg IAoKTGV0cyBzYXkgSSBoYXZlIHRoZSBmb2xsb3dpbmcgUG9zdGdyZXNTUUwgVGFibGVzOg0KDQpg YGANCkNSRUFURSBUQUJMRSBtZWFzdXJlbWVudA0KKA0KICAgIGNpdHlfaWQgICBCSUdTRVJJQUwg bm90IG51bGwsDQogICAgbG9nZGF0ZSAgIGRhdGUgbm90IG51bGwsDQogICAgcGVha3RlbXAgIGlu dCwNCiAgICB1bml0c2FsZXMgaW50DQopIFBBUlRJVElPTiBCWSBSQU5HRSAobG9nZGF0ZSk7DQoN CkFMVEVSIFRBQkxFIG1lYXN1cmVtZW50DQogICAgQUREIFBSSU1BUlkgS0VZIChjaXR5X2lkLCBs b2dkYXRlKTsNCg0KQ1JFQVRFIFRBQkxFIG1lYXN1cmVtZW50X2RyaWxsZG93bg0KKA0KICAgIG1l YXN1cmVtZW50X2lkIEJJR0lOVCAgTk9UIE5VTEwsDQogICAgbG9nZGF0ZSAgICAgICAgZGF0ZSBu b3QgbnVsbCwNCiAgICBpbmZvX29uZSAgICAgICBpbnQsDQogICAgaW5mb190d28gICAgICBpbnQs DQogICBDT05TVFJBSU5UIG1lYXN1cmVtZW50X2RyaWxsZG93bg0KICAgICAgRk9SRUlHTiBLRVko bWVhc3VyZW1lbnRfaWQsIGxvZ2RhdGUpDQoJICBSRUZFUkVOQ0VTIG1lYXN1cmVtZW50KGNpdHlf aWQsIGxvZ2RhdGUpDQopIFBBUlRJVElPTiBCWSBSQU5HRShsb2dkYXRlKTsNCmBgYA0KDQpJIGNy ZWF0ZSAyIHBhcnRpdGlvbnMgb24gZWFjaCB0YWJsZToNCg0KYGBgDQpDUkVBVEUgVEFCTEUgbWVh c3VyZW1lbnRfeTIwMDZtMDIgUEFSVElUSU9OIE9GIG1lYXN1cmVtZW50DQogICAgRk9SIFZBTFVF UyBGUk9NICgnMjAwNi0wMi0wMScpIFRPICgnMjAwNi0wMy0wMScpOw0KDQpDUkVBVEUgVEFCTEUg bWVhc3VyZW1lbnRfeTIwMDZtMDMgUEFSVElUSU9OIE9GIG1lYXN1cmVtZW50DQogICAgRk9SIFZB TFVFUyBGUk9NICgnMjAwNi0wMy0wMScpIFRPICgnMjAwNi0wNC0wMScpOw0KDQpDUkVBVEUgVEFC TEUgbWVhc3VyZW1lbnRfZHJpbGxkb3duX3kyMDA2bTAyIFBBUlRJVElPTiBPRgptZWFzdXJlbWVu dF9kcmlsbGRvd24NCiAgICBGT1IgVkFMVUVTIEZST00gKCcyMDA2LTAyLTAxJykgVE8gKCcyMDA2 LTAzLTAxJyk7DQoNCkNSRUFURSBUQUJMRSBtZWFzdXJlbWVudF9kcmlsbGRvd25feTIwMDZtMDMg UEFSVElUSU9OIE9GCm1lYXN1cmVtZW50X2RyaWxsZG93bg0KICAgIEZPUiBWQUxVRVMgRlJPTSAo JzIwMDYtMDMtMDEnKSBUTyAoJzIwMDYtMDQtMDEnKTsNCmBgYA0KDQpJIHRoZW4gaW5zZXJ0IHNv bWUgc2ltcGxlIGRhdGEgaW50byBlYWNoIHRhYmxlIHdpdGhpbiB0aGUgcGFydGl0aW9ucyBJIG1h ZGUKYmVmb3JlOg0KDQpgYGANCklOU0VSVCBJTlRPIG1lYXN1cmVtZW50DQpWQUxVRVMgKDEwLCAn MjAwNi0wMi0wNCcsIDM1LCAzNSk7DQoNCklOU0VSVCBJTlRPIG1lYXN1cmVtZW50DQpWQUxVRVMg KDExLCAnMjAwNi0wMi0wNycsIDM1LCAzNSk7DQoNCklOU0VSVCBJTlRPIG1lYXN1cmVtZW50DQpW QUxVRVMgKDE1LCAnMjAwNi0wMy0wNCcsIDMyMiwgMzMzNSk7DQoNCklOU0VSVCBJTlRPIG1lYXN1 cmVtZW50X2RyaWxsZG93bg0KVkFMVUVTICgxMCwgJzIwMDYtMDItMDQnLCA2NiwgNjYpOw0KDQpJ TlNFUlQgSU5UTyBtZWFzdXJlbWVudF9kcmlsbGRvd24NClZBTFVFUyAoMTUsICcyMDA2LTAzLTA0 JywgNzcsIDc3KTsNCmBgYA0KDQpJIG5vdyBkZXRhY2ggdGhlIEZlYnJ1YXJ5IFBhcnRpdGlvbiBp biBib3RoIG1lYXN1cmVtZW50IGFuZAptZWFzdXJlbWVudF9kcmlsbGRvd246DQoNCmBgYA0KQUxU RVIgVEFCTEUgbWVhc3VyZW1lbnRfZHJpbGxkb3duDQogICAgREVUQUNIIFBBUlRJVElPTiBtZWFz dXJlbWVudF9kcmlsbGRvd25feTIwMDZtMDI7DQoNCkFMVEVSIFRBQkxFIG1lYXN1cmVtZW50DQog ICAgREVUQUNIIFBBUlRJVElPTiBtZWFzdXJlbWVudF95MjAwNm0wMjsNCmBgYA0KDQpJIGNhbiB0 aGVuIHJlYXR0YWNoIHRoZSBwYXJ0aXRpb24gb2YgbWVhc3VyZW1lbnRfZHJpbGxkb3duX3kyMDA2 bTAyIHdoaWxzdAp0aGUgbWVhc3VyZW1lbnQgcGFydGl0aW9uIGlzIHN0aWxsIGRldGFjaGVkIC0g dGh1cyB2aW9sYXRpbmcgdGhlIEZLCmNvbnN0cmFpbnQgb24gdGhlIG1lYXN1cmVtZW50X2RyaWxs ZG93biB0YWJsZToNCg0KYGBgDQpBTFRFUiBUQUJMRSBtZWFzdXJlbWVudF9kcmlsbGRvd24NCiAg ICBBVFRBQ0ggUEFSVElUSU9OIG1lYXN1cmVtZW50X2RyaWxsZG93bl95MjAwNm0wMg0KICAgICAg ICBGT1IgVkFMVUVTIEZST00gKCcyMDA2LTAyLTAxJykgVE8gKCcyMDA2LTAzLTAxJyk7DQpgYGAN Cg0KVGhpcyByZXN1bHRzIGluIGEgc2l0dWF0aW9uIHdoZXJlIHRoZSBtZWFzdXJlbWVudF9kcmls bGRvd24gdGFibGUgY29udGFpbnMKZGF0YSB3aXRoIHRoZSBmb3JlaWduIGtleSBjb25zdHJhaW50 IG5vdCBlbmZvcmNlZCAtIA0KDQpgYGANCnNlbGVjdCAqIGZyb20gbWVhc3VyZW1lbnQ7DQpgYGAN Cg0KfCBjaXR5X2lkIHwgbG9nZGF0ZSB8IHBlYWt0ZW1wIHwgdW5pdHNhbGVzIHwNCnw6LS0tLSB8 Oi0tLS0tLTp8IC0tLS0tOnwgLS0tLS06fA0KfCAxNXwgMjAwNi0wMy0wNCB8IDMyMiB8IDMzMzUg fA0KDQpgYGANCnNlbGVjdCAqIGZyb20gbWVhc3VyZW1lbnRfZHJpbGxkb3duOw0KYGBgDQoNCnwg bWVhc3VyZW1lbnRfaWQgfCBsb2dkYXRlIHwgaW5mb19vbmUgfCBpbmZvX3R3byB8DQp8Oi0tLS0g fDotLS0tLS06fCAtLS0tLTp8IC0tLS0tOnwNCnwgMTB8IDIwMDYtMDItMDQgfCA2NiB8IDY2IHwN CnwgMTV8IDIwMDYtMDMtMDQgfCA3NyB8IDc3IHwNCg0KU28gdGhlICcxMCcgcm93IHdoaWNoIGlz IGluIHRoZSBGZWIgMjAwNiBwYXJ0aXRpb24gaXMgbm93IGhhcHBpbHkgKGFjY29yZGluZwp0byB0 aGlzKSwgdmlvbGF0aW5nIHRoZSBGSyBjb25zdHJhaW50LiBJbmRlZWQsIGlmIEkgdHJ5IHRvIGFk ZCBhbiBhZGRpdGlvbmFsCnJlY29yZCB0byBtZWFzdXJlbWVudF9kcmlsbGRvd24sIHRvIHJlZmVy ZW5jZSB0aGUgJzExJyB2YWx1ZSBpbiBtZWFzdXJlbWVudAoodGhhdCB3ZSBpbnNlcnRlZCBhbmQg ZGV0YWNoZWQpIC0NCg0KYGBgIA0KSU5TRVJUIElOVE8gbWVhc3VyZW1lbnRfZHJpbGxkb3duDQpW QUxVRVMgKDExLCAnMjAwNi0wMi0wNycsIDg4LCA4OCk7DQogYGBgDQoNClRoaXMgZmFpbHMgKGFz IGV4cGVjdGVkKSB3aXRoOg0KDQpbMjM1MDNdIEVSUk9SOiBpbnNlcnQgb3IgdXBkYXRlIG9uIHRh YmxlICJtZWFzdXJlbWVudF9kcmlsbGRvd25feTIwMDZtMDIiCnZpb2xhdGVzIGZvcmVpZ24ga2V5 IGNvbnN0cmFpbnQgIm1lYXN1cmVtZW50X2RyaWxsZG93biIgRGV0YWlsOiBLZXkKKG1lYXN1cmVt ZW50X2lkLCBsb2dkYXRlKT0oMTEsIDIwMDYtMDItMDcpIGlzIG5vdCBwcmVzZW50IGluIHRhYmxl CiJtZWFzdXJlbWVudCIuDQoNClNvIHRoZSBxdWVzdGlvbiBJIGhhdmUgaXMsIGlzIHRoaXMgYnkg ZGVzaWduPyBJZiBJIHRyeSB0byBkZXRhY2ggYSBwYXJ0aXRpb24KZnJvbSBtZWFzdXJlbWVudCwg d2hpbHN0IHRoZSBGSyBpbiBtZWFzdXJlbWVudF9kcmlsbGRvd24gZXhpc3RzLCB0aGVuIGl0Cndv dWxkIG5vdCBsZXQgbWUuIEhvd2V2ZXIsIGl0IHNlZW1zIGl0IGlzIHBvc3NpYmxlIHRvIGRldGFj aCB0aGUgRksKcmVsYXRpb25zaGlwLCByZW1vdmUgdGhlIHBhcmVudCBhbmQgdGhlbiByZWpvaW4g dGhlIG1lYXN1cm1lbnRfZHJpbGxkb3duCnBhcnRpdGlvbj8gU2hvdWxkIHRoZSBGSyBjb25zdHJh aW50cyBiZSByZS1jaGVja2VkIHByaW9yIHRvIGF0dGFjaGluZyBhCnBhcnRpdGlvbj8NCg0KSW50 ZXJlc3RpbmdseSwgaWYgSSB3ZXJlIHRvIHRyeSBhbmQgcmVtb3ZlIHRoZSBGZWJydWFyeSBwYXJ0 aXRpb24gZGlyZWN0bHkKZnJvbSBtZWFzdXJlbWVudCAod2l0aG91dCB0b3VjaGluZyB0aGUgZHJp bGxkb3duIHRhYmxlKSwgaXQgd291bGQgZmFpbCAtCnNheWluZyB0aGF0IGl0IHdvdWxkIHZpb2xh dGUgdGhlIEZLIGNvbnN0YWludHMuDQoNCkJlc3QsDQpBbGV4Cgo= --===============6997772610799329777==--