Peter Geoghegan <pg@heroku.com> writes:
> Do you think it would be okay if the SQL query to detect potentially
> affected indexes only considered the leading attribute? Since that's
> the only attribute that could use abbreviated keys, it ought to be
> safe to not require users to REINDEX indexes that happen to have a
> second-or-subsequent text/varchar(n) attribute that doesn't use the C
> locale. Maybe it's not worth worrying about.
Sure, if that's the case it seems like a useful thing to know. I'm
sure there are lots of examples of mixed int-and-text columns in
indexes, for example.
regards, tom lane