On 03/30/2016 02:47 PM, Josh berkus wrote: > On 03/29/2016 07:43 PM, Peter Geoghegan wrote: >> 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. > > I think that's a great idea.
Based on that concept, I wrote a query which is now on the wiki page. Please fix it if it's not showing what we want it to show. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
