From: | Rodrigo Valdenegro <rodrigo(dot)valdenegro(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error |
Date: | 2010-01-18 19:00:57 |
Message-ID: | 148bf241001181100y5c0b8a74q6c46eadc53a5d439@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2010-01-18 19:31:57 | Updating from a column |
Previous Message | Reid Thompson | 2010-01-18 18:47:31 | number of page slots needed (1576544) exceeds max_fsm_pages (204800)] |