Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Bruce Momjian wrote:
>> pg_migrator will require a reindex if:
>> o an index is of type hash or gin
>> o an index uses bpchar_pattern_ops
> What about varchar_pattern_ops and text_pattern_ops? Are they not
> affected?
Nope. See
http://archives.postgresql.org/pgsql-committers/2008-05/msg00346.php
regards, tom lane