Thread: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error
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.
Can you help me about this error?, i will apreciate so much any suggestion about it.
Thank's in advance,
Rodrigo
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.
Can you help me about this error?, i will apreciate so much any suggestion about it.
Thank's in advance,
Rodrigo
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
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
On 22 ene, 11:30, Neoyagami Yasakani <neoyag...@gmail.com> wrote: > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V... > > ----------------start snippet----- > Lets take a look at the function to_tsquery. It also has 3 signatures > which follow the same rational as the to_tsvector function: > > to_tsquery(oid, text); > to_tsquery(text, text); > to_tsquery(text); > Lets try using the function with a single word : > > SELECT to_tsquery('default', 'word'); > to_tsquery > ----------- > 'word' > (1 row) > I call the function the same way I would a to_tsvector function, > specifying the 'default' configuration for morphing, and the result is > the stemmed output 'word'. > > ---------end snippet----- > > On 22 ene, 12:28, Neoyagami Yasakani <neoyag...@gmail.com> wrote: > > > > > the config reference exist for "spanish" ? > > > i bet the problem is there. > > > On 18 ene, 16:00, rodrigo.valdene...@gmail.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 what is PostreSQL? XD
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html ----------------start snippet----- Lets take a look at the function to_tsquery. It also has 3 signatures which follow the same rational as the to_tsvector function: to_tsquery(oid, text); to_tsquery(text, text); to_tsquery(text); Lets try using the function with a single word : SELECT to_tsquery('default', 'word'); to_tsquery ----------- 'word' (1 row) I call the function the same way I would a to_tsvector function, specifying the 'default' configuration for morphing, and the result is the stemmed output 'word'. ---------end snippet----- On 22 ene, 12:28, Neoyagami Yasakani <neoyag...@gmail.com> wrote: > the config reference exist for "spanish" ? > > i bet the problem is there. > > On 18 ene, 16:00, rodrigo.valdene...@gmail.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
the config reference exist for "spanish" ? i bet the problem is there. On 18 ene, 16:00, rodrigo.valdene...@gmail.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