Lists: | pgsql-general |
---|
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-14 18:54:15 |
Message-ID: | 148bf241001141054t2cf0e862uca2663f9eb726692@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
Can you help me about this error?, i will apreciate so much any suggestion
about it.
Thank's in advance,
Rodrigo
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 |
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: | 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 |
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
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:30:51 |
Message-ID: | 0d4d4a98-84fb-4610-a4ad-ae54b59216a2@c34g2000yqn.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> 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
From: | Andrés <aenemaosx(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:59:10 |
Message-ID: | 524e3871-7148-414a-b1b1-932f8f46fd86@22g2000yqr.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 22 ene, 11:30, Neoyagami Yasakani <neoyag(dot)(dot)(dot)(at)gmail(dot)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(dot)(dot)(dot)(at)gmail(dot)com> wrote:
>
>
>
> > 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
what is PostreSQL? XD