Re: [HACKERS] pg_migrator status for 8.4

2009-06-03 Thread Tom Lane
Alvaro Herrera 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-co

Re: [HACKERS] pg_migrator status for 8.4

2009-06-03 Thread Alvaro Herrera
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? -- Alvaro Herrerahttp://www.C