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 1ssQY0-008LoR-UV for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Sep 2024 17:39:01 +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 1ssQX2-009Wxo-6B for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Sep 2024 17:38:00 +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 1ssN8D-006Nqb-FG for pgsql-bugs@lists.postgresql.org; Sun, 22 Sep 2024 14:00:09 +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 1ssN8A-000Ug0-4s for pgsql-bugs@lists.postgresql.org; Sun, 22 Sep 2024 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=vpixmrjC0pP4sISOyvWwBB2QQ6xZaqHtc12RC1lxCQY=; b=4HlcHyUertBBDMbIVluTkuKR5Z ekb4g9LQ+bszg4ScKvGKzyi1V+N9dac3Uf00tjfkz/r5dpyxhBa2FL4GG+9/mThm6lyocR633ncrK StiMwYlBr0shorWhYZGv/Mngc4IfVqFkeJdTON7Q6ECDlQCPEyrOaJxz8M+fZAbN4AIFYP2vkR4m3 Q4i6Crh5N3enYgmI1I890+JKS8OTPE+10mWwMisgCEp3GYJRYlhs1a1FlBUAC2LeXihBgKL4akJk3 AhNd94L8j66sFvzsaIa3SiZKfm2AnzXSQYdZ2Xq/NYT/dhsrBiCWJaLpulvsOI7nCeNIdGBH/sQi1 HlE8kR8A==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ssN89-001YnS-2p for pgsql-bugs@lists.postgresql.org; Sun, 22 Sep 2024 14: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 1ssN87-002e7q-UE for pgsql-bugs@lists.postgresql.org; Sun, 22 Sep 2024 14:00:03 +0000 Content-Type: multipart/mixed; boundary="===============3456992578164241179==" MIME-Version: 1.0 Subject: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key 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: Sun, 22 Sep 2024 14:00:00 +0000 Message-ID: <18628-4f11be4e0b1c9002@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 --===============3456992578164241179== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODYyOApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTdyYzEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKClRoZSBmb2xsb3dpbmcgc2NyaXB0Og0KZm9yICgoaT0xO2k8PTEwMDtpKyspKTsgZG8N CnBzcWwgIC1xIC1jICJEUk9QIFRBQkxFIElGIEVYSVNUUyBwdCwgcDEsIHAyIENBU0NBREU7Ig0K DQplY2hvICINCkNSRUFURSBUQUJMRSBwdCAoaWQgaW50IFBSSU1BUlkgS0VZLCByaWQgaW50LA0K ICBGT1JFSUdOIEtFWSAocmlkKSBSRUZFUkVOQ0VTIHB0KGlkKSkNClBBUlRJVElPTiBCWSBMSVNU IChpZCk7DQoNCkNSRUFURSBUQUJMRSBwMSBQQVJUSVRJT04gT0YgcHQgRk9SIFZBTFVFUyBJTiAo MSk7DQpDUkVBVEUgVEFCTEUgcDIgKGlkIGludCBQUklNQVJZIEtFWSwgcmlkIGludCk7DQoiIHwg cHNxbCAtcQ0KDQpwc3FsIC1jICJBTFRFUiBUQUJMRSBwdCBERVRBQ0ggUEFSVElUSU9OIHAxOyIg Jg0KcHNxbCAtYyAiQUxURVIgVEFCTEUgcHQgQVRUQUNIIFBBUlRJVElPTiBwMSBGT1IgVkFMVUVT IElOICgxKTsiICYNCnBzcWwgLWMgIkFMVEVSIFRBQkxFIHB0IEFUVEFDSCBQQVJUSVRJT04gcDIg Rk9SIFZBTFVFUyBJTiAoMik7Ig0Kd2FpdA0KDQplY2hvICAiDQpBTFRFUiBUQUJMRSBwdCBERVRB Q0ggUEFSVElUSU9OIHAxOw0KIiB8IHBzcWwgMj4mMSB8IGdyZXAgJ2NvdWxkIG5vdCBmaW5kJyAm JiBicmVhazsNCmRvbmUNCg0KcHNxbCAtYyAiDQpTRUxFQ1QgYy5jb25uYW1lLCBjLm9pZCwgdC50 Z25hbWUsIHRndHlwZQ0KRlJPTSBwZ190cmlnZ2VyIHQsIHBnX2NvbnN0cmFpbnQgYywgcGdfY2xh c3MgY2wNCldIRVJFIHRnY29uc3RyYWludCA9IGMub2lkIEFORCBjb25yZWxpZCA9IGNsLm9pZCBB TkQNCiAgY2wucmVsbmFtZSA9ICdwMSc7Ig0KDQplbmRzIHVwIHdpdGg6DQpFUlJPUjogIGNvdWxk IG5vdCBmaW5kIE9OIElOU0VSVCBjaGVjayB0cmlnZ2VycyBvZiBmb3JlaWduIGtleSBjb25zdHJh aW50CjE2NDA5DQoNCmFuZCB0aGUgcDEgY29uc3RyYWludHMgYXQgdGhlIGVuZCBhcmU6DQogICBj b25uYW1lICAgfCAgb2lkICB8ICAgICAgICAgICAgdGduYW1lICAgICAgICAgICAgfCB0Z3R5cGUg DQotLS0tLS0tLS0tLS0tKy0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0t LS0tLS0tDQogcDFfcmlkX2ZrZXkgfCAxNjQwOSB8IFJJX0NvbnN0cmFpbnRUcmlnZ2VyX2FfMTY0 MTAgfCAgICAgIDkNCiBwMV9yaWRfZmtleSB8IDE2NDA5IHwgUklfQ29uc3RyYWludFRyaWdnZXJf YV8xNjQxMSB8ICAgICAxNw0KIHB0X3JpZF9ma2V5IHwgMTYzOTkgfCBSSV9Db25zdHJhaW50VHJp Z2dlcl9jXzE2NDAwIHwgICAgICA1DQogcHRfcmlkX2ZrZXkgfCAxNjM5OSB8IFJJX0NvbnN0cmFp bnRUcmlnZ2VyX2NfMTY0MDEgfCAgICAgMTcNCig0IHJvd3MpDQoNCldoaWxzdCB3aGVuIHRoZSBw YXJ0aXRpb24gaXMgaW4gbm9ybWFsIGNvbmRpdGlvbnMsIGl0J3MgY29uc3RyYWludHMgYXJlOg0K ICAgY29ubmFtZSAgIHwgIG9pZCAgfCAgICAgICAgICAgIHRnbmFtZSAgICAgICAgICAgIHwgdGd0 eXBlIA0KLS0tLS0tLS0tLS0tLSstLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLQ0KIHB0X3JpZF9ma2V5IHwgMTkxNzEgfCBSSV9Db25zdHJhaW50VHJpZ2dlcl9h XzE5MTgyIHwgICAgICA5DQogcHRfcmlkX2ZrZXkgfCAxOTE3MSB8IFJJX0NvbnN0cmFpbnRUcmln Z2VyX2FfMTkxODMgfCAgICAgMTcNCiBwdF9yaWRfZmtleSB8IDE5MTcxIHwgUklfQ29uc3RyYWlu dFRyaWdnZXJfY18xOTE3MiB8ICAgICAgNQ0KIHB0X3JpZF9ma2V5IHwgMTkxNzEgfCBSSV9Db25z dHJhaW50VHJpZ2dlcl9jXzE5MTczIHwgICAgIDE3DQoNClJlcHJvZHVjZWQgb24gUkVMXzE1X1NU QUJMRSAoc3RhcnRpbmcgZnJvbSA0NTY2MzQ1Y2YpIC4uIG1hc3Rlci4KCg== --===============3456992578164241179==--