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 1mcqHm-0007cd-8i for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Oct 2021 14:40:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcqHl-0005fo-7C for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Oct 2021 14:40:13 +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 1mcqHk-0005fe-Sm for pgsql-hackers@lists.postgresql.org; Tue, 19 Oct 2021 14:40:12 +0000 Received: from smtp-fw-9103.amazon.com ([207.171.188.200]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcqHg-0008WR-GN for pgsql-hackers@postgresql.org; Tue, 19 Oct 2021 14:40:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634654408; x=1666190408; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=7QWEsKXbSVrRsbl7UyLEH5ynFy0vzzPXx8j2Ygw1fyY=; b=Vz3A7BgbgenTHPj8uAqMTDcSIY7Fta0qVBWZGeeQL0Yt7BkTI78XORry SiGY+dlnQgyQa2zXsUL0J+xM+SO/W40rqW31E1RYC0ydvnpfldqWwLRNT 3b5xKTh4RsYQ+S5vVaSbOAwFOjY9g22PV61T6u9UKEf8wwDBWzVDEmUlb U=; X-IronPort-AV: E=Sophos;i="5.87,164,1631577600"; d="scan'208";a="965728418" Subject: Re: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable Thread-Topic: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-pdx-2b-02ee77e7.us-west-2.amazon.com) ([10.25.36.210]) by smtp-border-fw-9103.sea19.amazon.com with ESMTP; 19 Oct 2021 14:40:06 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2b-02ee77e7.us-west-2.amazon.com (Postfix) with ESMTPS id A5CDC42477; Tue, 19 Oct 2021 14:40:06 +0000 (UTC) Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Tue, 19 Oct 2021 14:40:05 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Tue, 19 Oct 2021 14:40:05 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.024; Tue, 19 Oct 2021 14:40:05 +0000 From: "Bossart, Nathan" To: Matthijs van der Vleuten , Michael Paquier CC: Dilip Kumar , Vik Fearing , Alexander Korotkov , "pgsql-hackers@postgresql.org" , Robert Haas Thread-Index: AQHXvrZqrmi3ZnMZzUia4rdUptiBSKvOFxeAgAGCfgCAALGMAIAAUG2AgAAfCICAAQhugIAGqCEAgAGB94CAAA6GAA== Date: Tue, 19 Oct 2021 14:40:04 +0000 Message-ID: <34B9319E-8FF3-4303-A94D-BCDBCDC7ED2C@amazon.com> References: <17220-15d684c6c2171a83@postgresql.org> <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> <678CF71A-934B-4FD0-BF63-E41D795E41C9@amazon.com> <1ec02758-652e-48fa-afbf-c1d5ed5f06e2@www.fastmail.com> In-Reply-To: <1ec02758-652e-48fa-afbf-c1d5ed5f06e2@www.fastmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.162.57] Content-Type: text/plain; charset="utf-8" Content-ID: <43AD3633241EEE44936BA2CFB6484687@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTAvMTgvMjEsIDExOjQ5IFBNLCAiTWF0dGhpanMgdmFuIGRlciBWbGV1dGVuIiA8cG9zdGdy ZXNxbEB6cjQwLm5sPiB3cm90ZToNCj4gVGhlIHRlc3QgY2FzZSBkb2Vzbid0IHNlZW0gZW50aXJl bHkgY29ycmVjdCB0byBtZT8gVGhlIGluZGV4IGJlaW5nDQo+IGRyb3BwZWQgKGJ0cmVlX3RhbGxf dGJsX2lkeDIpIGRvZXNuJ3QgZXhpc3QuDQoNClRoaXMgd2FzIGZpeGVkIGJlZm9yZSBpdCB3YXMg Y29tbWl0dGVkIFswXS4NCg0KPiBBbHNvLCBJIGRvbid0IGJlbGlldmUgdGhpcyB0ZXN0cyB0aGUg Y2FzZSBvZiBkcm9wcGluZyB0aGUgaW5kZXggd2hlbg0KPiBpdCBwcmV2aW91c2x5IGhhcyBiZWVu IGFsdGVyZWQgaW4gdGhpcyB3YXkuDQoNClRoYXQgY2FuIHN0aWxsIGZhaWwgd2l0aCB0aGUgImhh cyBubyBvcHRpb25zIiBFUlJPUiwgYW5kIGZpeGluZyBpdA0Kd2lsbCBzdGlsbCByZXF1aXJlIGEg bWFudWFsIGNhdGFsb2cgdXBkYXRlLiAgVGhlIEVSUk9SIGlzIGFjdHVhbGx5DQpjb21pbmcgZnJv bSB0aGUgY2FsbCB0byBpbmRleF9vcGVuKCksIHNvIGJ5cGFzc2luZyBpdCBtaWdodCByZXF1aXJl DQpzb21lIHJhdGhlciBpbnRydXNpdmUgY2hhbmdlcy4gIEdpdmVuIHRoYXQgaXQgdG9vayBvdmVy IGEgeWVhciBmb3INCnRoaXMgYnVnIHRvIGJlIHJlcG9ydGVkLCBJIHN1c3BlY3QgaXQgbWlnaHQg YmUgbW9yZSB0cm91YmxlIHRoYW4gaXQncw0Kd29ydGguDQoNCk5hdGhhbg0KDQpbMF0gaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvZ2l0d2ViLz9wPXBvc3RncmVzcWwuZ2l0O2E9Y29tbWl0O2g9 ZmRkODg1Nw0KDQo=