Text Search Configuration Problem - Mailing list pgsql-general

From Kevin Reynolds
Subject Text Search Configuration Problem
Date
Msg-id 716144.29864.qm@web44906.mail.sp1.yahoo.com
Whole thread Raw
Responses Re: Text Search Configuration Problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Text Search Configuration Problem  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
I'm using Postgresql version 8.3.1 on CentOS 5 and am following the steps in section 12.7 of the documentation for creating a custom text search configuration.
 
When I get to the step that says:
 
CREATE TEXT SEARCH DICTIONARY english_ispell (
    TEMPLATE = ispell,
    DictFile = english,
    AffFile = english,
    StopWords = english
);
 
I get the following error:
 
ERROR:  invalid byte sequence for encoding "UTF8": 0xe0c020
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
 
I'm using the english ispell files from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
 
Does anyone know how to solve this?


You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

pgsql-general by date:

Previous
From: Chad
Date:
Subject: pg_dump / load seems really slow..
Next
From: Dan99
Date:
Subject: slow pgsql tables - need to vacuum?