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 1pgkDc-0001I2-02 for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Mar 2023 10:36:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pgkDa-0007Jk-TT for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Mar 2023 10:36:50 +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 1pgje5-0000yp-L8 for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 10:00:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgje1-0005GW-PZ for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 10:00:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=cvX/w7NqQwqJaZ/e623DLL98X5abmEPD/Hbj+DGyJeg=; b=X/B8fW0VN0fVAV+ZhB4iiwiQga AbVCARD0wax2BGAOEWUXPn/pZgFYkUiA4cnDryU5W+/L4DM+eP0/MK/+NewwFC7G0tHiqrTZkDBcx T+wtjfZbhazGI23QI1GbrKiA74EyeNBX8BYMK2ozy6anG9dZzQsS1nrGjf7l8EhffWw4xJhp1tlyu VBnIJUcdrDDQwYA1q/z6fgPMvGl5xQ623Dd8wer51dIfz+oD20SZfFFKAqJpB+AEiH3nJteSS6KCr UobYUXlxR8B1VyhgJVlna1/9QlDVvzLZr6tsdlUOf7fpsXql8ajvsO8OzFDillq5n5WsYjdprzc56 zCcRJnRw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgje0-0006vk-VK for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 10:00:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pgjdx-001udz-NA for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 10:00:02 +0000 Content-Type: multipart/mixed; boundary="===============5645812389063035599==" MIME-Version: 1.0 Subject: BUG #17872: Dropping an attribute of a composite type breaks indexes over the type silently To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 27 Mar 2023 10:00:01 +0000 Message-ID: <17872-d0fbb799dc3fd85d@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5645812389063035599== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg3MgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpDUkVBVEUgVFlQRSBjdHlwZSBBUyAoaSBpbnQs IGogaW50KTsNCkNSRUFURSBUQUJMRSBjdGJsKGEgaW50LCBjZiBjdHlwZSk7DQpDUkVBVEUgVU5J UVVFIElOREVYIGN0YmxfaWR4IE9OIGN0YmwoY2YpOyANCklOU0VSVCBJTlRPIGN0YmwgVkFMVUVT ICgxLCAnKDEsIDIpJzo6Y3R5cGUpLCAoMiwgJygxLCAxKSc6OmN0eXBlKTsNCkFMVEVSIFRZUEUg Y3R5cGUgRFJPUCBBVFRSSUJVVEUgajsNCg0KUmVzdWx0cyBpbiB0aGUgVU5JUVVFIGNvbnN0cmFp bnQgYnJva2VuOg0KU0VMRUNUIGN0aWQsICogRlJPTSBjdGJsOw0KIGN0aWQgIHwgYSB8IGNmICAN Ci0tLS0tLS0rLS0tKy0tLS0tDQogKDAsMSkgfCAxIHwgKDEpDQogKDAsMikgfCAyIHwgKDEpDQoN ClxkKyBjdGJsDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFi bGUgInB1YmxpYy5jdGJsIg0KIENvbHVtbiB8ICBUeXBlICAgfCBDb2xsYXRpb24gfCBOdWxsYWJs ZSB8IERlZmF1bHQgfCBTdG9yYWdlICB8IENvbXByZXNzaW9uCnwgU3RhdHMgdGFyZ2V0IHwgRGVz Y3JpcHRpb24gDQotLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0t LS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0NCiBhICAgICAgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgIHwg cGxhaW4gICAgfCAgICAgICAgICAgIAp8ICAgICAgICAgICAgICB8IA0KIGNmICAgICB8IGN0eXBl ICAgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBleHRlbmRlZCB8ICAgICAgICAg ICAgCnwgICAgICAgICAgICAgIHwgDQpJbmRleGVzOg0KICAgICJjdGJsX2lkeCIgVU5JUVVFLCBi dHJlZSAoY2YpDQpBY2Nlc3MgbWV0aG9kOiBoZWFwDQoNCkFuZCB0aGUgaW5kZXggY29ycnVwdGlv biBkZXRlY3RlZCBieSBhbWNoZWNrOg0KQ1JFQVRFIEVYVEVOU0lPTiBhbWNoZWNrOw0KU0VMRUNU IGJ0X2luZGV4X3BhcmVudF9jaGVjayhvaWQsIHRydWUsIHRydWUpIEZST00gcGdfY2xhc3MNCldI RVJFIHJlbG5hbWUgPSAnY3RibF9pZHgnOw0KRVJST1I6ICBjb3VsZCBub3QgZmluZCB0dXBsZSB1 c2luZyBzZWFyY2ggZnJvbSByb290IHBhZ2UgaW4gaW5kZXgKImN0YmxfaWR4Ig0KREVUQUlMOiAg SW5kZXggdGlkPSgxLDEpIHBvaW50cyB0byBoZWFwIHRpZD0oMCwyKSBwYWdlIGxzbj0wLzE4N0JG ODAuDQoNCihJbnRlcmVzdGluZ2x5IGVub3VnaCwgYW1jaGVjayBkb2Vzbid0IGRldGVjdCBhIGNv cnJ1cHRpb24gaWYNClZBTFVFUyAoMSwgJygxLCAxKSc6OmN0eXBlKSwgKDIsICcoMSwgMiknOjpj dHlwZSkgYXJlIGluc2VydGVkLikNCg0KVGhlIHNhbWUgaXMgb2JzZXJ2ZWQgd2l0aCBhIGNvbXBv c2l0ZSB0eXBlIHJlcHJlc2VudGluZyBhIHRhYmxlIHJvdywNCmZvciBleGFtcGxlOg0KQ1JFQVRF IFRBQkxFIGlqdGJsKGkgaW50LCBqIGludCk7DQpDUkVBVEUgVEFCTEUgdHRibChhIGludCwgY2Yg aWp0YmwpOw0KQ1JFQVRFIFVOSVFVRSBJTkRFWCB0dGJsX2lkeCBPTiB0dGJsKGNmKTsgDQpJTlNF UlQgSU5UTyB0dGJsIFZBTFVFUyAoMSwgJygxLCAyKSc6OmlqdGJsKSwgKDIsICcoMSwgMSknOjpp anRibCk7DQpBTFRFUiBUQUJMRSBpanRibCBEUk9QIENPTFVNTiBqOw0KDQpCdXQgaWYgYW4gaW5k ZXggY3JlYXRlZCBvdmVyIGEgc2V0IG9mIG9yZGluYXJ5IGNvbHVtbnMsIGl0IGlzIHJlbW92ZWQN CmF1dG9tYXRpY2FsbHkgd2hlbiBhIGNvbHVtbiBpbiB0aGUgc2V0IGlzIGRyb3BwZWQuDQpDUkVB VEUgVEFCTEUgdGJsKGEgaW50LCBpIGludCwgaiBpbnQpOw0KQ1JFQVRFIFVOSVFVRSBJTkRFWCB0 YmxfaWR4IE9OIHRibChpLCBqKTsgDQpJTlNFUlQgSU5UTyB0YmwgVkFMVUVTICgxLCAxLCAyKSwg KDIsIDEsIDEpOw0KXGQrIHRibA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIFRhYmxlICJwdWJsaWMudGJsIg0KIENvbHVtbiB8ICBUeXBlICAgfCBDb2xsYXRpb24g fCBOdWxsYWJsZSB8IERlZmF1bHQgfCBTdG9yYWdlIHwgQ29tcHJlc3Npb24gfApTdGF0cyB0YXJn ZXQgfCBEZXNjcmlwdGlvbiANCi0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0t LS0tKy0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tDQogYSAgICAgIHwgaW50ZWdlciB8ICAgICAgICAgICB8ICAgICAgICAgIHwgICAg ICAgICB8IHBsYWluICAgfCAgICAgICAgICAgICB8CiAgICAgICAgICAgICB8IA0KIGkgICAgICB8 IGludGVnZXIgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwgICAg ICAgICAgICAgfAogICAgICAgICAgICAgfCANCiBqICAgICAgfCBpbnRlZ2VyIHwgICAgICAgICAg IHwgICAgICAgICAgfCAgICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAgICAgIHwKICAgICAgICAg ICAgIHwgDQpJbmRleGVzOg0KICAgICJ0YmxfaWR4IiBVTklRVUUsIGJ0cmVlIChpLCBqKQ0KQWNj ZXNzIG1ldGhvZDogaGVhcA0KDQpBTFRFUiBUQUJMRSB0YmwgRFJPUCBDT0xVTU4gajsNClxkKyB0 YmwNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVi bGljLnRibCINCiBDb2x1bW4gfCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZh dWx0IHwgU3RvcmFnZSB8IENvbXByZXNzaW9uIHwKU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24g DQotLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGEgICAg ICB8IGludGVnZXIgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwg ICAgICAgICAgICAgfAogICAgICAgICAgICAgfCANCiBpICAgICAgfCBpbnRlZ2VyIHwgICAgICAg ICAgIHwgICAgICAgICAgfCAgICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAgICAgIHwKICAgICAg ICAgICAgIHwgDQpBY2Nlc3MgbWV0aG9kOiBoZWFwDQoNCkFzIEkgY2FuIHNlZSwgaW4gdGhpcyBj YXNlIHBnX2RlcGVuZCBjb250YWlucyBkZXBlbmRlbmNpZXMgb2YgdGhlIGluZGV4DQpvbiBzcGVj aWZpYyB0YWJsZSBjb2x1bW5zLCBidXQgZm9yIGNvbXBvc2l0ZSB0eXBlcyB0aGVyZSBleGlzdHMg b25seSBhDQpkZXBlbmRlbmN5IG9uIGEgY29tcG9zaXRlIHR5cGUgYXMgYSB3aG9sZS4KCg== --===============5645812389063035599==--