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 1nWKns-0006AI-UJ for pgsql-committers@arkaria.postgresql.org; Mon, 21 Mar 2022 16:22:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWKnr-00054J-Rl for pgsql-committers@arkaria.postgresql.org; Mon, 21 Mar 2022 16:22:43 +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 1nWKnr-00052f-L3 for pgsql-committers@lists.postgresql.org; Mon, 21 Mar 2022 16:22:43 +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 1nWKnk-0000LI-P0 for pgsql-committers@lists.postgresql.org; Mon, 21 Mar 2022 16:22:43 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWKni-0005oL-Kv for pgsql-committers@lists.postgresql.org; Mon, 21 Mar 2022 16:22:34 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nWKnh-000jub-3U for pgsql-committers@lists.postgresql.org; Mon, 21 Mar 2022 16:22:33 +0000 Content-Type: multipart/mixed; boundary="===============0445684069880083251==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix risk of deadlock failure while dropping a partitioned index. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 21 Mar 2022 16:22:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0445684069880083251== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJpc2sgb2YgZGVhZGxvY2sgZmFpbHVyZSB3aGlsZSBkcm9wcGluZyBhIHBhcnRpdGlvbmVk IGluZGV4LgoKRFJPUCBJTkRFWCBuZWVkcyB0byBsb2NrIHRoZSBpbmRleCdzIHRhYmxlIGJlZm9y ZSB0aGUgaW5kZXggaXRzZWxmLAplbHNlIGl0IHdpbGwgZGVhZGxvY2sgYWdhaW5zdCBvcmRpbmFy eSBxdWVyaWVzIHRoYXQgYWNxdWlyZSB0aGUKcmVsYXRpb24gbG9ja3MgaW4gdGhhdCBvcmRlci4g IFRoaXMgaXMgY29ycmVjdGx5IG1lY2hhbml6ZWQgZm9yCnBsYWluIGluZGV4ZXMgYnkgUmFuZ2VW YXJDYWxsYmFja0ZvckRyb3BSZWxhdGlvbjsgYnV0IGluIHRoZSBjYXNlIG9mCmEgcGFydGl0aW9u ZWQgaW5kZXgsIHdlIG5lZ2xlY3RlZCB0byBsb2NrIHRoZSBjaGlsZCB0YWJsZXMgaW4gYWR2YW5j ZQpvZiBsb2NraW5nIHRoZSBjaGlsZCBpbmRleGVzLiAgV2UgY2FuIGZpeCB0aGF0IGJ5IHRyYXZl cnNpbmcgdGhlCmluaGVyaXRhbmNlIHRyZWUgYW5kIGFjcXVpcmluZyB0aGUgbmVlZGVkIGxvY2tz IGluIFJlbW92ZVJlbGF0aW9ucywKYWZ0ZXIgd2UgaGF2ZSBhY3F1aXJlZCBvdXIgbG9ja3Mgb24g dGhlIHBhcmVudCBwYXJ0aXRpb25lZCB0YWJsZSBhbmQKaW5kZXguCgpXaGlsZSBhdCBpdCwgZG8g c29tZSByZWZhY3RvcmluZyB0byBlbGltaW5hdGUgY29uZnVzaW9uIGJldHdlZW4KdGhlIGFjdHVh bCBhbmQgZXhwZWN0ZWQgcmVsa2luZCBpbiBSYW5nZVZhckNhbGxiYWNrRm9yRHJvcFJlbGF0aW9u LgpXZSBjYW4gc2F2ZSBhIGNvdXBsZSBvZiBzeXNjYWNoZSBsb29rdXBzIHRvbywgYnkgaGF2aW5n IHRoYXQgZnVuY3Rpb24KcGFzcyBiYWNrIGluZm8gdGhhdCBSZW1vdmVSZWxhdGlvbnMgd2lsbCBu ZWVkLgoKQmFjay1wYXRjaCB0byB2MTEgd2hlcmUgcGFydGl0aW9uZWQgaW5kZXhlcyB3ZXJlIGFk ZGVkLgoKSmltbXkgWWloLCBHYXVyYWIgRGV5LCBUb20gTGFuZQoKRGlzY3Vzc2lvbjogaHR0cHM6 Ly9wb3N0Z3IuZXMvbS9CWUFQUjA1TUI2NDU0MDIzMzAwNDJFMTdEOTFBNzBDMTJCRDVGOUBCWUFQ UjA1TUI2NDU0Lm5hbXByZDA1LnByb2Qub3V0bG9vay5jb20KCkJyYW5jaAotLS0tLS0KUkVMXzEz X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2Nv bW1pdGRpZmYvMjI0MWU1Y2VkYTJmZWJkOTBiMDZlNmNiYzAyYThiNTFlOWUwNzBlNAoKTW9kaWZp ZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMg ICAgICAgICAgICAgICAgICAgfCAgNjEgKysrKysrKysrLS0tLQouLi4vZXhwZWN0ZWQvcGFydGl0 aW9uLWRyb3AtaW5kZXgtbG9ja2luZy5vdXQgICAgICB8IDEwMCArKysrKysrKysrKysrKysrKysr KysKc3JjL3Rlc3QvaXNvbGF0aW9uL2lzb2xhdGlvbl9zY2hlZHVsZSAgICAgICAgICAgICAgfCAg IDEgKwouLi4vc3BlY3MvcGFydGl0aW9uLWRyb3AtaW5kZXgtbG9ja2luZy5zcGVjICAgICAgICB8 ICA0NyArKysrKysrKysrCjQgZmlsZXMgY2hhbmdlZCwgMTkxIGluc2VydGlvbnMoKyksIDE4IGRl bGV0aW9ucygtKQoK --===============0445684069880083251==--