Horton

Re: Improving the names generated for indexes on expressions

solai v <solai.cdac@gmail.com>

View thread View on postgr.es
From: solai v <solai.cdac@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-05T06:06:53Z
Lists: pgsql-hackers 
Hi,

> In any event, the cfbot has been nagging me that this patch needs
> a rebase, so here's v3.  The only change from v2 is that there are
> some new test cases in indexing.sql that need adjustment.
>

I applied the v3 patch and tested it.
The patch applied and built successfully.I reran the expression index
test cases i had used previously,including function,operator,JSON
,nested function ,and partitioned expression indexes.The generated
index names remained descriptive and behaved as expected.
I also run make check ,and all regression tests passed successfully.
The indexing regression test failure that i reported  while testing v2
appears to be resolved in this version.

Regards,
Solai

Commits

  1. Improve the names generated for indexes on expressions.