Alvaro Herrera <alvhe...@commandprompt.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
