Re: [GENERAL] Tsearch2 Spanish Dictionary

2008-04-21 Thread Alvaro Herrera
Mario Ignacio Rodríguez Cortés wrote: But in postgresql-8.3.1: SELECT to_tsvector('spanish','estadística'); to_tsvector - 'stic':2 (1 row) It works for me: alvherre=# SELECT to_tsvector('spanish','estadística'); to_tsvector -- 'estadist':1 (1 fila)

[GENERAL] Tsearch2 Spanish Dictionary

2008-04-21 Thread Mario Ignacio Rodríguez Cortés
Hi All: I have installed postgresql 8.3.1 on a Gentoo server, but i think that the spanish dictionary isn't the correct because i have another two machines with other postgresql versions and tserch2 installed, and a simple test that i do is make a query with the spanish dictionary, i get the

Re: [GENERAL] Tsearch2 - spanish

2007-09-20 Thread marcelo Cortez
Felipe --- Felipe de Jesús Molina Bravo [EMAIL PROTECTED] 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

Re: [GENERAL] Tsearch2 - spanish

2007-09-20 Thread MOLINA BRAVO FELIPE DE JESUS
Hi Thank's Teodor and Marcelo the problem is solved regards -Mensaje original- De: marcelo Cortez [mailto:[EMAIL PROTECTED] Enviado el: jue 20/09/2007 7:13 Para: MOLINA BRAVO FELIPE DE JESUS; Teodor Sigaev CC: PostgreSQL General Asunto: Re: [GENERAL] Tsearch2 - spanish Felipe

Re: [GENERAL] Tsearch2 - spanish

2007-09-19 Thread Teodor Sigaev
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. ! Hmm, can

Re: [GENERAL] Tsearch2 - spanish

2007-09-18 Thread Teodor Sigaev
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) Looks very strange, can you provide list of dictionaries and

Re: [GENERAL] Tsearch2 - spanish

2007-09-18 Thread Felipe de Jesús Molina Bravo
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

[GENERAL] Tsearch2 - spanish

2007-09-17 Thread Felipe de Jesús Molina Bravo
Hi I had installed postgresql-8.2.4 and tsearch2 with dictionary spanish. My problem is: prueba=# select to_tsvector('espanol','melón'); ERROR: Affix parse error at 506 line And if execute: prueba=# select lexize('sp','melón'); lexize -