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 1nM5NS-00014u-Vt for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Feb 2022 09:53:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nM5NR-0007yQ-RF for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Feb 2022 09:53:05 +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 1nM42G-0003JJ-TE for pgsql-bugs@lists.postgresql.org; Mon, 21 Feb 2022 08:27:08 +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 1nM42E-00050U-7P for pgsql-bugs@lists.postgresql.org; Mon, 21 Feb 2022 08:27: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=gMX7IfGHpwUAC6livg8AzQORTKiQAwGRicgbFLuZIe8=; b=Swzk+kEk4wT524rWEsYEOrSHG/ eCUVOE1gfS5qyPV6NTxm9zUdmSevR2Mpn0b3f3R7vCwMeRluuV1JO40h/3gtHFcn74cY7c0HMr9FR ZjQ+FVq9FWrICH7G/pehz7h88ji+f3OtCJ7lmLaVtieDxagVoTpVfRTOWgDHNFi+8amaGDzT9hkyP 9aqNBl11zefaJvZErIejTXLgBVrAuJQ/IAyAY2oSUEQGxqwIz3MKPpcY1g3xUMSuHf6kTrkp2XUYy yFAE2+ne1DwmxuFTjsD2p/DlEdI1TIu1tcUDgMrOVBNkfTl7agpgOUyCi6wcIZEAJZucg0d9uLhou 2Jc8nMLQ==; 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 1nM42C-0001E3-Pb for pgsql-bugs@lists.postgresql.org; Mon, 21 Feb 2022 08:27:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nM42A-0003lb-J0 for pgsql-bugs@lists.postgresql.org; Mon, 21 Feb 2022 08:27:02 +0000 Content-Type: multipart/mixed; boundary="===============2852582559648986767==" MIME-Version: 1.0 Subject: BUG #17412: CREATE INDEX on a partitioned table doesn't recognize existing partial indexes on partitions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cyberdemn@gmail.com Reply-To: cyberdemn@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 21 Feb 2022 08:26:28 +0000 Message-ID: <17412-86bb18216e7343aa@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 --===============2852582559648986767== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQxMgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBLdWt1c2hr aW4KRW1haWwgYWRkcmVzczogICAgICBjeWJlcmRlbW5AZ21haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTMuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKVGhlIENSRUFURSBJTkRFWCBDT05DVVJSRU5UTFkgaXNuJ3Qgc3VwcG9ydGVkIG9u IGEgcGFydGl0aW9uZWQgdGFibGUuIEFzIGEKd29ya2Fyb3VuZCwgcGVvcGxlIHVzdWFsbHkgY3Jl YXRlIGluZGV4ZXMgY29uY3VycmVudGx5IG9uIHBhcnRpdGlvbnMgYW5kCmFmdGVyIHRoYXQsIHRo ZSBDUkVBVEUgSU5ERVggb24gYSBwYXJ0aXRpb25lZCB0YWJsZS4gTm9ybWFsbHkgdGhlIGxhc3Qg b25lCmlzIGFibGUgdG8gcmVjb2duaXplIGFscmVhZHkgZXhpc3RpbmcgaW5kZXhlcyBhbmQgb25s eSB1cGRhdGVzIHBnX2NhdGFsb2cuDQoNClRoaXMgdGVjaG5pcXVlIG1vc3RseSB3b3JrcyBwZXJm ZWN0bHksIGJ1dCByZWNlbnRseSB3ZSBoaXQgdGhlIGNhc2Ugd2hlbiB0aGUKQ1JFQVRFIElOREVY IG9uIGEgcGFydGl0aW9uZWQgdGFibGUgd2Fzbid0IGFibGUgdG8gaWRlbnRpZnkgYWxyZWFkeSBl eGlzdGluZwpwYXJ0aWFsIGluZGV4ZXMgb24gcGFydGl0aW9ucy4NCg0KQmVsb3cgeW91IGNhbiBm aW5kIGEgc2ltcGxlIGFuZCByZXByb2R1Y2libGUgdGVzdCBjYXNlOg0KDQpsb2NhbGhvc3QvdGVz dD0jIGNyZWF0ZSB0YWJsZSB0ZXN0KHR5cGUgdGV4dCBub3QgbnVsbCwgbGFzdF9tb2RpZmllZAp0 aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgbm90IG51bGwpIHBhcnRpdGlvbiBieSByYW5nZSAobGFz dF9tb2RpZmllZCk7DQpDUkVBVEUgVEFCTEUNCmxvY2FsaG9zdC90ZXN0PSMgY3JlYXRlIHRhYmxl IHRlc3RfMSBwYXJ0aXRpb24gb2YgdGVzdCBmb3IgdmFsdWVzIGZyb20KKCcyMDIyLTAxLTAxJykg dG8gKCcyMDIyLTAyLTAxJyk7DQpDUkVBVEUgVEFCTEUNCmxvY2FsaG9zdC90ZXN0PSMgY3JlYXRl IHRhYmxlIHRlc3RfMiBwYXJ0aXRpb24gb2YgdGVzdCBmb3IgdmFsdWVzIGZyb20KKCcyMDIyLTAy LTAxJykgdG8gKCcyMDIyLTAzLTAxJyk7DQpDUkVBVEUgVEFCTEUNCmxvY2FsaG9zdC90ZXN0PSMg Y3JlYXRlIGluZGV4IENPTkNVUlJFTlRMWSBPTiB0ZXN0XzEgKGxhc3RfbW9kaWZpZWQpIHdoZXJl CnR5cGUgPSBBTlkgKEFSUkFZWydmb28nOjp0ZXh0LCAnYmFyJzo6dGV4dF0pOw0KQ1JFQVRFIElO REVYDQpsb2NhbGhvc3QvdGVzdD0jIGNyZWF0ZSBpbmRleCBDT05DVVJSRU5UTFkgT04gdGVzdF8y IChsYXN0X21vZGlmaWVkKSB3aGVyZQp0eXBlID0gQU5ZIChBUlJBWVsnZm9vJzo6dGV4dCwgJ2Jh cic6OnRleHRdKTsNCkNSRUFURSBJTkRFWA0KbG9jYWxob3N0L3Rlc3Q9IyBjcmVhdGUgaW5kZXgg T04gdGVzdCAobGFzdF9tb2RpZmllZCkgd2hlcmUgdHlwZSA9IEFOWQooQVJSQVlbJ2Zvbyc6OnRl eHQsICdiYXInOjp0ZXh0XSk7DQpDUkVBVEUgSU5ERVgNCmxvY2FsaG9zdC90ZXN0PSMgXGQgdGVz dA0KICAgICAgICAgICAgICAgICAgICAgIFBhcnRpdGlvbmVkIHRhYmxlICJwdWJsaWMudGVzdCIN CiAgICBDb2x1bW4gICAgIOKUgiAgICAgICAgICAgVHlwZSAgICAgICAgICAg4pSCIENvbGxhdGlv biDilIIgTnVsbGFibGUg4pSCIERlZmF1bHQKDQrilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilLzi lIDilIDilIDilIDilIDilIDilIDilIDilIANCiB0eXBlICAgICAgICAgIOKUgiB0ZXh0ICAgICAg ICAgICAgICAgICAgICAg4pSCICAgICAgICAgICDilIIgbm90IG51bGwg4pSCIA0KIGxhc3RfbW9k aWZpZWQg4pSCIHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSDilIIgICAgICAgICAgIOKUgiBub3Qg bnVsbCDilIIgDQpQYXJ0aXRpb24ga2V5OiBSQU5HRSAobGFzdF9tb2RpZmllZCkNCkluZGV4ZXM6 DQogICAgInRlc3RfbGFzdF9tb2RpZmllZF9pZHgiIGJ0cmVlIChsYXN0X21vZGlmaWVkKSBXSEVS RSB0eXBlID0gQU5ZCihBUlJBWVsnZm9vJzo6dGV4dCwgJ2Jhcic6OnRleHRdKQ0KTnVtYmVyIG9m IHBhcnRpdGlvbnM6IDIgKFVzZSBcZCsgdG8gbGlzdCB0aGVtLikNCg0KbG9jYWxob3N0L3Rlc3Q9 IyBcZCB0ZXN0XzENCiAgICAgICAgICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMudGVz dF8xIg0KICAgIENvbHVtbiAgICAg4pSCICAgICAgICAgICBUeXBlICAgICAgICAgICDilIIgQ29s bGF0aW9uIOKUgiBOdWxsYWJsZSDilIIgRGVmYXVsdAoNCuKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgA0KIHR5cGUgICAgICAgICAg4pSCIHRleHQg ICAgICAgICAgICAgICAgICAgICDilIIgICAgICAgICAgIOKUgiBub3QgbnVsbCDilIIgDQogbGFz dF9tb2RpZmllZCDilIIgdGltZXN0YW1wIHdpdGggdGltZSB6b25lIOKUgiAgICAgICAgICAg4pSC IG5vdCBudWxsIOKUgiANClBhcnRpdGlvbiBvZjogdGVzdCBGT1IgVkFMVUVTIEZST00gKCcyMDIy LTAxLTAxIDAwOjAwOjAwKzAxJykgVE8KKCcyMDIyLTAyLTAxIDAwOjAwOjAwKzAxJykNCkluZGV4 ZXM6DQogICAgInRlc3RfMV9sYXN0X21vZGlmaWVkX2lkeCIgYnRyZWUgKGxhc3RfbW9kaWZpZWQp IFdIRVJFIHR5cGUgPSBBTlkKKEFSUkFZWydmb28nOjp0ZXh0LCAnYmFyJzo6dGV4dF0pDQogICAg InRlc3RfMV9sYXN0X21vZGlmaWVkX2lkeDEiIGJ0cmVlIChsYXN0X21vZGlmaWVkKSBXSEVSRSB0 eXBlID0gQU5ZCihBUlJBWVsnZm9vJzo6dGV4dCwgJ2Jhcic6OnRleHRdKQ0KDQpsb2NhbGhvc3Qv dGVzdD0jIFxkIHRlc3RfMg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1Ymxp Yy50ZXN0XzIiDQogICAgQ29sdW1uICAgICDilIIgICAgICAgICAgIFR5cGUgICAgICAgICAgIOKU giBDb2xsYXRpb24g4pSCIE51bGxhYmxlIOKUgiBEZWZhdWx0Cg0K4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQogdHlwZSAgICAgICAgICDilIIg dGV4dCAgICAgICAgICAgICAgICAgICAgIOKUgiAgICAgICAgICAg4pSCIG5vdCBudWxsIOKUgiAN CiBsYXN0X21vZGlmaWVkIOKUgiB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUg4pSCICAgICAgICAg ICDilIIgbm90IG51bGwg4pSCIA0KUGFydGl0aW9uIG9mOiB0ZXN0IEZPUiBWQUxVRVMgRlJPTSAo JzIwMjItMDItMDEgMDA6MDA6MDArMDEnKSBUTwooJzIwMjItMDMtMDEgMDA6MDA6MDArMDEnKQ0K SW5kZXhlczoNCiAgICAidGVzdF8yX2xhc3RfbW9kaWZpZWRfaWR4IiBidHJlZSAobGFzdF9tb2Rp ZmllZCkgV0hFUkUgdHlwZSA9IEFOWQooQVJSQVlbJ2Zvbyc6OnRleHQsICdiYXInOjp0ZXh0XSkN CiAgICAidGVzdF8yX2xhc3RfbW9kaWZpZWRfaWR4MSIgYnRyZWUgKGxhc3RfbW9kaWZpZWQpIFdI RVJFIHR5cGUgPSBBTlkKKEFSUkFZWydmb28nOjp0ZXh0LCAnYmFyJzo6dGV4dF0pDQoNCg0KQXMg b25lIGNhbiBzZWUsIHRoZSAiY3JlYXRlIGluZGV4IE9OIHRlc3QgKGxhc3RfbW9kaWZpZWQpIHdo ZXJlIHR5cGUgPSBBTlkKKEFSUkFZWydmb28nOjp0ZXh0LCAnYmFyJzo6dGV4dF0pIiBoYXMgY3Jl YXRlZCBkdXBsaWNhdGVkIGluZGV4ZXMKdGVzdF8xX2xhc3RfbW9kaWZpZWRfaWR4MSBhbmQgdGVz dF8yX2xhc3RfbW9kaWZpZWRfaWR4MSBkZXNwaXRlIHRoZSBmYWN0CnRoYXQgdGhlcmUgYXJlIGFs cmVhZHkgZXhpc3RpbmcgaW5kZXhlcyB0ZXN0XzFfbGFzdF9tb2RpZmllZF9pZHggYW5kCnRlc3Rf MV9sYXN0X21vZGlmaWVkX2lkeDEuDQoNCldlIGhpdCB0aGlzIHByb2JsZW0gd2l0aCAxMy41LCBi dXQgZm9yIGV4YW1wbGUgMTQuMiBpcyBhbHNvIGFmZmVjdGVkLg0KDQpQLlMuIHRoZSBmZWF0dXJl IGNlcnRhaW5seSB3b3JrcyBmb3IgcGFydGlhbCBpbmRleGVzIHRoYXQgZG9uJ3QgdXNlIEFOWSBv cgpJTiBvcGVyYXRvcnMKCg== --===============2852582559648986767==--