tsearch2 gives NOTICE: word is too long
Started by AI Rummanabout 16 years ago2 messagesgeneral
When I am using the query:
select length(description), to_tsvector('default',description) as c from
crmentity ;
Getting error:
NOTICE: word is too long
Postgresql 8.1.
Could anyone please tell me why?
Re: tsearch2 gives NOTICE: word is too long
AI Rumman wrote:
When I am using the query:
select length(description),
to_tsvector('default',description) as c from crmentity ;Getting error:
NOTICE: word is too long
Postgresql 8.1.
Could anyone please tell me why?
Because there is a "word" in the "description" column that
exceeds the maximal length (4096 I think).
This is not an error, just an information that you will not
be able to search for this word.
Yours,
Laurenz Albe