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 1qEPCC-0000Zx-DF for pgsql-committers@arkaria.postgresql.org; Wed, 28 Jun 2023 07:02:32 +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-0002m1-0q 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 1qEPA1-0007y8-At for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:17 +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-000sB3-0T for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:16 +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-00062j-HY 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-000oFY-S8 for pgsql-committers@lists.postgresql.org; Wed, 28 Jun 2023 07:00:08 +0000 Content-Type: multipart/mixed; boundary="===============8205827143675706152==" 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 --===============8205827143675706152== 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 bmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmL2ZjNTVjN2ZmOGQxMjJmZWI0OGFhZTU4ODllMjY0OTlmZmU1M2Mw YjcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3Rh YmxlY21kcy5jICAgICAgIHwgIDggKysrKysrLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9p bmRleGluZy5vdXQgfCAzMCArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3Qv cmVncmVzcy9zcWwvaW5kZXhpbmcuc3FsICAgICAgfCAyMiArKysrKysrKysrKysrKysrKysrKysr CjMgZmlsZXMgY2hhbmdlZCwgNTggaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCg== --===============8205827143675706152==--