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 1mcfUN-0005cP-RB for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Oct 2021 03:08:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcfTr-0004Ca-8Q for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Oct 2021 03:07:59 +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 1mcfTq-0004CN-U7 for pgsql-hackers@lists.postgresql.org; Tue, 19 Oct 2021 03:07:58 +0000 Received: from smtp-fw-80006.amazon.com ([99.78.197.217]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcfTo-00031A-MP for pgsql-hackers@postgresql.org; Tue, 19 Oct 2021 03:07:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634612877; x=1666148877; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=7w2+Gf5GwdC8OhxaQtLyH0JPPFPyIQJclWMr5iV7BSo=; b=E/Ys2ZNjrTS/K6/jK+RG/89pnKw1FCPD4ea3lg3zl30ayb9Sq8dyKBc9 99V4nKJLUL0jTfO9/fKJWzE8u80tiNbCw8k3QpUtZswcCDHjaG0Wkm5r3 Q+nPtzF+o1Ty9LJnctw8dZ0B/Bw+LNy/m09ZYT7IrsUB2j8RT1sH3EuJL 0=; X-IronPort-AV: E=Sophos;i="5.85,383,1624320000"; d="scan'208";a="35078725" 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-vlan3.amazon.com (HELO email-inbound-relay-pdx-2c-b09ea7fa.us-west-2.amazon.com) ([10.25.36.214]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP; 19 Oct 2021 03:07:54 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-pdx-2c-b09ea7fa.us-west-2.amazon.com (Postfix) with ESMTPS id 5CFBC41AA1; Tue, 19 Oct 2021 03:07:53 +0000 (UTC) Received: from EX13D03UWC003.ant.amazon.com (10.43.162.79) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Tue, 19 Oct 2021 03:07:52 +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.24; Tue, 19 Oct 2021 03:07:52 +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 03:07:52 +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: AQHXvrZqrmi3ZnMZzUia4rdUptiBSKvOFxeAgAGCfgCAALGMAIAAUG2AgAAfCICAAQhugIAGqCEAgAB0mACAAL8lAP//m1mA Date: Tue, 19 Oct 2021 03:07:51 +0000 Message-ID: References: <17220-15d684c6c2171a83@postgresql.org> <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> <678CF71A-934B-4FD0-BF63-E41D795E41C9@amazon.com> <355E7866-D1F3-4533-BE6C-17DBDA6A2ADD@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.160.243] Content-Type: text/plain; charset="utf-8" Content-ID: <8686F89C901A334CBB06D0B828DFE7E1@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 T24gMTAvMTgvMjEsIDc6MDkgUE0sICJNaWNoYWVsIFBhcXVpZXIiIDxtaWNoYWVsQHBhcXVpZXIu eHl6PiB3cm90ZToNCj4gVGhhbmtzIGZvciBkb3VibGUtY2hlY2tpbmcuICBBcHBsaWVkIGFuZCBi YWNrLXBhdGNoZWQsIHdpdGggYSBzbWFsbA0KPiBjb25mbGljdCByZWdhcmRpbmcgdGhlIGVycm9y IG1lc3NhZ2UgaW4gfjE0Lg0KDQpUaGFua3MhDQoNCk5hdGhhbg0KDQo=