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 1qw2Fd-009AHN-TY for pgsql-bugs@arkaria.postgresql.org; Thu, 26 Oct 2023 15:26:26 +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 1qw2Fc-001Xyj-AD for pgsql-bugs@arkaria.postgresql.org; Thu, 26 Oct 2023 15:26:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qw21q-001PrX-RZ for pgsql-bugs@lists.postgresql.org; Thu, 26 Oct 2023 15:12:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qw21l-002wTc-UE for pgsql-bugs@lists.postgresql.org; Thu, 26 Oct 2023 15:12:10 +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=DMkpizL71Mshh50vuR89oM4wPXyVlXrjc4ZK0qxaZWU=; b=bOZSCNd5/+GRpjNo/fk6k0Ur6/ Eq/VXu8xqj72J7Z0Gi09UtBTCxFjXTfi03aUED/V5FrizaPfG87jAVnFovjAka+2s4l6p1sE7XmnX sVxMkvk3ptzWKZ6LyuwzqDE6936IFJCp/oiQGfSQtwyM0JwcaWA0IQldb30WZwAb6ZP8A2ZIo7JoP xiEVcrkcKBpnj8wXdOnjDGhRsOApkfg1ye5dz5ieMQLWSNBxCauGSJXAD5gmIaQpbTuZugeStNduH 0FIUcZaOnCMaK/6dBlzAknMc9aWor0OSxoQnkTClAJDr/RYhikFkOSgZwNmfr3LzCHrAvXxcvRVrM ytRsh1ng==; 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 1qw21k-0002EJ-H5 for pgsql-bugs@lists.postgresql.org; Thu, 26 Oct 2023 15:12:04 +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 1qw21h-009J05-0G for pgsql-bugs@lists.postgresql.org; Thu, 26 Oct 2023 15:12:02 +0000 Content-Type: multipart/mixed; boundary="===============8284332832574953748==" MIME-Version: 1.0 Subject: BUG #18171: Dropping an index on a partitioned table drops all child indices even with a restrict To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nickdujay@gmail.com Reply-To: nickdujay@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 26 Oct 2023 15:11:39 +0000 Message-ID: <18171-4abd023036968941@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 --===============8284332832574953748== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE3MQpMb2dnZWQgYnk6ICAgICAgICAgIE5pY2sgRHVqYXkKRW1haWwg YWRkcmVzczogICAgICBuaWNrZHVqYXlAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIu OApPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIZXJlJ3Mg dGhlIHNldHVwLg0KDQpwb3N0Z3Jlcz0jIGNyZWF0ZSB0YWJsZSBwYXJlbnQgKGlkIGJpZ3Nlcmlh bCwgY3JlYXRlZF9hdCB0aW1lc3RhbXAgbm90IG51bGwKZGVmYXVsdCBub3coKSkgcGFydGl0aW9u IGJ5IHJhbmdlIChjcmVhdGVkX2F0KTsNCnBvc3RncmVzPSMgY3JlYXRlIHRhYmxlIGNoaWxkMSBw YXJ0aXRpb24gb2YgcGFyZW50IGZvciB2YWx1ZXMgZnJvbQooJzIwMTktMDEtMDEgMDA6MDA6MDAn KSBUTyAoJzIwMTktMDEtMDIgMDA6MDA6MDAnKTsNCnBvc3RncmVzPSMgY3JlYXRlIGluZGV4IGNo aWxkX2lkX2luZGV4IG9uIGNoaWxkMSAoaWQpOw0KcG9zdGdyZXM9IyBjcmVhdGUgaW5kZXggcGFy ZW50X2lkX2luZGV4IG9uIHBhcmVudCAoaWQpOw0KcG9zdGdyZXM9IyBhbHRlciBpbmRleCBwYXJl bnRfaWRfaW5kZXggYXR0YWNoIHBhcnRpdGlvbiBjaGlsZF9pZF9pbmRleDsNCnBvc3RncmVzPSMg XGQgcGFyZW50DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUGFydGl0aW9uZWQg dGFibGUgInB1YmxpYy5wYXJlbnQiDQogICBDb2x1bW4gICB8ICAgICAgICAgICAgVHlwZSAgICAg ICAgICAgICB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgICAgICAgICAgCiAgIERlZmF1bHQNCi0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlkICAgICAgICAg fCBiaWdpbnQgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8Cm5l eHR2YWwoJ3BhcmVudF9pZF9zZXEnOjpyZWdjbGFzcykNCiBjcmVhdGVkX2F0IHwgdGltZXN0YW1w IHdpdGhvdXQgdGltZSB6b25lIHwgICAgICAgICAgIHwgbm90IG51bGwgfCBub3coKQ0KUGFydGl0 aW9uIGtleTogUkFOR0UgKGNyZWF0ZWRfYXQpDQpJbmRleGVzOg0KICAgICJwYXJlbnRfaWRfaW5k ZXgiIGJ0cmVlIChpZCkNCk51bWJlciBvZiBwYXJ0aXRpb25zOiAxIChVc2UgXGQrIHRvIGxpc3Qg dGhlbS4pDQpwb3N0Z3Jlcz0jIFxkIGNoaWxkMQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMuY2hpbGQxIg0KICAgQ29sdW1uICAgfCAgICAgICAg ICAgIFR5cGUgICAgICAgICAgICAgfCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8ICAgICAgICAgIAog ICBEZWZhdWx0DQotLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiBpZCAgICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwg bm90IG51bGwgfApuZXh0dmFsKCdwYXJlbnRfaWRfc2VxJzo6cmVnY2xhc3MpDQogY3JlYXRlZF9h dCB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8ICAgICAgICAgICB8IG5vdCBudWxsIHwg bm93KCkNClBhcnRpdGlvbiBvZjogcGFyZW50IEZPUiBWQUxVRVMgRlJPTSAoJzIwMTktMDEtMDEg MDA6MDA6MDAnKSBUTyAoJzIwMTktMDEtMDIKMDA6MDA6MDAnKQ0KSW5kZXhlczoNCiAgICAiY2hp bGRfaWRfaW5kZXgiIGJ0cmVlIChpZCkNCg0KV2hlbiBJIGF0dGVtcHQgdG8gZHJvcCB0aGUgY2hp bGQgaW5kZXgsIEkgZ2V0IGFuIGVycm9yLg0KDQpwb3N0Z3Jlcz0jIGRyb3AgaW5kZXggY29uY3Vy cmVudGx5IGNoaWxkX2lkX2luZGV4IHJlc3RyaWN0Ow0KRVJST1I6ICBjYW5ub3QgZHJvcCBpbmRl eCBjaGlsZF9pZF9pbmRleCBiZWNhdXNlIGluZGV4IHBhcmVudF9pZF9pbmRleApyZXF1aXJlcyBp dA0KSElOVDogIFlvdSBjYW4gZHJvcCBpbmRleCBwYXJlbnRfaWRfaW5kZXggaW5zdGVhZC4NCg0K V2hlbiBJIGF0dGVtcHQgdG8gZHJvcCB0aGUgcGFyZW50IGluZGV4IGNvbmN1cnJlbnRseSwgaXQg ZmFpbHMNCg0KcG9zdGdyZXM9IyBkcm9wIGluZGV4IGNvbmN1cnJlbnRseSBwYXJlbnRfaWRfaW5k ZXggcmVzdHJpY3Q7DQpFUlJPUjogIGNhbm5vdCBkcm9wIHBhcnRpdGlvbmVkIGluZGV4ICJwYXJl bnRfaWRfaW5kZXgiIGNvbmN1cnJlbnRseQ0KDQpJIGNhbiBkcm9wIHRoZSBwYXJlbnQgaW5kZXgg d2l0aG91dCBjb25jdXJyZW50bHksIGJ1dCB0aGVuIGl0IHdpbGwgdGFrZSBhbgpBQ0NFU1MgRVhD TFVTSVZFIGxvY2sgd2hpY2ggSSBhbSB0cnlpbmcgdG8gYXZvaWQuDQoNCnBvc3RncmVzPSMgZHJv cCBpbmRleCBwYXJlbnRfaWRfaW5kZXg7DQpEUk9QIElOREVYDQpwb3N0Z3Jlcz0jIFxkIHBhcmVu dA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFBhcnRpdGlvbmVkIHRhYmxlICJw dWJsaWMucGFyZW50Ig0KICAgQ29sdW1uICAgfCAgICAgICAgICAgIFR5cGUgICAgICAgICAgICAg fCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8ICAgICAgICAgIAogICBEZWZhdWx0DQotLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBpZCAgICAgICAgIHwgYmlnaW50 ICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfApuZXh0dmFsKCdw YXJlbnRfaWRfc2VxJzo6cmVnY2xhc3MpDQogY3JlYXRlZF9hdCB8IHRpbWVzdGFtcCB3aXRob3V0 IHRpbWUgem9uZSB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgbm93KCkNClBhcnRpdGlvbiBrZXk6 IFJBTkdFIChjcmVhdGVkX2F0KQ0KTnVtYmVyIG9mIHBhcnRpdGlvbnM6IDEgKFVzZSBcZCsgdG8g bGlzdCB0aGVtLikNCg0KcG9zdGdyZXM9IyBcZCBjaGlsZDENCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLmNoaWxkMSINCiAgIENvbHVtbiAgIHwg ICAgICAgICAgICBUeXBlICAgICAgICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAgICAg ICAgICAKICAgRGVmYXVsdA0KLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogaWQgICAgICAgICB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8ICAgICAg ICAgICB8IG5vdCBudWxsIHwKbmV4dHZhbCgncGFyZW50X2lkX3NlcSc6OnJlZ2NsYXNzKQ0KIGNy ZWF0ZWRfYXQgfCB0aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpvbmUgfCAgICAgICAgICAgfCBub3Qg bnVsbCB8IG5vdygpDQpQYXJ0aXRpb24gb2Y6IHBhcmVudCBGT1IgVkFMVUVTIEZST00gKCcyMDE5 LTAxLTAxIDAwOjAwOjAwJykgVE8gKCcyMDE5LTAxLTAyCjAwOjAwOjAwJykNCg0KVGhpcyBtYWtl cyBzZW5zZSBiZWNhdXNlIHRoZSBkZXBlbmRlbmN5IGlzIGZyb20gdGhlIHBhcmVudCB0byB0aGUg Y2hpbGQsIHNvCnJlc3RyaWN0IGlzICJjb3JyZWN0Ii4NCg0KSSB3b3VsZCBsaWtlIHRvIGJlIGFi bGUgdG8gZHJvcCB0aGUgcGFyZW50IGluZGV4IGZpcnN0IHdpdGhvdXQgZHJvcHBpbmcgdGhlCmNo aWxkIGluZGljZXMsIGFuZCB0aGVuIGRyb3AgYWxsIHRoZSBjaGlsZCBpbmRpY2VzIGNvbmN1cnJl bnRseS4gT3IgdmljZQp2ZXJzYSwgZHJvcCB0aGUgY2hpbGQgaW5kaWNlcyBjb25jdXJyZW50bHkg Zmlyc3QsIGFuZCB0aGVuIGRyb3AgdGhlIHBhcmVudAppbmRleCBsYXN0LgoK --===============8284332832574953748==--