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 1maTtM-0002QF-Sn for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 02:21:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maTsq-0000eB-89 for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 02:20:44 +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 1maTsp-0000e3-Vc for pgsql-hackers@lists.postgresql.org; Wed, 13 Oct 2021 02:20:43 +0000 Received: from smtp-fw-33001.amazon.com ([207.171.190.10]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maTsn-0003PK-Vg for pgsql-hackers@postgresql.org; Wed, 13 Oct 2021 02:20:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634091642; x=1665627642; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=ljK+kA9J5+pxm/yQSUKbHWYNx0L0wwqrExNl/hP0bGk=; b=EMV5VYqyG487EWIfIz5HJhaEoKPx5tRWbXXVkThpNF68EdI05KyWmSYs 8yZiK3qM7+OKTrzHqv/GY0RYk6iOpVqYg/y9XVDPh/rp7BDHhSS8xYIie UiojlbLrYaSlnCauF6xVkv5TQ9XYsTZIg+7VU00lwjTR9X9BEsTSgNubO k=; X-IronPort-AV: E=Sophos;i="5.85,369,1624320000"; d="scan'208";a="153197664" 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-1e-0bfdb89e.us-east-1.amazon.com) ([10.43.8.2]) by smtp-border-fw-33001.sea14.amazon.com with ESMTP; 13 Oct 2021 02:20:39 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1e-0bfdb89e.us-east-1.amazon.com (Postfix) with ESMTPS id 1E279E00F4; Wed, 13 Oct 2021 02:20:39 +0000 (UTC) Received: from EX13D03UWC003.ant.amazon.com (10.43.162.79) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Wed, 13 Oct 2021 02:20:30 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC003.ant.amazon.com (10.43.162.79) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Wed, 13 Oct 2021 02:20:29 +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.023; Wed, 13 Oct 2021 02:20:29 +0000 From: "Bossart, Nathan" To: Vik Fearing , "postgresql@zr40.nl" , Alexander Korotkov CC: "pgsql-hackers@postgresql.org" Thread-Index: AQHXvrZqrmi3ZnMZzUia4rdUptiBSKvOFxeAgAGCfgCAAHvygP//qXoA Date: Wed, 13 Oct 2021 02:20:29 +0000 Message-ID: <31196DBC-0356-493A-8692-4F333039C3D3@amazon.com> References: <17220-15d684c6c2171a83@postgresql.org> <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> <706b30e0-2bfc-7e1c-6149-a36ff7a5096a@postgresfriends.org> In-Reply-To: <706b30e0-2bfc-7e1c-6149-a36ff7a5096a@postgresfriends.org> 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.160.106] Content-Type: text/plain; charset="utf-8" Content-ID: <0D9C86C6FD23B04F97A304A6C20D528D@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 T24gMTAvMTIvMjEsIDU6MzEgUE0sICJWaWsgRmVhcmluZyIgPHZpa0Bwb3N0Z3Jlc2ZyaWVuZHMu b3JnPiB3cm90ZToNCj4gT24gMTAvMTMvMjEgMjowNiBBTSwgQm9zc2FydCwgTmF0aGFuIHdyb3Rl Og0KPj4gTW92aW5nIHRvIHBnc3FsLWhhY2tlcnNALg0KPj4NCj4+IEF0IGZpcnN0IGdsYW5jZSwg aXQgbG9va3MgbGlrZSBBTFRFUiBJTkRFWCAuLiBBTFRFUiBDT0xVTU4gLi4uIFNFVA0KPj4gdXNl cyB0aGUgd3JvbmcgdmFsaWRhdGlvbiBmdW5jdGlvbi4gIEkndmUgYXR0YWNoZWQgYSBwYXRjaCB3 aGVyZSBJJ3ZlDQo+PiBhdHRlbXB0ZWQgdG8gZml4IHRoYXQgYW5kIGFkZGVkIHNvbWUgdGVzdHMu DQo+DQo+IEFoLCB0aGFuayB5b3UuICBJIHdhcyBpbiB0aGUgKHNsb3cpIHByb2Nlc3Mgb2Ygd3Jp dGluZyBiYXNpY2FsbHkgdGhpcw0KPiBleGFjdCBwYXRjaC4gIFNvIEknbGwgc3RvcCBub3cgYW5k IGVuZG9yc2UgeW91cnMuDQoNCk9vcHMsIHNvcnJ5IGFib3V0IHRoYXQuICBUaGFua3MgZm9yIHRo ZSBlbmRvcnNlbWVudC4NCg0KTmF0aGFuDQoNCg==