Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wewwy-0059lD-2j for pgsql-committers@arkaria.postgresql.org; Wed, 01 Jul 2026 15:34:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wewwx-00EcId-0i for pgsql-committers@arkaria.postgresql.org; Wed, 01 Jul 2026 15:34:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wewwx-00EcIV-03 for pgsql-committers@lists.postgresql.org; Wed, 01 Jul 2026 15:34:07 +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.98.2) (envelope-from ) id 1wewwq-000000016LB-0Sw2 for pgsql-committers@lists.postgresql.org; Wed, 01 Jul 2026 15:34:01 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wewwp-009HKf-2f for pgsql-committers@lists.postgresql.org; Wed, 01 Jul 2026 15:33:59 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wewwp-000w0r-2h for pgsql-committers@lists.postgresql.org; Wed, 01 Jul 2026 15:33:59 +0000 Content-Type: multipart/mixed; boundary="===============1140014872020157516==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve the names generated for indexes on expressions. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 01 Jul 2026 15:33:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1140014872020157516== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSB0aGUgbmFtZXMgZ2VuZXJhdGVkIGZvciBpbmRleGVzIG9uIGV4cHJlc3Npb25zLgoK SWYgdGhlIHVzZXIgZG9lc24ndCBzcGVjaWZ5IGEgbmFtZSBmb3IgYW4gaW5kZXgsIGl0J3MgZ2Vu ZXJhdGVkCmJhc2VkIG9uIHRoZSBuYW1lcyBjaG9zZW4gZm9yIHRoZSBpbmRleCBjb2x1bW5zICh3 aGljaCB0aGUgdXNlcgpoYXMgbm8gZGlyZWN0IGNvbnRyb2wgb3ZlcikuICBGb3IgaW5kZXggY29s dW1ucyB0aGF0IGFyZSBqdXN0CmNvbHVtbnMgb2YgdGhlIGJhc2UgcmVsYXRpb24sIHRoZSBpbmRl eCBjb2x1bW4gbmFtZSBpcyB0aGUgc2FtZSBhcwp0aGUgYmFzZSBjb2x1bW4gbmFtZTsgYnV0IGZv ciBpbmRleCBjb2x1bW5zIHRoYXQgYXJlIGV4cHJlc3Npb25zLAppdCdzIGxlc3MgY2xlYXIgd2hh dCB0byBkby4gIFVwIHRvIG5vdywgd2hhdCB3ZSBoYXZlIGRvbmUgaXMKZXF1aXZhbGVudCB0byB0 aGUgaGV1cmlzdGljcyB1c2VkIHRvIGNob29zZSBTRUxFQ1Qgb3V0cHV0IGNvbHVtbgpuYW1lcywg ZXhjZXB0IHRoYXQgd2UgZmFsbCBiYWNrIHRvICJleHByIiBub3QgIj9jb2x1bW4/IiBpbiB0aGUK bnVtZXJvdXMgY2FzZXMgdGhhdCBGaWd1cmVDb2xuYW1lIGRvZXNuJ3Qga25vdyB3aGF0IHRvIGRv IHdpdGguClRoaXMgaXMgbm90IHRyZW1lbmRvdXNseSBoZWxwZnVsLiAgTW9yZSwgaXQgZnJlcXVl bnRseSBsZWFkcyB0bwpjb2xsaXNpb25zIG9mIGdlbmVyYXRlZCBpbmRleCBuYW1lcywgd2hpY2gg d2UgY2FuIGhhbmRsZSBidXQKb25seSBhdCB0aGUgY29zdCBvZiB1c2VyIGNvbmZ1c2lvbjsgYWxz byB0aGVyZSdzIHNvbWUgcmlzayBvZgpjb25jdXJyZW50IGluZGV4IGNyZWF0aW9ucyB0cnlpbmcg dG8gdXNlIHRoZSBzYW1lIG5hbWUuCkxldCdzIHRyeSB0byBkbyBiZXR0ZXIuCgpNZXNzaW5nIHdp dGggdGhlIEZpZ3VyZUNvbG5hbWUgaGV1cmlzdGljcyB3b3VsZCBoYXZlIGEgdmVyeQpsYXJnZSBi bGFzdCByYWRpdXMsIHNpbmNlIHRoYXQgYWZmZWN0cyB0aGUgY29sdW1uIGhlYWRpbmdzCnRoYXQg YXBwbGljYXRpb25zIHNlZS4gIFRoYXQgZG9lc24ndCBzZWVtIHdpc2UsIGJ1dCBmb3J0dW5hdGVs eQpTUUwgcXVlcmllcyBhcmUgc2VsZG9tIGRpcmVjdGx5IGNvbmNlcm5lZCB3aXRoIGluZGV4IG5h bWVzLgpTbyB3ZSBzaG91bGQgYmUgYWJsZSB0byBjaGFuZ2UgdGhlIGluZGV4LW5hbWUgZ2VuZXJh dGlvbiBydWxlcwphcyBsb25nIGFzIHdlIGRlY291cGxlIHRoZW0gZnJvbSBGaWd1cmVDb2xuYW1l LgoKVGhlIG1ldGhvZCB1c2VkIGluIHRoaXMgcGF0Y2ggaXMgdG8gZGlnIHRocm91Z2ggdGhlIGV4 cHJlc3Npb24sCmV4dHJhY3QgdGhlIG5hbWVzIG9mIFZhcnMsIHRoZSBzdHJpbmcgcmVwcmVzZW50 YXRpb25zIG9mIENvbnN0cywKYW5kIHRoZSBuYW1lcyBvZiBmdW5jdGlvbnMsIGFuZCBydW4gdGhv c2UgdG9nZXRoZXIgd2l0aCB1bmRlcnNjb3JlcwpiZXR3ZWVuLiAgT3RoZXIgZXhwcmVzc2lvbiBu b2RlIHR5cGVzIGFyZSBpZ25vcmVkIGJ1dCBkZXNjZW5kZWQKdGhyb3VnaC4gIFdlIGNvdWxkIHdv cmsgaGFyZGVyIGJ5IGhhbmRsaW5nIG1vcmUgbm9kZSB0eXBlcywgYnV0Cml0IHNlZW1zIGxpa2Ug dGhpcyBpcyBsaWtlbHkgdG8gYmUgc3VmZmljaWVudCB0byBhcnJpdmUgYXQgdW5pcXVlCmluZGV4 IG5hbWVzIGluIG1hbnkgY2FzZXMuCgpOb3RhYmx5LCB0aGlzIHJ1bGUgaWdub3JlcyB0aGUgbmFt ZXMgb2Ygb3BlcmF0b3JzLCBmb3IgZXhhbXBsZQpib3RoICJhICsgYiIgYW5kICJhICogYiIgd2ls bCBiZSByZW5kZXJlZCBhcyAiYV9iIi4gIFRoaXMgY2hvaWNlCndhcyBtYWRlIHRvIHJlZHVjZSB0 aGUgcHJvYmFiaWxpdHkgb2YgaGF2aW5nIHRvIGRvdWJsZS1xdW90ZQp0aGUgaW5kZXggbmFtZS4K CkkndmUgYWxzbyBjaG9zZW4gdG8gc3RyaXAgQ29uc3QgcmVwcmVzZW50YXRpb25zIGRvd24gdG8g b25seQphbHBoYW51bWVyaWMgY2hhcmFjdGVycyAocGx1cyBub24tQVNDSUkgY2hhcmFjdGVycywg d2hpY2ggb3VyCnBhcnNlciB0cmVhdHMgYXMgYWxwaGFiZXRpYyBhbnl3YXkpLiAgU28gZm9yIGV4 YW1wbGUgInggKyAxLjAiCndvdWxkIGJlIHJlcHJlc2VudGVkIGFzICJ4XzEwIi4gIFRoaXMgbGlr ZXdpc2UgYXZvaWRzIHBvc3NpYmxlCnF1b3RpbmcgcHJvYmxlbXMuICBJIGFsc28gY29uc2lkZXJl ZCBsaW1pdGluZyBob3cgbWFueSBjaGFyYWN0ZXJzCndlJ2QgdGFrZSBmcm9tIGVhY2ggQ29uc3Qs IGJ1dCBkaWRuJ3QgZG8gdGhhdCBoZXJlLgoKV2UgbWlnaHQgdHdlYWsgdGhlc2UgcnVsZXMgc29t ZSBtb3JlIGFmdGVyIHdlIGdldCBzb21lIGV4cGVyaWVuY2UKd2l0aCB0aGlzIHBhdGNoLiAgSXQn cyBiZWluZyBjb21taXR0ZWQgYXQgdGhlIHN0YXJ0IG9mIGEKZGV2ZWxvcG1lbnQgY3ljbGUgdG8g cHJvdmlkZSBhcyBtdWNoIHRpbWUgYXMgcG9zc2libGUgdG8gZ2F0aGVyCmZlZWRiYWNrLgoKQXV0 aG9yOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmlld2VkLWJ5OiBSb2JlcnQgSGFh cyA8cm9iZXJ0bWhhYXNAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t Lzg3Njc5OS4xNzU3OTg3ODEwQHNzcy5wZ2gucGEudXMKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS8xODk1OS1mNjNiNTNiODY0YmIxNDE3QHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0t LS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3Bn L2NvbW1pdGRpZmYvMTgxYjYxODVjNzllMDllNmFjOTQ0MjgxODlkOWFmYWM4MDcyNDRhYwoKTW9k aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9zZWcvZXhwZWN0ZWQvcGFydGl0aW9u Lm91dCAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvaW5kZXhjbWRz LmMgICAgICAgICAgICAgICAgfCAxMzcgKysrKysrKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9w YXJzZXIvcGFyc2VfdGFyZ2V0LmMgICAgICAgICAgICAgICB8ICAxNiAtLS0Kc3JjL2JhY2tlbmQv cGFyc2VyL3BhcnNlX3V0aWxjbWQuYyAgICAgICAgICAgICAgfCAgIDYgKy0Kc3JjL2luY2x1ZGUv bm9kZXMvcGFyc2Vub2Rlcy5oICAgICAgICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL2luY2x1ZGUv cGFyc2VyL3BhcnNlX3RhcmdldC5oICAgICAgICAgICAgICAgfCAgIDEgLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2FsdGVyX3RhYmxlLm91dCAgICAgICB8ICAgNiArLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2NyZWF0ZV9pbmRleC5vdXQgICAgICB8ICAxOCArLS0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9jcmVhdGVfdGFibGUub3V0ICAgICAgfCAgIDQgKy0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9jcmVhdGVfdGFibGVfbGlrZS5vdXQgfCAgIDggKy0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9pbmRleGluZy5vdXQgICAgICAgICAgfCAxNjggKysrKysrKysrKysrLS0t LS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5oZXJpdC5vdXQgICAgICAgICAg IHwgMTE0ICsrKysrKysrLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yYW5nZXR5 cGVzLm91dCAgICAgICAgfCAgIDYgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdGF0c19p bXBvcnQub3V0ICAgICAgfCAgMTYgKy0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV9pbmRl eC5zcWwgICAgICAgICAgIHwgICAyICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2luZGV4aW5nLnNx bCAgICAgICAgICAgICAgIHwgIDE4ICstLQpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlz dCAgICAgICAgICAgICAgICB8ICAgMSArCjE3IGZpbGVzIGNoYW5nZWQsIDMxNiBpbnNlcnRpb25z KCspLCAyMTAgZGVsZXRpb25zKC0pCgo= --===============1140014872020157516==--