Re: [GENERAL] Text search configuration

2008-09-01 Thread Oleg Bartunov
On Tue, 2 Sep 2008, Pedro Stavrinides wrote: Hi All, This is my first post to this mailing list, so apologies if I am sending my message to the incorrect place... My question: I have configured a very basic text search for our application, but got stuck at the point where I need the search vec

[GENERAL] Text search configuration

2008-09-01 Thread Pedro Stavrinides
Hi All, This is my first post to this mailing list, so apologies if I am sending my message to the incorrect place... My question: I have configured a very basic text search for our application, but got stuck at the point where I need the search vector to filter out some unwanted text (HTML tags

Re: [GENERAL] Text Search Configuration Problem

2008-04-05 Thread Oleg Bartunov
Kevin, it looks like you use UTF-8, so the problem in .aff file, which contains cyrillic comments :) I converted files into UTF-8 encoding using iconv. Oleg On Thu, 3 Apr 2008, Kevin Reynolds wrote: I'm using Postgresql version 8.3.1 on CentOS 5 and am following the steps in section 12.7 of

Re: [GENERAL] Text Search Configuration Problem

2008-04-05 Thread Tom Lane
Kevin Reynolds <[EMAIL PROTECTED]> writes: > 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".

[GENERAL] Text Search Configuration Problem

2008-04-05 Thread Kevin Reynolds
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 = englis