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 1maRn9-0005oi-IR for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 00:06:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maRn5-0002Kv-Rt for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 00:06:39 +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 1maRn5-0002Kk-Db for pgsql-hackers@lists.postgresql.org; Wed, 13 Oct 2021 00:06:39 +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 1maRn3-0002Ek-6Q for pgsql-hackers@postgresql.org; Wed, 13 Oct 2021 00:06:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634083598; x=1665619598; h=from:to:cc:date:message-id:references:in-reply-to: mime-version:subject; bh=HWujrPmDbJk/cRj4r49os7vnKXzSOIqq3/JtMYy+MYY=; b=lwE4KOhLhohIMI40ca8y/xA8cmQEGhSnO1+wGVKnSWUOGlGUj7rWLsdQ JG1ZOiPUilpYM7MaAXqYx76ezBzNv2WtLvSHpwRr143DfMgdZbAhzwJWN G0gpd/s7P3Pgw1WD0c70fLyAWd/Rn7FBj4n0d+WtWBY4bUISqwkJF2ndU 4=; X-Amazon-filename: alter_index_column_set_validation.patch X-IronPort-AV: E=Sophos;i="5.85,369,1624320000"; d="scan'208";a="33731024" 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-1a-4ba5c7da.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP; 13 Oct 2021 00:06:36 +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-4ba5c7da.us-east-1.amazon.com (Postfix) with ESMTPS id BA8C4220041; Wed, 13 Oct 2021 00:06:33 +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.23; Wed, 13 Oct 2021 00:06:33 +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.23; Wed, 13 Oct 2021 00:06:33 +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 00:06:33 +0000 From: "Bossart, Nathan" To: Vik Fearing , "postgresql@zr40.nl" , Alexander Korotkov CC: "pgsql-hackers@postgresql.org" Thread-Index: AQHXvrZqrmi3ZnMZzUia4rdUptiBSKvOFxeAgAGCfgA= Date: Wed, 13 Oct 2021 00:06:32 +0000 Message-ID: References: <17220-15d684c6c2171a83@postgresql.org> <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> In-Reply-To: <9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org> 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.162.36] Content-Type: multipart/mixed; boundary="_002_E29EF33BCA1A4146BFCFC8EC08FB91A8amazoncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_002_E29EF33BCA1A4146BFCFC8EC08FB91A8amazoncom_ Content-Type: text/plain; charset="utf-8" Content-ID: <771B255245ABA242A168EA81F162A5A6@amazon.com> Content-Transfer-Encoding: base64 T24gMTAvMTEvMjEsIDExOjAzIEFNLCAiVmlrIEZlYXJpbmciIDx2aWtAcG9zdGdyZXNmcmllbmRz Lm9yZz4gd3JvdGU6DQo+IE9uIDEwLzExLzIxIDU6MjUgUE0sIFBHIEJ1ZyByZXBvcnRpbmcgZm9y bSB3cm90ZToNCj4+DQo+PiBVc2VyICdtdXN0dHUnIG9uIElSQyByZXBvcnRlZCB0aGUgZm9sbG93 aW5nIGJ1ZzogQWZ0ZXIgcnVubmluZyAiQUxURVIgSU5ERVgNCj4+IHNvbWVfaWR4IEFMVEVSIENP TFVNTiBleHByIFNFVCAobl9kaXN0aW5jdD0xMDApIiwgdGhlIGluZGV4IGFuZCB0YWJsZSBiZWNv bWUNCj4+IHVudXNhYmxlLiBBbGwgZnVydGhlciBzdGF0ZW1lbnRzIGludm9sdmluZyB0aGUgdGFi bGUgcmVzdWx0IGluOiAiRVJST1I6DQo+PiBvcGVyYXRvciBjbGFzcyB0ZXh0X29wcyBoYXMgbm8g b3B0aW9ucyIuDQo+Pg0KPj4gVGhleSByZXBvcnRlZCB0aGlzIG9uIHRoZSBSRFMgdmVyc2lvbiBv ZiAxMy4zLCBidXQgSSd2ZSBiZWVuIGFibGUgdG8NCj4+IHJlcHJvZHVjZSB0aGlzIG9uIERlYmlh biB3aXRoIDEzLjQgYW5kIDE0LjAuIEl0IGRvZXMgbm90IHJlcHJvZHVjZSBvbiAxMi44LA0KPj4g YWxsIHN0YXRlbWVudHMgc3VjY2VlZCBvbiB0aGF0IHZlcnNpb24uDQo+DQo+IFRoaXMgd2FzIGJy b2tlbiBieSA5MTFlNzAyMDc3IChJbXBsZW1lbnQgb3BlcmF0b3IgY2xhc3MgcGFyYW1ldGVycyku DQoNCk1vdmluZyB0byBwZ3NxbC1oYWNrZXJzQC4NCg0KQXQgZmlyc3QgZ2xhbmNlLCBpdCBsb29r cyBsaWtlIEFMVEVSIElOREVYIC4uIEFMVEVSIENPTFVNTiAuLi4gU0VUDQp1c2VzIHRoZSB3cm9u ZyB2YWxpZGF0aW9uIGZ1bmN0aW9uLiAgSSd2ZSBhdHRhY2hlZCBhIHBhdGNoIHdoZXJlIEkndmUN CmF0dGVtcHRlZCB0byBmaXggdGhhdCBhbmQgYWRkZWQgc29tZSB0ZXN0cy4NCg0KTmF0aGFuDQoN Cg== --_002_E29EF33BCA1A4146BFCFC8EC08FB91A8amazoncom_ Content-Type: application/octet-stream; name="alter_index_column_set_validation.patch" Content-Description: alter_index_column_set_validation.patch Content-Disposition: attachment; filename="alter_index_column_set_validation.patch"; size=4215; creation-date="Wed, 13 Oct 2021 00:06:32 GMT"; modification-date="Wed, 13 Oct 2021 00:06:32 GMT" Content-ID: Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jIGIvc3JjL2JhY2tl bmQvY29tbWFuZHMvdGFibGVjbWRzLmMKaW5kZXggMWMyZWJlMWJmNi4uZjY4ZTg2NDY3YiAxMDA2 NDQKLS0tIGEvc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMKKysrIGIvc3JjL2JhY2tl bmQvY29tbWFuZHMvdGFibGVjbWRzLmMKQEAgLTgwNjYsNyArODA2NiwxMSBAQCBBVEV4ZWNTZXRP cHRpb25zKFJlbGF0aW9uIHJlbCwgY29uc3QgY2hhciAqY29sTmFtZSwgTm9kZSAqb3B0aW9ucywK IAkJCQkJCQkJCSBjYXN0Tm9kZShMaXN0LCBvcHRpb25zKSwgTlVMTCwgTlVMTCwKIAkJCQkJCQkJ CSBmYWxzZSwgaXNSZXNldCk7CiAJLyogVmFsaWRhdGUgbmV3IG9wdGlvbnMgKi8KLQkodm9pZCkg YXR0cmlidXRlX3JlbG9wdGlvbnMobmV3T3B0aW9ucywgdHJ1ZSk7CisJaWYgKHJlbC0+cmRfcmVs LT5yZWxraW5kID09IFJFTEtJTkRfSU5ERVggfHwKKwkJcmVsLT5yZF9yZWwtPnJlbGtpbmQgPT0g UkVMS0lORF9QQVJUSVRJT05FRF9JTkRFWCkKKwkJKHZvaWQpIGluZGV4X29wY2xhc3Nfb3B0aW9u cyhyZWwsIGF0dG51bSwgbmV3T3B0aW9ucywgdHJ1ZSk7CisJZWxzZQorCQkodm9pZCkgYXR0cmli dXRlX3JlbG9wdGlvbnMobmV3T3B0aW9ucywgdHJ1ZSk7CiAKIAkvKiBCdWlsZCBuZXcgdHVwbGUu ICovCiAJbWVtc2V0KHJlcGxfbnVsbCwgZmFsc2UsIHNpemVvZihyZXBsX251bGwpKTsKZGlmZiAt LWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYnRyZWVfaW5kZXgub3V0IGIvc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9idHJlZV9pbmRleC5vdXQKaW5kZXggYmMxMTNhNzBiNC4uZmM1 ZjhiNWZiMSAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9idHJlZV9pbmRl eC5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9idHJlZV9pbmRleC5vdXQKQEAg LTMyOSwzICszMjksNiBAQCBJTlNFUlQgSU5UTyBkZWxldGVfdGVzdF90YWJsZSBTRUxFQ1QgaSwg MSwgMiwgMyBGUk9NIGdlbmVyYXRlX3NlcmllcygxLDEwMDApIGk7CiAtLSBUZXN0IHVuc3VwcG9y dGVkIGJ0cmVlIG9wY2xhc3MgcGFyYW1ldGVycwogY3JlYXRlIGluZGV4IG9uIGJ0cmVlX3RhbGxf dGJsIChpZCBpbnQ0X29wcyhmb289MSkpOwogRVJST1I6ICBvcGVyYXRvciBjbGFzcyBpbnQ0X29w cyBoYXMgbm8gb3B0aW9ucworY3JlYXRlIGluZGV4IG9uIGJ0cmVlX3RhbGxfdGJsIChpZCk7Cith bHRlciBpbmRleCBidHJlZV90YWxsX3RibF9pZF9pZHggYWx0ZXIgY29sdW1uIGlkIHNldCAobmRp c3RpbmN0PTEwMCk7CitFUlJPUjogIG9wZXJhdG9yIGNsYXNzIGludDRfb3BzIGhhcyBubyBvcHRp b25zCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3RzZWFyY2gub3V0IGIv c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC90c2VhcmNoLm91dAppbmRleCA0NWI5MmE2MzM4Li40 ODU2MWQ0ODUzIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3RzZWFyY2gu b3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdHNlYXJjaC5vdXQKQEAgLTUxMyw2 ICs1MTMsMjEgQEAgU0VMRUNUIGNvdW50KCopIEZST00gdGVzdF90c3ZlY3RvciBXSEVSRSBhIEBA ICchd2Q6RCc7CiAoMSByb3cpCiAKIC0tIFRlc3Qgc2lnbGVuIHBhcmFtZXRlciBvZiBHaVNUIHRz dmVjdG9yX29wcworQ1JFQVRFIElOREVYIHdvd2lkeDEgT04gdGVzdF90c3ZlY3RvciBVU0lORyBn aXN0IChhKTsKK0FMVEVSIElOREVYIHdvd2lkeDEgQUxURVIgQ09MVU1OIGEgU0VUIChmb289MSk7 CitFUlJPUjogIHVucmVjb2duaXplZCBwYXJhbWV0ZXIgImZvbyIKK0FMVEVSIElOREVYIHdvd2lk eDEgQUxURVIgQ09MVU1OIGEgU0VUIChzaWdsZW49MCk7CitFUlJPUjogIHZhbHVlIDAgb3V0IG9m IGJvdW5kcyBmb3Igb3B0aW9uICJzaWdsZW4iCitERVRBSUw6ICBWYWxpZCB2YWx1ZXMgYXJlIGJl dHdlZW4gIjEiIGFuZCAiMjAyNCIuCitBTFRFUiBJTkRFWCB3b3dpZHgxIEFMVEVSIENPTFVNTiBh IFNFVCAoc2lnbGVuPTIwNDgpOworRVJST1I6ICB2YWx1ZSAyMDQ4IG91dCBvZiBib3VuZHMgZm9y IG9wdGlvbiAic2lnbGVuIgorREVUQUlMOiAgVmFsaWQgdmFsdWVzIGFyZSBiZXR3ZWVuICIxIiBh bmQgIjIwMjQiLgorQUxURVIgSU5ERVggd293aWR4MSBBTFRFUiBDT0xVTU4gYSBTRVQgKHNpZ2xl bj0xMDAsZm9vPSdiYXInKTsKK0VSUk9SOiAgdW5yZWNvZ25pemVkIHBhcmFtZXRlciAiZm9vIgor QUxURVIgSU5ERVggd293aWR4MSBBTFRFUiBDT0xVTU4gYSBTRVQgKHNpZ2xlbj0xMDAsIHNpZ2xl biA9IDIwMCk7CitFUlJPUjogIHBhcmFtZXRlciAic2lnbGVuIiBzcGVjaWZpZWQgbW9yZSB0aGFu IG9uY2UKK0FMVEVSIElOREVYIHdvd2lkeDEgQUxURVIgQ09MVU1OIGEgU0VUIChzaWdsZW49MSk7 CitEUk9QIElOREVYIHdvd2lkeDE7CiBDUkVBVEUgSU5ERVggd293aWR4MSBPTiB0ZXN0X3RzdmVj dG9yIFVTSU5HIGdpc3QgKGEgdHN2ZWN0b3Jfb3BzKGZvbz0xKSk7CiBFUlJPUjogIHVucmVjb2du aXplZCBwYXJhbWV0ZXIgImZvbyIKIENSRUFURSBJTkRFWCB3b3dpZHgxIE9OIHRlc3RfdHN2ZWN0 b3IgVVNJTkcgZ2lzdCAoYSB0c3ZlY3Rvcl9vcHMoc2lnbGVuPTApKTsKZGlmZiAtLWdpdCBhL3Ny Yy90ZXN0L3JlZ3Jlc3Mvc3FsL2J0cmVlX2luZGV4LnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L2J0cmVlX2luZGV4LnNxbAppbmRleCBjNjAzMTJkYjJkLi43NTUyYzM5YTAxIDEwMDY0NAotLS0g YS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9idHJlZV9pbmRleC5zcWwKKysrIGIvc3JjL3Rlc3QvcmVn cmVzcy9zcWwvYnRyZWVfaW5kZXguc3FsCkBAIC0xNzIsMyArMTcyLDUgQEAgSU5TRVJUIElOVE8g ZGVsZXRlX3Rlc3RfdGFibGUgU0VMRUNUIGksIDEsIDIsIDMgRlJPTSBnZW5lcmF0ZV9zZXJpZXMo MSwxMDAwKSBpOwogCiAtLSBUZXN0IHVuc3VwcG9ydGVkIGJ0cmVlIG9wY2xhc3MgcGFyYW1ldGVy cwogY3JlYXRlIGluZGV4IG9uIGJ0cmVlX3RhbGxfdGJsIChpZCBpbnQ0X29wcyhmb289MSkpOwor Y3JlYXRlIGluZGV4IG9uIGJ0cmVlX3RhbGxfdGJsIChpZCk7CithbHRlciBpbmRleCBidHJlZV90 YWxsX3RibF9pZF9pZHggYWx0ZXIgY29sdW1uIGlkIHNldCAobmRpc3RpbmN0PTEwMCk7CmRpZmYg LS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC90c2VhcmNoLnNxbCBiL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3RzZWFyY2guc3FsCmluZGV4IGQ5MjkyMTA5OTguLjk2OTk4ZmRjZjYgMTAwNjQ0Ci0t LSBhL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3RzZWFyY2guc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3RzZWFyY2guc3FsCkBAIC0xMzAsNiArMTMwLDE1IEBAIFNFTEVDVCBjb3VudCgqKSBG Uk9NIHRlc3RfdHN2ZWN0b3IgV0hFUkUgYSBAQCAnIXdkOkEnOwogU0VMRUNUIGNvdW50KCopIEZS T00gdGVzdF90c3ZlY3RvciBXSEVSRSBhIEBAICchd2Q6RCc7CiAKIC0tIFRlc3Qgc2lnbGVuIHBh cmFtZXRlciBvZiBHaVNUIHRzdmVjdG9yX29wcworQ1JFQVRFIElOREVYIHdvd2lkeDEgT04gdGVz dF90c3ZlY3RvciBVU0lORyBnaXN0IChhKTsKK0FMVEVSIElOREVYIHdvd2lkeDEgQUxURVIgQ09M VU1OIGEgU0VUIChmb289MSk7CitBTFRFUiBJTkRFWCB3b3dpZHgxIEFMVEVSIENPTFVNTiBhIFNF VCAoc2lnbGVuPTApOworQUxURVIgSU5ERVggd293aWR4MSBBTFRFUiBDT0xVTU4gYSBTRVQgKHNp Z2xlbj0yMDQ4KTsKK0FMVEVSIElOREVYIHdvd2lkeDEgQUxURVIgQ09MVU1OIGEgU0VUIChzaWds ZW49MTAwLGZvbz0nYmFyJyk7CitBTFRFUiBJTkRFWCB3b3dpZHgxIEFMVEVSIENPTFVNTiBhIFNF VCAoc2lnbGVuPTEwMCwgc2lnbGVuID0gMjAwKTsKK0FMVEVSIElOREVYIHdvd2lkeDEgQUxURVIg Q09MVU1OIGEgU0VUIChzaWdsZW49MSk7CitEUk9QIElOREVYIHdvd2lkeDE7CisKIENSRUFURSBJ TkRFWCB3b3dpZHgxIE9OIHRlc3RfdHN2ZWN0b3IgVVNJTkcgZ2lzdCAoYSB0c3ZlY3Rvcl9vcHMo Zm9vPTEpKTsKIENSRUFURSBJTkRFWCB3b3dpZHgxIE9OIHRlc3RfdHN2ZWN0b3IgVVNJTkcgZ2lz dCAoYSB0c3ZlY3Rvcl9vcHMoc2lnbGVuPTApKTsKIENSRUFURSBJTkRFWCB3b3dpZHgxIE9OIHRl c3RfdHN2ZWN0b3IgVVNJTkcgZ2lzdCAoYSB0c3ZlY3Rvcl9vcHMoc2lnbGVuPTIwNDgpKTsK --_002_E29EF33BCA1A4146BFCFC8EC08FB91A8amazoncom_--