Search Postgresql Archives

Re: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 22 ene, 11:30, Neoyagami Yasakani <neoyag...@xxxxxxxxx> 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...@xxxxxxxxx> wrote:
>
>
>
> > the config reference exist for "spanish" ?
>
> > i bet the problem is there.
>
> > On 18 ene, 16:00, rodrigo.valdene...@xxxxxxxxx (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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux