Re: Improving the names generated for indexes on expressions

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2025-11-01T22:28:26Z
Lists: pgsql-hackers

Attachments

[ Nobody has had any better ideas in 2 months, so back to this ... ]

Robert Haas <robertmhaas@gmail.com> writes:
> Do you think there's any way of doing this usefully while not
> autogenerating names that require quoting, or is that a hopeless
> endeavor? If it's hopeless, is it better to accept autogenerated names
> that require quoting, or is it better to solve the problem on the
> other thread with something more like what you proposed there?

If people are dead set against double-quoting, I think the only way
forward is to not include operator names in the generated index names.
I do not think that's a better way personally, but I seem to be
outvoted.  Here's a v2 that does it like that.

			regards, tom lane

Commits

  1. Improve the names generated for indexes on expressions.