Re: [GENERAL] tsearch2 problems in postgres?

somewhere you need to use to_tsvector instead of to_tsquery. Oleg On Thu, 26 Jul 2007, JohnSense wrote: SELECT *, rank(ts_vec, to_tsquery('default', 'lc & 11(')) FROM us WHERE ts_vec @@ to_tsquery('default', 'lc & 11(') LIMIT 9 OFFSET 0 this query gives an error in tsearch2 saying syntax error

[GENERAL] tsearch2 problems in postgres?

SELECT *, rank(ts_vec, to_tsquery('default', 'lc & 11(')) FROM us WHERE ts_vec @@ to_tsquery('default', 'lc & 11(') LIMIT 9 OFFSET 0 this query gives an error in tsearch2 saying syntax error any idea on how 2 strip the non safe tsearch stuff before feeding it to sql this is from a web search

Re: [GENERAL] TSearch2 Problems

Hi Oleg, Everything seemed to work after the vacuum. Thanks for your prompt response. Howard ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] TSearch2 Problems

Oleg, My problem may have been solved by doing a "vacuum full analyse". I shall check tomorrow and get back to you. Thanks, Howard. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] TSearch2 Problems

show us output of select * from pg_ts_dict; "simple";"dex_init(internal)";"";"dex_lexize(internal,internal,integer)";"Simple example of dictionary." "en_stem";"snb_en_init(internal)";"contrib/english.stop";"snb_lexize(internal,internal,integer)";"English Stemmer. Snowball." "ru_stem_koi8";"snb

Re: [GENERAL] TSearch2 Problems

On Mon, 19 Mar 2007, Howard Cole wrote: Hi, I am having some problems with TSearch2 queries since upgrading from 8.0 to 8.2. This is the query: select count(*) from card, to_tsquery('default','test') as q where (q @@ card.fts); This works fine on 8.0 but gives the following error in 8.

[GENERAL] TSearch2 Problems

Hi, I am having some problems with TSearch2 queries since upgrading from 8.0 to 8.2. This is the query: select count(*) from card, to_tsquery('default','test') as q where (q @@ card.fts); This works fine on 8.0 but gives the following error in 8.2: ERROR: No dictionary with name 'en

Re: [GENERAL] tsearch2 problems / limitations

On Tue, Feb 22, 2005 at 01:29:45PM +, James Croft wrote: > One of the tables holds reasonable amounts of text, some fields hold up > to 2Mb. When I try and run > > UPDATE table SET idxfti=to_tsvector('default', field); > > it runs for a while then aborts with the following message > > ERRO

Re: [GENERAL] tsearch2 problems / limitations

On Tue, 22 Feb 2005, James Croft wrote: Hi, I've successfully added tsearch2 to an existing database and the speedup of searches is brilliant. I'm now trying to extend this to other parts of our system. One of the tables holds reasonable amounts of text, some fields hold up to 2Mb. When I try a

[GENERAL] tsearch2 problems / limitations

Hi, I've successfully added tsearch2 to an existing database and the speedup of searches is brilliant. I'm now trying to extend this to other parts of our system. One of the tables holds reasonable amounts of text, some fields hold up to 2Mb. When I try and run UPDATE table SET idxfti=to_tsvec

Re: [GENERAL] TSearch2: Problems with compound words and stop words

Timo, take a look into .aff file and search 'compoundwords'. german ispell file I got from http://j3e.de/ispell/igerman98/ has no support for compound words: 'compoundwords off' Norwegian, for example, has: compoundwords controlled z compoundmin 4 Oleg On Wed, 17 Nov 2004, Oleg Bartunov wrote

Re: [GENERAL] TSearch2: Problems with compound words and stop words

On Wed, 17 Nov 2004, Timo Haberkern wrote: sorry for the late answer, i was on holyday, see my remarks below Oleg Bartunov wrote: On Fri, 5 Nov 2004, Timo Haberkern wrote: Oleg, i use TSearch2 with PostgreSQL 7.4.6 and i applied the compoundword patch yesterday. The configuration changed a little

Re: [GENERAL] TSearch2: Problems with compound words and stop words

sorry for the late answer, i was on holyday, see my remarks below Oleg Bartunov wrote: On Fri, 5 Nov 2004, Timo Haberkern wrote: Oleg, i use TSearch2 with PostgreSQL 7.4.6 and i applied the compoundword patch yesterday. The configuration changed a little bit but the result is the same. I get no c

Re: [GENERAL] TSearch2: Problems with compound words and stop words

On Fri, 5 Nov 2004, Timo Haberkern wrote: Oleg, i use TSearch2 with PostgreSQL 7.4.6 and i applied the compoundword patch yesterday. The configuration changed a little bit but the result is the same. I get no compound words. I'm using the locale de_DE with encoding ISO8859-1 for the database. I

Re: [GENERAL] TSearch2: Problems with compound words and stop words

Oleg, i use TSearch2 with PostgreSQL 7.4.6 and i applied the compoundword patch yesterday. The configuration changed a little bit but the result is the same. I get no compound words. I'm using the locale de_DE with encoding ISO8859-1 for the database. I think i spell is working correctly except

Re: [GENERAL] TSearch2: Problems with compound words and stop words

Timo, please, check you apply patch for compound word support. What is version of postgresql ? Does ispell dict works for non-compound words ? Oleg On Fri, 5 Nov 2004, Timo Haberkern wrote: Hi there, i have some troubles with my TSearch2 Installation. I have done this installation as descri

Re: [GENERAL] TSearch2: Problems with compound words and stop words

Timo, I forward your message to openfts mailing list. Also, could you specify if locale settings are correct for your database and what dictionary you have downloaded. Oleg On Fri, 5 Nov 2004, Timo Haberkern wrote: Hi there, i have some troubles with my TSearch2 Installation. I have done th

[GENERAL] TSearch2: Problems with compound words and stop words

Hi there, i have some troubles with my TSearch2 Installation. I have done this installation as described in http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words I used the german myspell dictionary