Search Postgresql Archives

Re: Tsearch2 - spanish

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

 



Hi

Thank's Teodor and Marcelo 

the problem is solved

regards


-----Mensaje original-----
De: marcelo Cortez [mailto:jmdc_marcelo@xxxxxxxxxxxx]
Enviado el: jue 20/09/2007 7:13
Para: MOLINA BRAVO FELIPE DE JESUS; Teodor Sigaev
CC: PostgreSQL General
Asunto: Re:  Tsearch2 - spanish
 
Felipe 

--- Felipe de Jesús Molina Bravo
<felipe.molina@xxxxxxxxxxxx> escribió:

> Hi
> 
> You are rigth, the output of "show lc_ctype;" is C.
> 
> Then I did is:
> 
> prueba1=# show lc_ctype;
>     lc_ctype     
> -----------------
>  es_MX.ISO8859-1
> (1 row)
> 
> and do it
> 
>  % initdb -D /YOUR/PATH -E LATIN1 --locale
> es_ES.ISO8859-1
> 
> (how you do say)
> 
> and "createdb -E iso8859-1 prueba1" and finally
> tsearch2
> 
> the original problem is resolved
> 
> prueba1=# select to_tsvector('espanol','melón');
>  to_tsvector 
> -------------
>  'melón':1
> (1 row)
> 
> 
> but if I change the sentece for it:
> 
> prueba1=# select to_tsvector('espanol','melón  perro
> mordelón');
> server closed the connection unexpectedly
>         This probably means the server terminated
> abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting
> reset: Failed.
> !> 

 The same thing he same thing happened my to me at 
first time with 
 Tsearch2 - spanish , i think you need 
 patch snowball with tsearch_snowball_82 file ,
googling
 you find instructions how doit .
 best regards 
 mdc 
> 
> 
> ??? lost the connection ... the server is up ....
> any idea?
> 
> The synonym is intentional
> 
> 
> thanks in advanced
> 
> 
> El mar, 18-09-2007 a las 21:40 +0400, Teodor Sigaev
> escribió:
> > >         LC_CTYPE="POSIX"
> > 
> > 
> > pls, output of "show lc_ctype;" command. If it's C
> locale then I can identify 
> > problem - characters diacritical mark (as ó) is
> not an alpha character, and 
> > ispell dictionary will fail. To fix that you
> should run initdb with options:
> > % initdb -D /YOUR/PATH -E LATIN1 --locale
> es_ES.ISO8859-1
> > or
> > % initdb -D /YOUR/PATH -E UTF8 --locale es_ES.UTF8
> > 
> > In last case you should also recode all
> dictionary's datafile in utf8 encoding.
> > 
> > >>>         prueba=# select
> to_tsvector('espanol','melón');
> > >>>         ERROR:  Affix parse error at 506 line
> > >> and
> > >>>         prueba=# select lexize('sp','melón');
> > >>>          lexize  
> > >>>         ---------
> > >>>          {melon}
> > >>>         (1 row)
> > sp is a Snowball stemmer, it doesn't require affix
> file, so it works.
> > 
> > By the way, why is synonym dictionary paced after
> ispell? is it intentional?
> > Usually, synonym dictionary goes first, then
> ispell and after all of them snowball.
> > 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please
> send an appropriate
>        subscribe-nomail command to
> majordomo@xxxxxxxxxxxxxx so that your
>        message can get through to the mailing list
> cleanly
> 



      Seguí de cerca a la Selección Argentina de Rugby en el Mundial de Francia 2007.
http://ar.sports.yahoo.com/mundialderugby


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


[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