Re: BUG #13440: unaccent does not remove all diacritics

On Wed, Feb 17, 2016 at 03:06:26PM +0300, Teodor Sigaev wrote:
> >>I'm inclining to commit this patch becouse it suggests more regular
> >>way to update unaccent rules. That is nice.
> >How would this affect pg_trgm indexes upgraded by pg_upgrade?
>
> pg_upgrade doesn't know any tsearch configuration staff, so, it
> can't do anything useful with checnges of fts configuration. The
> right way is recreate all tsvector columns, but pg_upgrade obviously
> is not able to run tsearch stack: parser, dictionaries etc.

OK, so would we need to mark such indexes as invalid?  Are you saying
the tsvector columns would also be invalid?  Yikes.  We could at least
tell people to recreate them.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +