Re: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error

From: Neoyagami Yasakani <neoyagami(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error
Date: 2010-01-22 15:28:03
Message-ID: a871711d-047c-4e60-b648-13324e5d8047@m25g2000yqc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

the config reference exist for "spanish" ?

i bet the problem is there.

On 18 ene, 16:00, rodrigo(dot)valdene(dot)(dot)(dot)(at)gmail(dot)com (Rodrigo Valdenegro)
wrote:
> Hi guys,
>
> I'm working with full-text search on my project, however i'm receiving an
> "Config file error: 7 ERROR: no tsearch config CONTEXT" message but i don't
> know what it means.
>
> The entire error message received is:
>
> "SQLSTATE[F0000]: Config file error: 7 ERROR: no tsearch config CONTEXT: SQL
> statement "SELECT doc_id, area_tem_id, headline(doc_nombre,
> to_tsquery('spanish', 'prueba')) AS doc_nombre, headline(doc_autor,
> to_tsquery('spanish', 'prueba')) AS doc_autor, doc_agno_publicacion,
> headline(doc_descripcion, to_tsquery('spanish', 'prueba')) AS
> doc_descripcion, doc_visitas, rank(doc_tsv, query) AS rank FROM
> tbl_documento, to_tsquery('spanish', 'prueba') query WHERE query @@ doc_tsv
> AND doc_activo='1' ORDER BY rank DESC, area_tem_id ASC" PL/pgSQL function
> "buscardocs" line 26 at for over execute statement"
>
> Can you help me about this error?, i will apreciate so much any suggestion
> about it.
>
> Thank's in advance,
>
> Rodrigo

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neoyagami Yasakani 2010-01-22 15:30:51 Re: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error
Previous Message Sam Mason 2010-01-22 14:54:34 Re: Shall I convert all my stored procedure to use "EXECUTE", to ensure I get index-scan