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 1mZxPg-0006uV-JY for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Oct 2021 15:40:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mZxPe-0006pZ-Ty for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Oct 2021 15:40:26 +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 1mZxBq-0006xZ-Fg for pgsql-bugs@lists.postgresql.org; Mon, 11 Oct 2021 15:26:10 +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 1mZxBl-0002ob-Bk for pgsql-bugs@lists.postgresql.org; Mon, 11 Oct 2021 15:26: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=QSkYVSMHur+q9TbFs7GlJHfB/Bp11KeMsk/NTSCjiJY=; b=yXZxBRSwtwRWvhI6PMoRK93d5H aDF+qjKuXXaRVnWu4XwF3vpb6qCoRjkIQcLF8aSdK94gqTMbC1TApm7MpVgQI3JuADhmTHDcIcm+F 7GmEFEcsueiKgIkiGLiUGF8nx7L5hVg9E3pfkG3TyQ4F86g6jSlpUv5ZrWm3JNWzmWYUybNn68YAc MyEljeCnFmOQFt89VJX+K/X1BUYwUz+vuCo/THrGSqym0pmaOdJYL5/t0Zo1PxTuyk4Bl3NuExm/V iNg6FRvFgVjLNV5KFU2xFEDvGVyZVMyKTEiyS51GzFUb6G24YVEnYQL01JkohE2FYGa9dDfaeHGWq RpqBf45Q==; 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 1mZxBk-0001SL-So for pgsql-bugs@lists.postgresql.org; Mon, 11 Oct 2021 15:26:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mZxBi-0003yq-JX for pgsql-bugs@lists.postgresql.org; Mon, 11 Oct 2021 15:26:02 +0000 Content-Type: multipart/mixed; boundary="===============1352760926970177122==" MIME-Version: 1.0 Subject: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: postgresql@zr40.nl Reply-To: postgresql@zr40.nl, pgsql-bugs@lists.postgresql.org Date: Mon, 11 Oct 2021 15:25:49 +0000 Message-ID: <17220-15d684c6c2171a83@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 --===============1352760926970177122== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzIyMApMb2dnZWQgYnk6ICAgICAgICAgIE1hdHRoaWpzIHZhbiBkZXIg VmxldXRlbgpFbWFpbCBhZGRyZXNzOiAgICAgIHBvc3RncmVzcWxAenI0MC5ubApQb3N0Z3JlU1FM IHZlcnNpb246IDE0LjAKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gc2lkCkRlc2NyaXB0aW9u OiAgICAgICAgCgpVc2VyICdtdXN0dHUnIG9uIElSQyByZXBvcnRlZCB0aGUgZm9sbG93aW5nIGJ1 ZzogQWZ0ZXIgcnVubmluZyAiQUxURVIgSU5ERVgKc29tZV9pZHggQUxURVIgQ09MVU1OIGV4cHIg U0VUIChuX2Rpc3RpbmN0PTEwMCkiLCB0aGUgaW5kZXggYW5kIHRhYmxlIGJlY29tZQp1bnVzYWJs ZS4gQWxsIGZ1cnRoZXIgc3RhdGVtZW50cyBpbnZvbHZpbmcgdGhlIHRhYmxlIHJlc3VsdCBpbjog IkVSUk9SOiAKb3BlcmF0b3IgY2xhc3MgdGV4dF9vcHMgaGFzIG5vIG9wdGlvbnMiLg0KDQpUaGV5 IHJlcG9ydGVkIHRoaXMgb24gdGhlIFJEUyB2ZXJzaW9uIG9mIDEzLjMsIGJ1dCBJJ3ZlIGJlZW4g YWJsZSB0bwpyZXByb2R1Y2UgdGhpcyBvbiBEZWJpYW4gd2l0aCAxMy40IGFuZCAxNC4wLiBJdCBk b2VzIG5vdCByZXByb2R1Y2Ugb24gMTIuOCwKYWxsIHN0YXRlbWVudHMgc3VjY2VlZCBvbiB0aGF0 IHZlcnNpb24uDQoNCkFzIGEgd29ya2Fyb3VuZCwgSSd2ZSBzdWdnZXN0ZWQgdGhlIGZvbGxvd2lu ZyBjYXRhbG9nIGNoYW5nZSBpbiBvcmRlciB0byBiZQphYmxlIHRvIGRyb3AgdGhlIGluZGV4Og0K VVBEQVRFIHBnX2F0dHJpYnV0ZSBTRVQgYXR0b3B0aW9ucyA9IE5VTEwgV0hFUkUgYXR0cmVsaWQg PQondGJsX2NvbF9pZHgnOjpyZWdjbGFzczsNCkhvd2V2ZXIsIHRoZXkgd2VyZSBub3QgYWJsZSB0 byBkbyB0aGlzLCBzaW5jZSBSRFMgZG9lcyBub3QgZXhwb3NlIGEgdHJ1ZQpzdXBlcnVzZXIuDQoN ClJlcHJvZHVjdGlvbjoNCnpyNDBAW2xvY2FsXTo1NDMyIH49IyBzZWxlY3QgdmVyc2lvbigpOw0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJz aW9uICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQrilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIANCiBQb3N0Z3JlU1FMIDE0LjAgKERlYmlhbiAxNC4wLTEucGdkZysxKSBvbiB4ODZfNjQtcGMt bGludXgtZ251LCBjb21waWxlZCBieQpnY2MgKERlYmlhbiAxMC4zLjAtMTEpIDEwLjMuMCwgNjQt Yml0DQooMSByb3cpDQp6cjQwQFtsb2NhbF06NTQzMiB+PSMgY3JlYXRlIHRhYmxlIHRlc3QgKGNv bCB0ZXh0KTsNCkNSRUFURSBUQUJMRQ0KenI0MEBbbG9jYWxdOjU0MzIgfj0jIGNyZWF0ZSBpbmRl eCBvbiB0ZXN0IChjb2wpOw0KQ1JFQVRFIElOREVYDQp6cjQwQFtsb2NhbF06NTQzMiB+PSMgYWx0 ZXIgaW5kZXggdGVzdF9jb2xfaWR4IGFsdGVyIGNvbHVtbiBjb2wgc2V0CihuX2Rpc3RpbmN0PTEw MCk7DQpBTFRFUiBJTkRFWA0KenI0MEBbbG9jYWxdOjU0MzIgfj0jIGFsdGVyIGluZGV4IHRlc3Rf Y29sX2lkeCBhbHRlciBjb2x1bW4gY29sIHJlc2V0CihuX2Rpc3RpbmN0KTsNCkVSUk9SOiAgMjIw MjM6IG9wZXJhdG9yIGNsYXNzIHRleHRfb3BzIGhhcyBubyBvcHRpb25zDQpMT0NBVElPTjogIGlu ZGV4X29wY2xhc3Nfb3B0aW9ucywgaW5kZXhhbS5jOjk3MQ0KenI0MEBbbG9jYWxdOjU0MzIgfj0j IGRyb3AgaW5kZXggdGVzdF9jb2xfaWR4Ow0KRVJST1I6ICAyMjAyMzogb3BlcmF0b3IgY2xhc3Mg dGV4dF9vcHMgaGFzIG5vIG9wdGlvbnMNCkxPQ0FUSU9OOiAgaW5kZXhfb3BjbGFzc19vcHRpb25z LCBpbmRleGFtLmM6OTcxDQp6cjQwQFtsb2NhbF06NTQzMiB+PSMgZHJvcCB0YWJsZSB0ZXN0Ow0K RVJST1I6ICAyMjAyMzogb3BlcmF0b3IgY2xhc3MgdGV4dF9vcHMgaGFzIG5vIG9wdGlvbnMNCkxP Q0FUSU9OOiAgaW5kZXhfb3BjbGFzc19vcHRpb25zLCBpbmRleGFtLmM6OTcxCgo= --===============1352760926970177122==--