Re: Indexing unknown words with Tsearch2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Maitrallain <greg(dot)maitrallain(at)evodia(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexing unknown words with Tsearch2
Date: 2009-04-01 13:55:44
Message-ID: 4374.1238594144@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Maitrallain <greg(dot)maitrallain(at)evodia(dot)fr> writes:
> The problem is the writings contains many names of personnalities. For
> example : Churchill (the database covers WWII). But when I try to search
> for these names, nothing is found.

> I tried many things, like this introduction :
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
> And I think the problem's root is that no lexem is found (I could even
> say an empty lexem is found).

I think you've misconfigured your dictionary list. You normally want to
use an ispell dictionary together with some other one, like a snowball
dictionary. Using it by itself means exactly that only words known to
the dictionary will be indexed.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-04-01 14:00:06 Re: string_to_array with empty input
Previous Message Greg Maitrallain 2009-04-01 13:38:07 Indexing unknown words with Tsearch2