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 1qEPCF-0000Zx-8X for pgsql-committers@arkaria.postgresql.org; Wed, 28 Jun 2023 07:02:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qEPCB-0002m0-9H for pgsql-committers@arkaria.postgresql.org; Wed, 28 Jun 2023 07:02:31 +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 1qEPA0-0007nG-RQ for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:16 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qEP9u-000sB5-AY for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:15 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qEP9t-00062k-Gg for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:09 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qEP9s-000oFZ-SV for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:08 +0000 Content-Type: multipart/mixed; boundary="===============2270222482792208046==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 28 Jun 2023 07:00:08 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2270222482792208046== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SWdub3JlIGludmFsaWQgaW5kZXhlcyB3aGVuIGVuZm9yY2luZyBpbmRleCBydWxlcyBpbiBBTFRF UiBUQUJMRSBBVFRBQ0ggUEFSVElUSU9OCgpBIHBvcnRpb24gb2YgQUxURVIgVEFCTEUgLi4gQVRU QUNIIFBBUlRJVElPTiBpcyB0byBlbnN1cmUgdGhhdCB0aGUKcGFydGl0aW9uIGJlaW5nIGF0dGFj aGVkIHRvIHRoZSBwYXJ0aXRpb25lZCB0YWJsZSBoYXMgYSBjb3JyZWN0IHNldCBvZgppbmRleGVz LCBzbyBhcyB0aGVyZSBpcyBhIGNvbnNpc3RlbnQgaW5kZXggbWFwcGluZyBiZXR3ZWVuIHRoZQpw YXJ0aXRpb25lZCB0YWJsZSBhbmQgaXRzIG5ldy10by1iZSBwYXJ0aXRpb24uICBIb3dldmVyLCBh cyBpbnRyb2R1Y2VkCmluIDhiMDhmN2QsIHRoZSBjdXJyZW50IGxvZ2ljIGNvdWxkIGNob29zZSBh biBpbnZhbGlkIGluZGV4IGFzIGEgbWF0Y2gsCndoaWNoIGlzIHNvbWV0aGluZyB0aGF0IGNhbiBl eGlzdCB3aGVuIGRlYWxpbmcgd2l0aCBtb3JlIHRoYW4gdHdvIGxldmVscwpvZiBwYXJ0aXRpb25p bmcsIGxpa2UgYXR0YWNoaW5nIGEgcGFydGl0aW9uZWQgdGFibGUgKHRoYXQgaGFzCnBhcnRpdGlv bnMsIHdpdGggYW4gaW5kZXggY3JlYXRlZCBieSBDUkVBVEUgSU5ERVggT04gT05MWSkgdG8gYW5v dGhlcgpwYXJ0aXRpb25lZCB0YWJsZS4KCkEgcGFydGl0aW9uZWQgaW5kZXggd2l0aCBpbmRpc3Zh bGlkIHNldCB0byBmYWxzZSBpcyBlcXVpdmFsZW50IHRvIGFuCmluY29tcGxldGUgcGFydGl0aW9u IHRyZWUsIG1lYW5pbmcgdGhhdCBhbiBpbnZhbGlkIHBhcnRpdGlvbmVkIGluZGV4CmRvZXMgbm90 IGhhdmUgaW5kZXhlcyBkZWZpbmVkIGluIGFsbCBpdHMgcGFydGl0aW9ucy4gIEhlbmNlLCBjaG9v c2luZyBhbgppbnZhbGlkIHBhcnRpdGlvbmVkIGluZGV4IGNhbiBjcmVhdGUgaW5jb25zaXN0ZW50 IHBhcnRpdGlvbiBpbmRleCB0cmVlcywKd2hlcmUgdGhlIHBhcmVudCBhdHRhY2hpbmcgdG8gaXMg dmFsaWQsIGJ1dCBpdHMgcGFydGl0aW9uIG1heSBiZQppbnZhbGlkLgoKSW4gdGhlIHJlcG9ydCBm cm9tIEFsZXhhbmRlciBMYWtoaW4sIHRoaXMgc2hvd2VkIHVwIGFzIGFuIGFzc2VydGlvbgpmYWls dXJlIHdoZW4gdmFsaWRhdGluZyBhbiBpbmRleC4gIFdpdGhvdXQgYXNzZXJ0aW9ucyBlbmFibGVk LCB0aGUKcGFydGl0aW9uIGluZGV4IHRyZWUgd291bGQgYmUgYWN0dWFsbHkgYnJva2VuLCBhcyBp bmRpc3ZhbGlkIHNob3VsZApiZSBzd2l0Y2hlZCB0byB0cnVlIGZvciBhIHBhcnRpdGlvbmVkIGlu ZGV4IG9uY2UgYWxsIGl0cyBwYXJ0aXRpb25zIGFyZQp0aGVtc2VsdmVzIHZhbGlkLiAgV2l0aCB0 d28gbGV2ZWxzIG9mIHBhcnRpdGlvbmluZywgdGhlIHRvcCBwYXJ0aXRpb25lZAp0YWJsZSB1c2Vk IGEgdmFsaWQgaW5kZXggYW5kIHdhcyBhYmxlIHRvIGxpbmsgdG8gYW4gaW52YWxpZCBpbmRleCBz dG9yZWQKb24gaXRzIHBhcnRpdGlvbiwgaXRzZWxmIGEgcGFydGl0aW9uZWQgdGFibGUuCgpJIGhh dmUgc3R1ZGllZCBhIGZldyBvcHRpb25zIGhlcmUgKGxpa2UgdGhlIHBvc3NpYmlsaXR5IHRvIHN3 aXRjaAppbmRpc3ZhbGlkIHRvIGZhbHNlIGZvciB0aGUgcGFyZW50KSwgYnV0IGNhbWUgZG93biB0 byB0aGUgY29uY2x1c2lvbgp0aGF0IHdlJ2QgYmV0dGVyIHJlbHkgb24gYSBzaW1wbGUgcnVsZTog aW52YWxpZCBpbmRleGVzIGhhZCBiZXR0ZXIgbmV2ZXIKYmUgY2hvc2VuLCBzbyBhcyB0aGUgcGFy dGl0aW9uIGF0dGFjaGVkIHVzZXMgYW5kIGNyZWF0ZXMgaW5kZXhlcyB0aGF0CnRoZSBwYXJlbnQg ZXhwZWN0cy4gIFNvbWUgcmVncmVzc2lvbiB0ZXN0cyBhcmUgYWRkZWQgdG8gcHJvdmlkZSBzb21l CmNvdmVyYWdlLiAgTm90ZSB0aGF0IHRoZSBleGlzdGluZyBjb3ZlcmFnZSBpcyBub3QgaW1wYWN0 ZWQuCgpUaGlzIGlzIGEgcHJvYmxlbSBzaW5jZSBwYXJ0aXRpb25lZCBpbmRleGVzIGV4aXN0LCBz byBiYWNrcGF0Y2ggYWxsIHRoZQp3YXkgZG93biB0byB2MTEuCgpSZXBvcnRlZC1ieTogQWxleGFu ZGVyIExha2hpbgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy8xNDk4NzYzNC00M2MwLTBj YjMtZTA3NS05NGQ0MjM2MDdlMDhAZ21haWwuY29tCkJhY2twYXRjaC10aHJvdWdoOiAxMQoKQnJh bmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi83YWExN2I0OThiNjM0OTk1NGU5Mzg2ZGJiZTA2ZGI5 OTU5YmY5ZDI2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jb21t YW5kcy90YWJsZWNtZHMuYyAgICAgICB8ICA4ICsrKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvaW5kZXhpbmcub3V0IHwgMzAgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrCnNy Yy90ZXN0L3JlZ3Jlc3Mvc3FsL2luZGV4aW5nLnNxbCAgICAgIHwgMjIgKysrKysrKysrKysrKysr KysrKysrKwozIGZpbGVzIGNoYW5nZWQsIDU4IGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0p Cgo= --===============2270222482792208046==--