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 1mcaQU-0005Cg-Hd for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Oct 2021 21:44:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcaQR-0006XO-BK for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Oct 2021 21:44:07 +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 1mcaQR-0006XF-0R for pgsql-hackers@lists.postgresql.org; Mon, 18 Oct 2021 21:44:07 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcaQO-0002yo-IU for pgsql-hackers@postgresql.org; Mon, 18 Oct 2021 21:44:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634593445; x=1666129445; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=d+JyaMLLVyKFtYT/+fLf5Yo2EBeSrwx29IpwjKBPDQg=; b=mvWlCzfUn71DAL8T1DsQ539AkOieCk2QuWGXC4zcWyhl1Qg9so5BkYzK 2PRwOjHejW9VVzSlV68Eqp15bExAk6r22XVXKRfSOyzDmC/i/0MbWtWPC 6fPWTWWePky2P/Aelcoqa3HqK6IoKTI7N/u5TwGnbjtuDESdjfVKV7hiL c=; X-IronPort-AV: E=Sophos;i="5.85,382,1624320000"; d="scan'208";a="145510223" 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 iad12-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-iad-1a-8691d7ea.us-east-1.amazon.com) ([10.43.8.2]) by smtp-border-fw-2101.iad2.amazon.com with ESMTP; 18 Oct 2021 21:44:02 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan2.iad.amazon.com [10.40.163.34]) by email-inbound-relay-iad-1a-8691d7ea.us-east-1.amazon.com (Postfix) with ESMTPS id 17124C0925; Mon, 18 Oct 2021 21:43:59 +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; Mon, 18 Oct 2021 21:43:59 +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; Mon, 18 Oct 2021 21:43:59 +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; Mon, 18 Oct 2021 21:43:59 +0000 From: "Bossart, Nathan" To: Michael Paquier CC: Dilip Kumar , Vik Fearing , "postgresql@zr40.nl" , Alexander Korotkov , "pgsql-hackers@postgresql.org" , Robert Haas Thread-Index: AQHXvrZqrmi3ZnMZzUia4rdUptiBSKvOFxeAgAGCfgCAALGMAIAAUG2AgAAfCICAAQhugIAGqCEAgAB0mAA= Date: Mon, 18 Oct 2021 21:43:58 +0000 Message-ID: <355E7866-D1F3-4533-BE6C-17DBDA6A2ADD@amazon.com> References: <17220-15d684c6c2171a83@postgresql.org> <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> <678CF71A-934B-4FD0-BF63-E41D795E41C9@amazon.com> In-Reply-To: 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: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTAvMTgvMjEsIDEyOjQ3IEFNLCAiTWljaGFlbCBQYXF1aWVyIiA8bWljaGFlbEBwYXF1aWVy Lnh5ej4gd3JvdGU6DQo+IEkgaGF2ZSByZXZpZXdlZCB0aGUgbGFzdCBwYXRjaCBwb3N0ZWQgdXB0 aHJlYWQsIGFuZCB3aGlsZSB0ZXN0aW5nDQo+IHBhcnRpdGlvbmVkIGluZGV4ZXMgSSBoYXZlIG5v dGljZWQgdGhhdCB3ZSBkb24ndCBuZWVkIHRvIGRvIGEgY3VzdG9tDQo+IGNoZWNrIGFzIHBhcnQg b2YgQVRFeGVjU2V0T3B0aW9ucygpLCBiZWNhdXNlIHdlIGhhdmUgYWxyZWFkeSB0aGF0IGluDQo+ IEFUU2ltcGxlUGVybWlzc2lvbnMoKSB3aXRoIGRldGFpbHMgb24gdGhlIHJlbGtpbmQgZmFpbGlu Zy4gIFRoaXMgbWFrZXMNCj4gdGhlIHBhdGNoIHNpbXBsZXIsIHdpdGggYSBiZXR0ZXIgZXJyb3Ig bWVzc2FnZSBnZW5lcmF0ZWQuICBJIGhhdmUNCj4gYWRkZWQgYSBjYXNlIGZvciBwYXJ0aXRpb25l ZCBpbmRleGVzIHdoaWxlIG9uIGl0Lg0KDQpBaCwgeWVzLCB0aGF0IGlzIG11Y2ggYmV0dGVyLg0K DQo+IEF0dGFjaGVkIGlzIHRoZSBwYXRjaCBJIGFtIGZpbmlzaGluZyB3aXRoLCB0aGF0IHNob3Vs ZCBnbyBkb3duIHRvDQo+IHYxMyAodGhpcyBpcyBnb2luZyB0byBjb25mbGljdCBvbiBSRUxfMTNf U1RBQkxFLCBmb3Igc3VyZSkuDQoNCitEUk9QIElOREVYIGJ0cmVlX3RhbGxfdGJsX2lkeDI7DQor RVJST1I6ICBpbmRleCAiYnRyZWVfdGFsbF90YmxfaWR4MiIgZG9lcyBub3QgZXhpc3QNCg0KSSB0 aGluayB0aGlzIGlzIHN1cHBvc2VkIHRvIGJlICJidHJlZV90YWxsX2lkeDIiLiAgT3RoZXJ3aXNl LCB0aGUNCnBhdGNoIGxvb2tzIHJlYXNvbmFibGUgdG8gbWUuDQoNCk5hdGhhbg0KDQo=