Re: Possible patch for better index name choosing

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

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2009-12-21T22:37:25Z
Lists: pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On mn, 2009-12-21 at 00:03 -0500, Tom Lane wrote:
>> Well, we could tamp down the risks considerably if we undid my point
>> (1), namely to still consider only the first index column when
>> generating a name.

> I think putting all the column names into the index names instead of
> only the first is a significant improvement that should be kept.

Yeah, I think so too.  It's well worth any risk of application
incompatibility --- we make much bigger changes in every major
release without blinking.

			regards, tom lane