Search Postgresql Archives

Re: fulltext search stemming/ spelling problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 08.04.2010 20:15, Oleg Bartunov wrote:
On Thu, 8 Apr 2010, Corin wrote:

english_ispell dictionary is a morphology kind of dictionary ! Read docs.
Also, simple dictionary will never invoked, since english_stem dictionary
recognizes everything !
I'm not sure what you mean with 'morphology'. I sure read the docs but couldn't find anything about 'morphology disctionaries'.

I created it myself with the following commands, after I installed the ispell dictionaries using "apt-get":

CREATE TEXT SEARCH DICTIONARY english_ispell (
   TEMPLATE = ispell,
   DictFile = system_en_us,
   AffFile = system_en_us
);

CREATE TEXT SEARCH CONFIGURATION english_ispell ( COPY = pg_catalog.english );
ALTER TEXT SEARCH CONFIGURATION english_ispell
ALTER MAPPING FOR asciiword, asciihword, hword_asciipart, word, hword, hword_part WITH english_ispell, english_stem;

Thank's for the hint with simple dictionary. I'll remove it - but when it's never triggered, I gues it won't solve my problem neither?

Better, use ts_debug() function or ts_dict() for testing.
ts_debug shows:
SELECT ts_debug('english_ispell','gitar');
(asciiword,"Word, all ASCII",gitar,"{english_ispell,english_stem}",english_stem,{gitar})
(1 line)

ts_dict does not seem to exist, I neither couldn't find it in the docs.

    Regards,
        Oleg
Thanks,
Corin


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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux