Re: questions about tsearch2 (for czech language) - Mailing list pgsql-general

Pavel,

did you restart psql session after modifying tsearch2 configuration ?
btw, there is czech dictionary available from http://lingucomponent.openoffice.org/download_dictionary.html
We have utility to convert myspell dicts to ispell one. It's included
in 7.5 development. Patch for 7.4 could be downloaded from
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Also, historically, we use openfts mailing list for discussion of
tsearch2.

    Oleg
On Mon, 22 Dec 2003, Pavel Stehule wrote:

> > > result. Why? Have I problem with my configuration?
> >
> > did you specify stop words in dictionaries configuration ?
> >
> > select * from pg_ts_dict;
> >
> tsearch2=# select * from pg_ts_dict where dict_name ='cz_ispell';
> -[ RECORD 1
>
]---+--------------------------------------------------------------------------------------------------------------------------
> dict_name       | cz_ispell
> dict_init       | 173405
> dict_initoption |
>
DictFile="/usr/lib/ispell/czech",AffFile="/usr/lib/ispell/czech.aff",StopFile="/usr/local/pgsql/share/contrib/czech.stop"
> dict_lexize     | 173406
> dict_comment    |
>
> [postgres@usop root]$ cat /usr/local/pgsql/share/contrib/czech.stop|grep -e "^[sv]."
> se
> sem
> si
> svЫj
> ve
> vАm
> vА╧
> viz
> vy
>
> > >
> > > 2. I use small czech dictionary. I need don't erase words which aren't in
> > > dictionary (in my sample StЛhule). Can I set it somewhere? I tryed add
> > > simple dict into cfg map, but witout sucess
> > >
> >
> > Example, please ! What do you mean 'erase words' ?
> >
> >
> > > tsearch2=# select * from ts_debug('jmenuji se Pavel StЛhule a bydlМm ve
> > > Skalici.');           ts_name    | tok_type | description |  token  |
> > > dict_name      | tsvector
> > > ---------------+----------+-------------+---------+--------------------+-----------
> > >  default_czech | word     | Word        | StЛhule | {cz_ispell,simple} |
> > >  default_czech | lword    | Latin word  | a       | {cz_ispell,simple} |
> > >  default_czech | word     | Word        | bydlМm  | {cz_ispell,simple} |
> > > 'bydlet'
> > >
> > >
>
> If tsearch didn't find word in dictionary, then erase this from result.
> True? My surname, fo example isn't in dictionary, but I wont save this
> word in result (tsvector).
>
> I use
>
> tsearch2=# select version();
>                                                 version
> -------------------------------------------------------------------------------------------------------
>  PostgreSQL 7.4RC2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3
> 20030715 (Red Hat Linux 3.3-14)
>
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83