On Wed, 2018-11-28 at 21:17 -0500, Stephen Frost wrote: > I don't agree that we can simply declare that all functional and partial > indexes have to be rebuilt between every major version upgrade, which is > the alternative. There really isn't another option- either we're > extremely careful and take immutability of functions seriously and make > sure to preserve behavior, and therefore indexes, across major versions, > or we don't and we require indexes to be rebuilt.
I absolutely agree with that. I guess that when I said that we should declare functions IMMUTABLE even if they might change owing to bug fixes, I didn't make it clear that each such occurrence would necessitate a fat warning in the release notes that indexes using them have to be rebuilt. Yours, Laurenz Albe
