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 1pj04g-0000Xb-QO for pgsql-bugs@arkaria.postgresql.org; Sun, 02 Apr 2023 15:56:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pj04f-0003nW-8y for pgsql-bugs@arkaria.postgresql.org; Sun, 02 Apr 2023 15:56:57 +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 1pizdj-0000Yx-D5 for pgsql-bugs@lists.postgresql.org; Sun, 02 Apr 2023 15:29:07 +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 1pizdg-0000aW-67 for pgsql-bugs@lists.postgresql.org; Sun, 02 Apr 2023 15:29:06 +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=XcAJ7DslZccZOAQSSwiEADXf/ns77JPh1kyrxuxVDhk=; b=CrbPeaoq1bwktZGuAh7MsFOHnk BjBKaGO/stvwy1F6RnJNyEml4VT92o40I77B8G9sYst3lQ0gSAS33u5NCcJ6PIrjFAE1W/XDDoaKP yqYqVTm1V02YbHappq0zfyZoPQl7Us8DJ32gUzdJIOhsSqw9ipuY69q7LoL5NfCT2MzRUeDPyM4VK tJ5+XjgM4nscVFEf3V4PZ8VUejlvp1Krt47x5Kectfgj4VVm2bb/q7LTQPJALb4N3HZ7VOUTejaI8 unGzRMFqwmEqa386BppJuxupGpAX5omw9Hy0CVY2gWjwFQN8Y5DJ7lQLNuKVyXPC6t17ihJkqrIRS u0/pHMxA==; 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 1pizdf-0008Ic-Nn for pgsql-bugs@lists.postgresql.org; Sun, 02 Apr 2023 15:29:03 +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 1pizde-003asC-9i for pgsql-bugs@lists.postgresql.org; Sun, 02 Apr 2023 15:29:02 +0000 Content-Type: multipart/mixed; boundary="===============1218448747005171074==" MIME-Version: 1.0 Subject: BUG #17882: I can't disable triggers on a table that has been partitioned To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: quynh.helendinh@gmail.com Reply-To: quynh.helendinh@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 02 Apr 2023 15:28:37 +0000 Message-ID: <17882-707c9c1553485c97@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 --===============1218448747005171074== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg4MgpMb2dnZWQgYnk6ICAgICAgICAgIFF1eW5oIExlCkVtYWlsIGFk ZHJlc3M6ICAgICAgcXV5bmguaGVsZW5kaW5oQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE1LjIKT3BlcmF0aW5nIHN5c3RlbTogICBNYWNPUwpEZXNjcmlwdGlvbjogICAgICAgIAoKUG9z dGdyZXMgdmVyc2lvbjogUG9zdGdyZVNRTCAxNS4yIG9uIGFhcmNoNjQtYXBwbGUtZGFyd2luMjEu Ni4wLCBjb21waWxlZCBieQpBcHBsZSBjbGFuZyB2ZXJzaW9uIDE0LjAuMCAoY2xhbmctMTQwMC4w LjI5LjEwMiksIDY0LWJpdA0KDQpHaXZlbiB0aGF0IEkgaGF2ZSBhIHRhYmxlIHVzZXJzIHRoYXQg aGFzIGEgcmVmZXJlbnRpYWwgY29uc3RyYWludCB0byBhbm90aGVyCnRhYmxlLCBhY3Rpdml0aWVz LCBsaWtlIGJlbG93Og0KDQpDUkVBVEUgVEFCTEUgYWN0aXZpdGllcyAoDQogIGlkIElOVCBQUklN QVJZIEtFWSwNCiAgYWN0aXZpdHlfbmFtZSBWQVJDSEFSKDUwKQ0KKTsNCg0KQ1JFQVRFIFRBQkxF IHVzZXJzICgNCiAgaWQgSU5ULA0KICB1c2VybmFtZSBWQVJDSEFSKDUwKSwNCiAgYWN0aXZpdHlf aWQgSU5ULA0KICBGT1JFSUdOIEtFWSAoYWN0aXZpdHlfaWQpIFJFRkVSRU5DRVMgYWN0aXZpdGll cyhpZCkNCikgUEFSVElUSU9OIEJZIFJBTkdFIChpZCk7DQoNCkNSRUFURSBUQUJMRSB1c2Vyc18w IFBBUlRJVElPTiBPRiB1c2Vycw0KICBGT1IgVkFMVUVTIEZST00gKDApIFRPICgxMDApOw0KDQpD UkVBVEUgVEFCTEUgdXNlcnNfMSBQQVJUSVRJT04gT0YgdXNlcnMNCiAgRk9SIFZBTFVFUyBGUk9N ICgxMDApIFRPICgyMDApOw0KDQpDUkVBVEUgVEFCTEUgdXNlcnNfMiBQQVJUSVRJT04gT0YgdXNl cnMNCiAgRk9SIFZBTFVFUyBGUk9NICgyMDApIFRPICgzMDApOw0KDQpDUkVBVEUgVEFCTEUgdXNl cnNfMyBQQVJUSVRJT04gT0YgdXNlcnMNCiAgRk9SIFZBTFVFUyBGUk9NICgzMDApIFRPIChNQVhW QUxVRSk7DQpCZWxvdyBhcmUgdGhlIHJlc3VsdHMgb2YgXGRTKyBjb21tYW5kcyBvbiB0aGUgdGFi bGUgdXNlcnMgYW5kIGl0cwpwYXJ0aXRpb25zLg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBQYXJ0aXRpb25lZCB0YWJsZQoicHVibGljLnVzZXJzIg0KICAgQ29sdW1uICAgIHwgICAg ICAgICBUeXBlICAgICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwKU3Rv cmFnZSAgfCBDb21wcmVzc2lvbiB8IFN0YXRzIHRhcmdldCB8IERlc2NyaXB0aW9uDQotLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0t LS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tDQogaWQgICAgICAgICAgfCBpbnRlZ2VyICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCAg ICAgICAgICB8ICAgICAgICAgfApwbGFpbiAgICB8ICAgICAgICAgICAgIHwgICAgICAgICAgICAg IHwNCiB1c2VybmFtZSAgICB8IGNoYXJhY3RlciB2YXJ5aW5nKDUwKSB8ICAgICAgICAgICB8ICAg ICAgICAgIHwgICAgICAgICB8CmV4dGVuZGVkIHwgICAgICAgICAgICAgfCAgICAgICAgICAgICAg fA0KIGFjdGl2aXR5X2lkIHwgaW50ZWdlciAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgICAg ICAgICAgfCAgICAgICAgIHwKcGxhaW4gICAgfCAgICAgICAgICAgICB8ICAgICAgICAgICAgICB8 DQpQYXJ0aXRpb24ga2V5OiBSQU5HRSAoaWQpDQpGb3JlaWduLWtleSBjb25zdHJhaW50czoNCiAg ICAidXNlcnNfYWN0aXZpdHlfaWRfZmtleSIgRk9SRUlHTiBLRVkgKGFjdGl2aXR5X2lkKSBSRUZF UkVOQ0VTCmFjdGl2aXRpZXMoaWQpDQpQYXJ0aXRpb25zOiB1c2Vyc18wIEZPUiBWQUxVRVMgRlJP TSAoMCkgVE8gKDEwMCksDQogICAgICAgICAgICB1c2Vyc18xIEZPUiBWQUxVRVMgRlJPTSAoMTAw KSBUTyAoMjAwKSwNCiAgICAgICAgICAgIHVzZXJzXzIgRk9SIFZBTFVFUyBGUk9NICgyMDApIFRP ICgzMDApLA0KICAgICAgICAgICAgdXNlcnNfMyBGT1IgVkFMVUVTIEZST00gKDMwMCkgVE8gKE1B WFZBTFVFKQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAgICAg ICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMudXNlcnNfMCINCiAgIENvbHVtbiAgICB8 ICAgICAgICAgVHlwZSAgICAgICAgICB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgRGVmYXVsdA0K LS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0t LS0tKy0tLS0tLS0tLQ0KIGlkICAgICAgICAgIHwgaW50ZWdlciAgICAgICAgICAgICAgIHwgICAg ICAgICAgIHwgICAgICAgICAgfA0KIHVzZXJuYW1lICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoNTAp IHwgICAgICAgICAgIHwgICAgICAgICAgfA0KIGFjdGl2aXR5X2lkIHwgaW50ZWdlciAgICAgICAg ICAgICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfA0KUGFydGl0aW9uIG9mOiB1c2VycyBGT1Ig VkFMVUVTIEZST00gKDApIFRPICgxMDApDQpGb3JlaWduLWtleSBjb25zdHJhaW50czoNCiAgICBU QUJMRSAidXNlcnMiIENPTlNUUkFJTlQgInVzZXJzX2FjdGl2aXR5X2lkX2ZrZXkiIEZPUkVJR04g S0VZCihhY3Rpdml0eV9pZCkgUkVGRVJFTkNFUyBhY3Rpdml0aWVzKGlkKQ0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KV2hlbiBJIHRyeSB0byBkaXNhYmxlIHRy aWdnZXJzIG9uIHRoZSB0YWJsZSB1c2VycyB1c2luZyB0aGlzIGNvbW1hbmQ6DQphbHRlciB0YWJs ZSB1c2VycyBkaXNhYmxlIHRyaWdnZXIgYWxsOw0KDQpJJ20gbWV0IHdpdGggdGhpcyBlcnJvcjoN CkVSUk9SOiAgdHJpZ2dlciAiUklfQ29uc3RyYWludFRyaWdnZXJfY181NzI5MTgiIGZvciB0YWJs ZSAidXNlcnNfMCIgZG9lcyBub3QKZXhpc3QNCg0KTXkgaHlwb3RoZXNpczogSSBndWVzcyB0aGUg Y29tbWFuZCB0byBkaXNhYmxlIGFsbCB0cmlnZ2VycyB3aWxsIHByb3BhZ2F0ZSB0bwphbGwgdGhl IHBhcnRpdGlvbnMgYXMgdGhpcyBjb21tYW5kIHRvIGRpc2FibGUgdHJpZ2dlcnMgb24gb25seSB0 aGlzIHRhYmxlCndvdWxkIHdvcms6DQphbHRlciB0YWJsZSBvbmx5IHVzZXJzIGRpc2FibGUgdHJp Z2dlciBhbGw7IC0tIEFMVEVSIFRBQkxFDQoNCkkgdHJpZWQgdG8gbGlzdCBhbGwgdHJpZ2dlcnMg Zm9yIHRoZSBvcmlnaW5hbCB0YWJsZSBhbmQgcGFydGl0aW9ucyBhbmQgdGhleQpyZXR1cm4gZGlm ZmVyZW50IHRyaWdnZXIgbmFtZXMuIFBvc3RncmVTUUwgc2VlbXMgdG8gdXNlIHRoZSB0cmlnZ2Vy cycgbmFtZQpmcm9tIHRoZSBvcmlnaW5hbCB0YWJsZSBhbmQgcHJvcGFnYXRlcyBpdCB0byB0aGUg cGFydGl0aW9ucywgYnV0IHdpdGggbmFtaW5nCmRpZmZlcmVuY2VzIGxpa2UgdGhpcywgaXQgd291 bGQgbmV2ZXIgd29yayByaWdodD8NCg0KQmVsb3cgaXMgdGhlIHJlc3VsdCB3aGVuIEkgbGlzdCB0 aGUgdHJpZ2dlcnMgb24gdGhlIG9yaWdpbmFsIHRhYmxlIHVzZXJzIGFuZAppdHMgcGFydGl0aW9u cy4NCg0KLS0gb3JpZ2luYWwgdGFibGUNCnRlc3Q9IyBTRUxFQ1QNCiAgICB0Z25hbWUgQVMgdHJp Z2dlcl9uYW1lDQpGUk9NDQogICAgcGdfdHJpZ2dlcg0KV0hFUkUNCiAgICB0Z3JlbGlkID0gJ3Vz ZXJzJzo6cmVnY2xhc3MNCk9SREVSIEJZDQogICAgdHJpZ2dlcl9uYW1lOw0KICAgICAgICAgdHJp Z2dlcl9uYW1lOw0KDQotLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFJJX0Nv bnN0cmFpbnRUcmlnZ2VyX2NfNTcyOTE4DQogUklfQ29uc3RyYWludFRyaWdnZXJfY181NzI5MTkN Ci0tIHBhcnRpdGlvbg0KdGVzdD0jIFNFTEVDVA0KICAgIHRnbmFtZSBBUyB0cmlnZ2VyX25hbWUN CkZST00NCiAgICBwZ190cmlnZ2VyDQpXSEVSRQ0KICAgIHRncmVsaWQgPSAndXNlcnNfMCc6OnJl Z2NsYXNzDQpPUkRFUiBCWQ0KICAgIHRyaWdnZXJfbmFtZTsNCiAgICAgICAgIHRyaWdnZXJfbmFt ZQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFJJX0NvbnN0cmFpbnRUcmlnZ2Vy X2NfNTcyOTI0DQogUklfQ29uc3RyYWludFRyaWdnZXJfY181NzI5MjUNCigyIHJvd3MpDQpNeSBx dWVzdGlvbjogSG93ZXZlciwgSSdtIHVudXNlZCBhcyB0byB3aHkgUG9zdGdyZVNRTCBpcyB0cnlp bmcgdG8gZGlzYWJsZSBhCm5vbi1leGlzdGVudCB0cmlnZ2VyIG9uIHRoZSBwYXJ0aXRpb24uIElz IHRoaXMgYSBidWc/IEkgaGF2ZSB0ZXN0ZWQgb24gMTQuNAphbmQgMTQuNyBhbmQgUG9zdGdyZXMg ZG9lc24ndCBjcmVhdGUgdHJpZ2dlcnMgb24gdGhlIG9yaWdpbmFsIHRhYmxlLCBidXQgaW4KMTUu NSBpdCBkb2VzLgoK --===============1218448747005171074==--