tsearch2 problems / limitations - Mailing list pgsql-general

From James Croft
Subject tsearch2 problems / limitations
Date
Msg-id cvfc44$1sb2$1@news.hub.org
Whole thread Raw
Responses Re: tsearch2 problems / limitations  (Oleg Bartunov <oleg@sai.msu.su>)
Re: tsearch2 problems / limitations  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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_tsvector('default', field);

it runs for a while then aborts with the following message

ERROR:  value is too big

Does anyone know what the problem might be here? Does tsearch2 have
configurable (or compilable) settings that could get around this?

Many Thanks,
James

pgsql-general by date:

Previous
From: Adelson - Informática
Date:
Subject: Store procedure -------------- !!!!!!!!!!!!!! URGENTE """""""""""""""
Next
From: "Don Doumakes"
Date:
Subject: Recovering db from cracked server