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 1szzSg-0091Fl-Nj for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Oct 2024 14:20:46 +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 1szzJI-0042aO-KH for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Oct 2024 14:11:04 +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 1szsxW-00HMJ0-Gc for pgsql-bugs@lists.postgresql.org; Sun, 13 Oct 2024 07:24:11 +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 1szsxT-000ddf-Ae for pgsql-bugs@lists.postgresql.org; Sun, 13 Oct 2024 07:24: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=a/StuqV1d/Yts7bQsIVAes3VZzJnnROnKbbG6B5wmFE=; b=R0Nc6P09jxjP0l870eSa0QrsS3 FKrRDDvyGtc+5627KcuLWqFtmj+iuJL6ZesWwyG6QUdAb4wNvWPGr+vXz5JM3OyzkB9o18yaLUkVF Bw3KT8UHpuWZ8+DSpQRWtPr/x6PaUVtzih470ugQYyJ8m4D9IR2Stz8EqzSO5z3aUwocmy7H8p4cK 9D8VQa1nmXEkMnbs6zILeFALm8TlqrAiyYNPd/WloREKoBd5Eqf3y98Sf9870ypJym2w56BujYr8t cmj/K7fo5IarfqadplW0iqyjnvYiq0EPTlGgkRVcNklc2uyWYBLOw8Bc3rFKPmQvRWlI7PagyzkVJ UWTTBvzw==; 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 1szsxQ-0022d9-0k for pgsql-bugs@lists.postgresql.org; Sun, 13 Oct 2024 07:24:06 +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 1szsxN-003ZDg-U8 for pgsql-bugs@lists.postgresql.org; Sun, 13 Oct 2024 07:24:02 +0000 Content-Type: multipart/mixed; boundary="===============3410255807207250162==" MIME-Version: 1.0 Subject: BUG #18653: Is it necessary for ATExecDropInherit to acquire an AccessExclusiveLock on the parent table? To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: feichanghong@qq.com Reply-To: feichanghong@qq.com, pgsql-bugs@lists.postgresql.org Date: Sun, 13 Oct 2024 07:23:44 +0000 Message-ID: <18653-f2a96d3b52fd95a0@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 --===============3410255807207250162== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY1MwpMb2dnZWQgYnk6ICAgICAgICAgIEZlaSBDaGFuZ2hvbmcKRW1h aWwgYWRkcmVzczogICAgICBmZWljaGFuZ2hvbmdAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTcuMApPcGVyYXRpbmcgc3lzdGVtOiAgIE9wZXJhdGluZyBzeXN0ZW06IGNlbnRvcyA4LEtlcm5l bCB2ZXJzaW9uOiA1LjEwLjEzCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSBhbGwsDQoNCkkgZW5j b3VudGVyZWQgYSBwdXp6bGluZyBpc3N1ZSB3aGVuIGV4ZWN1dGluZyAiQUxURVIgVEFCTEUgTk8g SU5IRVJJVCIKY29uY3VycmVudGx5IHdpdGggIlNFTEVDVCI6IEluIGFuIFNRTCBzdGF0ZW1lbnQs IHRoZXJlIGFyZSB0d28gaWRlbnRpY2FsCnN1YnF1ZXJpZXMsIGJ1dCB0aGV5IHJldHVybiBkaWZm ZXJlbnQgcmVzdWx0cy4gVGhpcyBjYW4gYmUgcmVwcm9kdWNlZCB3aXRoCnRoZSBmb2xsb3dpbmcg c3BlYyB0ZXN0Og0KDQpgYGANCnNldHVwDQp7DQogQ1JFQVRFIFRBQkxFIHAgKGEgaW50ZWdlcik7 DQogSU5TRVJUIElOVE8gcCBWQUxVRVMoMSk7DQogQ1JFQVRFIFRBQkxFIGMxICgpIElOSEVSSVRT IChwKTsNCiBJTlNFUlQgSU5UTyBjMSBWQUxVRVMoMTApOw0KIENSRUFURSBUQUJMRSBjMiAoYSBp bnRlZ2VyKTsNCiBJTlNFUlQgSU5UTyBjMiBWQUxVRVMoMTAwKTsNCn0NCg0KdGVhcmRvd24NCnsN CiBEUk9QIFRBQkxFIElGIEVYSVNUUyBjMSwgYzIsIHA7DQp9DQoNCnNlc3Npb24gczENCnN0ZXAg czFiCXsgQkVHSU47IH0NCnN0ZXAgczFkZWxjMQl7IEFMVEVSIFRBQkxFIGMxIE5PIElOSEVSSVQg cDsgfQ0Kc3RlcCBzMWMJeyBDT01NSVQ7IH0NCg0Kc2Vzc2lvbiBzMg0Kc3RlcCBzMnNlbAl7IGV4 cGxhaW4gYW5hbHl6ZSBzZWxlY3QgYSBmcm9tIHAgZ3JvdXAgYnkgYSB1bmlvbiBhbGwgc2VsZWN0 IGEKZnJvbSBwIGdyb3VwIGJ5IGE7IH0NCg0KcGVybXV0YXRpb24gczFiIHMxZGVsYzEgczJzZWwg czFjDQpgYGANCg0KVGhlIHJlc3VsdCBvZiB0aGUgU0VMRUNUIGlzIGFzIGZvbGxvd3M6IG9uZSBv ZiB0aGUgVU5JT04gQUxMIG5vZGVzIHJldHVybnMgMgpyb3dzLCB3aGlsZSB0aGUgb3RoZXIgcmV0 dXJucyAxIHJvdzoNCg0KYGBgDQpRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCkFwcGVuZCAgKGNvc3Q9NjAuMDkuLjcwLjI4IHJv d3M9NDAwIHdpZHRoPTQpIChhY3R1YWwgdGltZT0wLjAyMi4uMC4wMzAKcm93cz0zIGxvb3BzPTEp ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogIC0+ICBIYXNoQWdncmVnYXRlICAoY29z dD02MC4wOS4uNjIuMDkgcm93cz0yMDAgd2lkdGg9NCkgKGFjdHVhbAp0aW1lPTAuMDIyLi4wLjAy MyByb3dzPTIgbG9vcHM9MSkgICAgICAgICAgICAgICAgIA0KICAgICAgICBHcm91cCBLZXk6IHAu YSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgQmF0Y2hlczog MSAgTWVtb3J5IFVzYWdlOiA0MGtCICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgIC0+ICBB cHBlbmQgIChjb3N0PTAuMDAuLjUzLjA3IHJvd3M9MjgwNSB3aWR0aD00KSAoYWN0dWFsCnRpbWU9 MC4wMDcuLjAuMDE0IHJvd3M9MiBsb29wcz0xKSAgICAgICAgICAgICAgICAgIA0KICAgICAgICAg ICAgICAtPiAgU2VxIFNjYW4gb24gcCBwXzEgIChjb3N0PTAuMDAuLjMuNTUgcm93cz0yNTUgd2lk dGg9NCkKKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAwNyByb3dzPTEgbG9vcHM9MSkgICANCiAgICAg ICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGMxIHBfMiAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93cz0y NTUwIHdpZHRoPTQpCihhY3R1YWwgdGltZT0wLjAwNS4uMC4wMDUgcm93cz0xIGxvb3BzPTEpDQog IC0+ICBIYXNoQWdncmVnYXRlICAoY29zdD00LjE5Li42LjE5IHJvd3M9MjAwIHdpZHRoPTQpIChh Y3R1YWwKdGltZT0wLjAwNS4uMC4wMDUgcm93cz0xIGxvb3BzPTEpICAgICAgICAgICAgICAgICAg IA0KICAgICAgICBHcm91cCBLZXk6IHBfMy5hICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICANCiAgICAgICAgQmF0Y2hlczogMSAgTWVtb3J5IFVzYWdlOiA0MGtCICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgDQogICAgICAgIC0+ICBTZXEgU2NhbiBvbiBwIHBfMyAgKGNvc3Q9MC4wMC4uMy41 NSByb3dzPTI1NSB3aWR0aD00KSAoYWN0dWFsCnRpbWU9MC4wMDIuLjAuMDAyIHJvd3M9MSBsb29w cz0xKSAgICAgICAgIA0KUGxhbm5pbmcgVGltZTogMTAuMDUxIG1zICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICANCkV4ZWN1dGlvbiBUaW1lOiAwLjE2MSBtcyAgICANCmBgYA0KDQpC YXNlZCBvbiBteSBhbmFseXNpcywgdGhlIGlzc3VlIG9jY3VycyBiZWNhdXNlICJBTFRFUiBUQUJM RSBOTyBJTkhFUklUIiBvbmx5CmhvbGRzIGFuIEFjY2Vzc0V4Y2x1c2l2ZUxvY2sgb24gdGhlIHBh cmVudCB0YWJsZS4NCg0KV2hlbiBnZW5lcmF0aW5nIHRoZSBwbGFuIGZvciB0aGUgZmlyc3Qgc3Vi cXVlcnksIGZpbmRfYWxsX2luaGVyaXRvcnMgdXNlcwp0aGUgY2F0YWxvZyBzbmFwc2hvdCBmcm9t IGJlZm9yZSB0aGUgRERMIGlzIGNvbW1pdHRlZCwgc28gaXQgc2VlcyB0YWJsZSBjMSwKYnV0IGdl dHMgYmxvY2tlZCB3aGVuIHRyeWluZyB0byBsb2NrIGMxLiBGb3IgdGhlIHNlY29uZCBzdWJxdWVy eSwKZmluZF9hbGxfaW5oZXJpdG9ycyB1c2VzIHRoZSBjYXRhbG9nIHNuYXBzaG90IGZyb20gYWZ0 ZXIgdGhlIERETCBpcwpjb21taXR0ZWQsIHNvIGl0IGRvZXNuJ3Qgc2VlIGMxLg0KDQpJcyB0aGlz IGJlaGF2aW9yIGV4cGVjdGVkPyBBbHRlcm5hdGl2ZWx5LCBzaG91bGQgd2UgYWNxdWlyZSBhbgpB Y2Nlc3NFeGNsdXNpdmVMb2NrIG9uIHRoZSBwYXJlbnQgdGFibGUgaW4gQVRFeGVjRHJvcEluaGVy aXQ/IFRoaXMgbWlnaHQKbGVhZCB0byBhIGRlYWRsb2NrLgoK --===============3410255807207250162==--