tsearch2 gives NOTICE: word is too long

Started by AI Rummanabout 16 years ago2 messagesgeneral
Jump to latest
#1AI Rumman
rummandba@gmail.com

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?

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: AI Rumman (#1)
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