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 1mahwC-0000bA-SL for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 17:21:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mahwB-0004NS-Pz for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 17:21:07 +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 1mahwB-0004KI-Bm for pgsql-hackers@lists.postgresql.org; Wed, 13 Oct 2021 17:21:07 +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 1mahw6-0002NU-76 for pgsql-hackers@postgresql.org; Wed, 13 Oct 2021 17:21:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634145662; x=1665681662; h=from:to:cc:date:message-id:references:in-reply-to: mime-version:subject; bh=gDOlamI0SZ78CroRdgFEzbRgJf6o4Jj5irDPDJ0qG9M=; b=R5DI9zIbr7W/u2r+FkPdYyRNshW2TNew2r95Qz6iBzzKk+TO6H2lxNKX 5/OSh1v8157umwDgawIR6UP7y8jB5fv/OCT703Hq3np/w6iRpi0CaWotJ Q0zajgZ1ehyCSl+2bTRosPaII2swonFmByc15Ob613a2gPL3eq/LPDVIs w=; X-Amazon-filename: disallow_alter_index_column_set.patch X-IronPort-AV: E=Sophos;i="5.85,371,1624320000"; d="scan'208";a="33946857" 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-iad-1e-d3b4d400.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP; 13 Oct 2021 17:20:59 +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-1e-d3b4d400.us-east-1.amazon.com (Postfix) with ESMTPS id 063ACC0893; Wed, 13 Oct 2021 17:20:57 +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 17:20:57 +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 17:20:57 +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 17:20:57 +0000 From: "Bossart, Nathan" To: Dilip Kumar , Michael Paquier CC: Vik Fearing , "postgresql@zr40.nl" , Alexander Korotkov , "pgsql-hackers@postgresql.org" Thread-Index: AQHXvrZqrmi3ZnMZzUia4rdUptiBSKvOFxeAgAGCfgCAALGMAIAAUG2AgAAfCIA= Date: Wed, 13 Oct 2021 17:20:56 +0000 Message-ID: <678CF71A-934B-4FD0-BF63-E41D795E41C9@amazon.com> References: <17220-15d684c6c2171a83@postgresql.org> <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.161.153] Content-Type: multipart/mixed; boundary="_002_678CF71A934B4FD0BF63E41D795E41C9amazoncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_002_678CF71A934B4FD0BF63E41D795E41C9amazoncom_ Content-Type: text/plain; charset="utf-8" Content-ID: <1A333A394681CA4BAD6DDE28E8929F32@amazon.com> Content-Transfer-Encoding: base64 T24gMTAvMTMvMjEsIDE6MzEgQU0sICJEaWxpcCBLdW1hciIgPGRpbGlwYmFsYXV0QGdtYWlsLmNv bT4gd3JvdGU6DQo+IE9uIFdlZCwgT2N0IDEzLCAyMDIxIGF0IDk6MTIgQU0gTWljaGFlbCBQYXF1 aWVyIDxtaWNoYWVsQHBhcXVpZXIueHl6PiB3cm90ZToNCj4+IEFueXdheSwgc3BlY2lmeWluZyBh IGNvbHVtbiBuYW1lIGZvciBhbiBBTFRFUiBJTkRFWCBpcyBub3QgcmlnaHQsIG5vPw0KPj4gSnVz dCB0YWtlIGZvciBleGFtcGxlIHRoZSBjYXNlIG9mIGFuIGV4cHJlc3Npb24gd2hpY2ggaGFzIGEg aGFyZGNvZGVkDQo+PiBjb2x1bW4gbmFtZSBpbiBwZ19hdHRyaWJ1dGUuICBTbyB0aGVzZSBhcmUg bm90IHNwZWNpZmljIHRvIGluZGV4ZXMsDQo+PiB3aGljaCBpcyB3aHkgd2UgYXBwbHkgY29sdW1u IG51bWJlcnMgZm9yIHRoZSBzdGF0aXN0aWNzIGNhc2UuICBJIHRoaW5rDQo+PiB0aGF0IHdlJ2Qg YmV0dGVyIGp1c3QgcmVqZWN0IHRob3NlIGNhc2VzIHVudGlsIHRoZXJlIGlzIGEgcHJvcGVyDQo+ PiBkZXNpZ24gZG9uZSBoZXJlLiAgQXMgZmFyIGFzIEkgY2FuIHNlZSwgSSBndWVzcyB0aGF0IHdl IHNob3VsZCBkbw0KPj4gdGhpbmdzICBzaW1pbGFybHkgdG8gd2hhdCB3ZSBkbyBmb3IgU0VUIFNU QVRJU1RJQ1Mgd2l0aCBjb2x1bW4NCj4+IG51bWJlcnMgd2hlbiBpdCBjb21lcyB0byBpbmRleGVz Lg0KPg0KPiArMSBpdCBzaG91bGQgYmVoYXZlIHNpbWlsYXJseSB0byBTRVQgU1RBVElTVElDUyBm b3IgdGhlIGluZGV4IGFuZCBpZg0KPiBzb21lb25lIHRyaWVzIHRvIHNldCB3aXRoIHRoZSBjb2x1 bW4gbmFtZSB0aGVuIGl0IHNob3VsZCB0aHJvdyBhbg0KPiBlcnJvci4NCg0KR29vZCBwb2ludC4g IEkgYWdyZWUgdGhhdCByZWplY3RpbmcgdGhpcyBjYXNlIGlzIHByb2JhYmx5IHRoZSBiZXN0DQpv cHRpb24gZm9yIG5vdy4gIEluIGFkZGl0aW9uIHRvIHRoZSBidWcgbWVudGlvbmVkIGluIHRoaXMg dGhyZWFkLCB0aGlzDQpmdW5jdGlvbmFsaXR5IGRvZXNuJ3QgZXZlbiB3b3JrIGZvciBzdXBwb3J0 ZWQgb3B0aW9ucyBjdXJyZW50bHkuDQoNCiAgICAgICAgcG9zdGdyZXM9PiBjcmVhdGUgdGFibGUg dGVzdCAoYSB0c3ZlY3Rvcik7DQogICAgICAgIENSRUFURSBUQUJMRQ0KICAgICAgICBwb3N0Z3Jl cz0+IGNyZWF0ZSBpbmRleCBvbiB0ZXN0IHVzaW5nIGdpc3QgKGEpOw0KICAgICAgICBDUkVBVEUg SU5ERVgNCiAgICAgICAgcG9zdGdyZXM9PiBhbHRlciBpbmRleCB0ZXN0X2FfaWR4IGFsdGVyIGNv bHVtbiBhIHNldCAoc2lnbGVuID0gMTAwKTsNCiAgICAgICAgRVJST1I6ICB1bnJlY29nbml6ZWQg cGFyYW1ldGVyICJzaWdsZW4iDQoNCkFGQUlDVCB0aGUgZmFjdCB0aGF0IHRoZXNlIGNvbW1hbmRz IGNhbiBzdWNjZWVkIGF0IGFsbCBzZWVtcyB0byBiZQ0KdW5pbnRlbnRpb25hbCwgYW5kIEkgd29u ZGVyIGlmIG1vZGlmeWluZyB0aGVzZSBvcHRpb25zIHJlcXVpcmVzIGV4dHJhDQpzdGVwcyBzdWNo IGFzIHJlYnVpbGRpbmcgdGhlIGluZGV4Lg0KDQpJJ3ZlIGF0dGFjaGVkIG5ldyBwYXRjaCB0aGF0 IGp1c3QgYWRkcyBhbiBFUlJPUi4NCg0KTmF0aGFuDQoNCg== --_002_678CF71A934B4FD0BF63E41D795E41C9amazoncom_ Content-Type: application/octet-stream; name="disallow_alter_index_column_set.patch" Content-Description: disallow_alter_index_column_set.patch Content-Disposition: attachment; filename="disallow_alter_index_column_set.patch"; size=1956; creation-date="Wed, 13 Oct 2021 17:20:56 GMT"; modification-date="Wed, 13 Oct 2021 17:20:56 GMT" Content-ID: <974F66766CE0D14EBAE33C5D24A59C19@amazon.com> Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jIGIvc3JjL2JhY2tl bmQvY29tbWFuZHMvdGFibGVjbWRzLmMKaW5kZXggMWMyZWJlMWJmNi4uZWIzYzE0NmYyNSAxMDA2 NDQKLS0tIGEvc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMKKysrIGIvc3JjL2JhY2tl bmQvY29tbWFuZHMvdGFibGVjbWRzLmMKQEAgLTgwNDEsNiArODA0MSwxMiBAQCBBVEV4ZWNTZXRP cHRpb25zKFJlbGF0aW9uIHJlbCwgY29uc3QgY2hhciAqY29sTmFtZSwgTm9kZSAqb3B0aW9ucywK IAlib29sCQlyZXBsX251bGxbTmF0dHNfcGdfYXR0cmlidXRlXTsKIAlib29sCQlyZXBsX3JlcGxb TmF0dHNfcGdfYXR0cmlidXRlXTsKIAorCWlmIChyZWwtPnJkX3JlbC0+cmVsa2luZCA9PSBSRUxL SU5EX0lOREVYIHx8CisJCXJlbC0+cmRfcmVsLT5yZWxraW5kID09IFJFTEtJTkRfUEFSVElUSU9O RURfSU5ERVgpCisJCWVyZXBvcnQoRVJST1IsCisJCQkJKGVycmNvZGUoRVJSQ09ERV9GRUFUVVJF X05PVF9TVVBQT1JURUQpLAorCQkJCSBlcnJtc2coImNhbm5vdCBhbHRlciBvcHRpb25zIGZvciBp bmRleCBjb2x1bW4iKSkpOworCiAJYXR0cmVsYXRpb24gPSB0YWJsZV9vcGVuKEF0dHJpYnV0ZVJl bGF0aW9uSWQsIFJvd0V4Y2x1c2l2ZUxvY2spOwogCiAJdHVwbGUgPSBTZWFyY2hTeXNDYWNoZUF0 dE5hbWUoUmVsYXRpb25HZXRSZWxpZChyZWwpLCBjb2xOYW1lKTsKZGlmZiAtLWdpdCBhL3NyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYnRyZWVfaW5kZXgub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9idHJlZV9pbmRleC5vdXQKaW5kZXggYmMxMTNhNzBiNC4uZjgwMzAzYWUzZCAxMDA2 NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9idHJlZV9pbmRleC5vdXQKKysrIGIv c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9idHJlZV9pbmRleC5vdXQKQEAgLTMyOSwzICszMjks NyBAQCBJTlNFUlQgSU5UTyBkZWxldGVfdGVzdF90YWJsZSBTRUxFQ1QgaSwgMSwgMiwgMyBGUk9N IGdlbmVyYXRlX3NlcmllcygxLDEwMDApIGk7CiAtLSBUZXN0IHVuc3VwcG9ydGVkIGJ0cmVlIG9w Y2xhc3MgcGFyYW1ldGVycwogY3JlYXRlIGluZGV4IG9uIGJ0cmVlX3RhbGxfdGJsIChpZCBpbnQ0 X29wcyhmb289MSkpOwogRVJST1I6ICBvcGVyYXRvciBjbGFzcyBpbnQ0X29wcyBoYXMgbm8gb3B0 aW9ucworY3JlYXRlIGluZGV4IG9uIGJ0cmVlX3RhbGxfdGJsIChpZCk7CithbHRlciBpbmRleCBi dHJlZV90YWxsX3RibF9pZF9pZHggYWx0ZXIgY29sdW1uIGlkIHNldCAobl9kaXN0aW5jdD0xMDAp OworRVJST1I6ICBjYW5ub3QgYWx0ZXIgb3B0aW9ucyBmb3IgaW5kZXggY29sdW1uCitkcm9wIGlu ZGV4IGJ0cmVlX3RhbGxfdGJsX2lkX2lkeDsKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2J0cmVlX2luZGV4LnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2J0cmVlX2luZGV4LnNx bAppbmRleCBjNjAzMTJkYjJkLi4zNTE5ZDgwNjk2IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdy ZXNzL3NxbC9idHJlZV9pbmRleC5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvYnRyZWVf aW5kZXguc3FsCkBAIC0xNzIsMyArMTcyLDcgQEAgSU5TRVJUIElOVE8gZGVsZXRlX3Rlc3RfdGFi bGUgU0VMRUNUIGksIDEsIDIsIDMgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwKSBpOwogCiAt LSBUZXN0IHVuc3VwcG9ydGVkIGJ0cmVlIG9wY2xhc3MgcGFyYW1ldGVycwogY3JlYXRlIGluZGV4 IG9uIGJ0cmVlX3RhbGxfdGJsIChpZCBpbnQ0X29wcyhmb289MSkpOworCitjcmVhdGUgaW5kZXgg b24gYnRyZWVfdGFsbF90YmwgKGlkKTsKK2FsdGVyIGluZGV4IGJ0cmVlX3RhbGxfdGJsX2lkX2lk eCBhbHRlciBjb2x1bW4gaWQgc2V0IChuX2Rpc3RpbmN0PTEwMCk7Citkcm9wIGluZGV4IGJ0cmVl X3RhbGxfdGJsX2lkX2lkeDsK --_002_678CF71A934B4FD0BF63E41D795E41C9amazoncom_--