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
