Josh Berkus wrote:
> On 5/28/09 2:30 PM, Bruce Momjian wrote:
> > Because no one has responded, I am going to prevent pg_migrator from
> > working with a cluster that uses tsvector.  I realize this limits
> > pg_migrator's usefulness, but I have to move on.
> 
> I don't know how to fix the issue, certainly.
> 
> Why was there a format change to tsvector anyway?  Was there an 
> important reason for this?

The ordering of the lexems was changed:

        /*
         * Convert 8.3 tsvector to 8.4
         *
         * 8.3 sorts lexemes by its length and if lengths are the same then it 
uses
         * alphabetic order;  8.4 sorts lexemes in lexicographical order, e.g.
         *
         * => SELECT 'c bb aaa'::tsvector;
         *     tsvector
         * ----------------
         *  'aaa' 'bb' 'c'         -- 8.4
         *  'c' 'bb' 'aaa'         -- 8.3
         */

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

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to