On Thu, Mar 31, 2016 at 2:59 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Well, too late for 9.5.2 anyway. It still makes sense to correct that
> text for future releases. I'm inclined to wait a little bit though and
> see what other improvements become apparent. For instance, I think the
> point about non-first index columns not being affected is of greater
> weight than you seem to place on it.
The SQL query on the Wiki page does the right thing there now, so
users will have the benefit of not unnecessarily reindexing when text
was not the leading/first pg_index attribute. We have that covered, I
suppose, because everyone will look to the Wiki page for guidance.
I also noted quite a few non-obvious safe cases on the Wiki page, as
pointed out already over on the other thread.
--
Peter Geoghegan