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 1suCRd-004zHe-Lf for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Sep 2024 14:59: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 1suCRc-00AdY5-2R for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Sep 2024 14:59:44 +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 1suC0t-00ADt9-Qq for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 14:32:07 +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 1suC0r-001KcA-EP for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 14:32: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=yrBgLjEQBFNAVf5Pgu8HGGgcDIxx6myMuWdzzRzj+2U=; b=dfP7cOZu3v5EOlafeizcBegldi x9w5Yu7RxIkMt9n+il3UEP7XtS+W9BnDeJSpQKzmdpDVqJ0inVLaIlKCJORGGoopPRnet0aeGnF/1 yVLyy+Mr699hS6RkeMeeaUw1lBhVoSa/TFySC1pos9B/tMllv5jMMiu0iiOOJuF1liCfzDUdlMYE2 9Hsg7QLLDZx6aQliEj4Xrv3nuoFBzbhSXmTvTv+X/fZMdnn8fgV9zriCYNGf/eHuTYZduEMN7Jb+R 7O/P3dLe3Q0Nk5cIYXcIty25LuDTjnK4r/dnjpTQ8CBmuwet3k4L+wMYphmeTMAqQwa9GX/s1ZLqB yFzoi4uQ==; 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 1suC0q-00497Y-Ak for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 14:32: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 1suC0o-006w9v-QZ for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 14:32:02 +0000 Content-Type: multipart/mixed; boundary="===============2857684022502761458==" MIME-Version: 1.0 Subject: BUG #18637: CREATE INDEX won't look up operator classes in search_path if PARTITION BY is specified To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: usamoi@outlook.com Reply-To: usamoi@outlook.com, pgsql-bugs@lists.postgresql.org Date: Fri, 27 Sep 2024 14:31:54 +0000 Message-ID: <18637-f51e314546e3ba2a@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 --===============2857684022502761458== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODYzNwpMb2dnZWQgYnk6ICAgICAgICAgIENSRUFURSBJTkRFWCB3b24m I3gyNzt0IGxvb2sgdXAgb3BlcmF0b3IgY2xhc3NlcyBpbiBzZWFyY2hfcGF0aCBpZiBQQVJUSVRJ T04gQlkKaXMgc3BlY2lmaWVkCkVtYWlsIGFkZHJlc3M6ICAgICAgdXNhbW9pQG91dGxvb2suY29t ClBvc3RncmVTUUwgdmVyc2lvbjogMTcuMApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4IDYuMTAK RGVzY3JpcHRpb246ICAgICAgICAKClRoaXMgU1FMIHdvcmtzIGluIFBvc3RncmVTUUwgMTYuNCBi dXQgbm90IGluIFBvc3RncmVTUUwgMTcuMC4gSGVyZQpgdmVjdG9yX2wyX29wc2AgaXMgYW4gb3Bl cmF0b3IgY2xhc3MgaW4gc2NoZW1hIGB2ZWN0b3JzYC4NCmBgYA0KU0VUIHNlYXJjaF9wYXRoIFRP IHB1YmxpYywgdmVjdG9yczsNCkNSRUFURSBUQUJMRSBpdGVtcyAodmFsIHZlY3RvcigzKSwgY2F0 ZWdvcnlfaWQgaW50KSBQQVJUSVRJT04gQlkKTElTVChjYXRlZ29yeV9pZCk7DQpDUkVBVEUgVEFC TEUgaWRfMTIzIFBBUlRJVElPTiBPRiBpdGVtcyBGT1IgVkFMVUVTIElOICgxLCAyLCAzKTsNCkNS RUFURSBUQUJMRSBpZF80NTYgUEFSVElUSU9OIE9GIGl0ZW1zIEZPUiBWQUxVRVMgSU4gKDQsIDUs IDYpOw0KQ1JFQVRFIFRBQkxFIGlkXzc4OSBQQVJUSVRJT04gT0YgaXRlbXMgRk9SIFZBTFVFUyBJ TiAoNywgOCwgOSk7DQpDUkVBVEUgSU5ERVggT04gaXRlbXMgVVNJTkcgdmVjdG9ycyAodmFsIHZl Y3Rvcl9sMl9vcHMpOw0KYGBgDQpUaGUgZXJyb3IgbWVzc2FnZSBpczogYEVSUk9SOiAgb3BlcmF0 b3IgY2xhc3MgInZlY3Rvcl9sMl9vcHMiIGRvZXMgbm90IGV4aXN0CmZvciBhY2Nlc3MgbWV0aG9k ICJ2ZWN0b3JzImANCg0KSWYgSSBkbyBub3QgdXNlIFBBUlRJVElPTiBCWSBhbmQgQ1JFQVRFIFRB QkxFIE9GLCBpdCB3b3JrcyBhbmQgdGhlIG1lc3NhZ2UKaXMgYENSRUFURSBJTkRFWGAuDQoNCkFm dGVyIGRlYnVnZ2luZywgSSBmaW5kIHRoYXQgYERlZmluZUluZGV4YCB3b3VsZCBjYWxsIGBSZXN0 cmljdFNlYXJjaFBhdGhgCmluIGBpbmRleGNtZHMuYzoxMjM0YCBhbmQgYGluZGV4Y21kcy5jOjEz MzRgIGJlZm9yZSBlbnRlcmluZyByZWN1cnNpb24sIHNvCnRoYXQgdGhlIG5lc3RlZCBgRGVmaW5l SW5kZXhgIHdvdWxkIGJlIG9ubHkgYWJsZSB0byBsb29rIHVwIG9wZXJhdG9yIGNsYXNzZXMKaW4g YHBnX2NhdGFsb2csIHBnX3RlbXBgLg0KDQpTaW5jZSB0aGUgYmVoYXZpb3IgYmV0d2VlbiBgQ1JF QVRFIElOREVYYCBhbmQgYENSRUFURSBJTkRFWCBQQVJUSVRJT04gQllgIGlzCmRpZmZlcmVudCwg aXQgc2hvdWxkIGJlIGEgYnVnLgoK --===============2857684022502761458==--