Thread: string is too long for tsvector

Hi,

I am new so apologies if this has been asked many times.

I have a table which contains approx 1 million text documents in individual
rows. I do not need all of these documents for my search. I only need those
that contain the phrase 'other events'

Here is my code
/
SELECT * FROM eightks\d
WHERE to_tsvector(text) @@ to_tsquery('other_events') ;/

When I run this I get the following error message

/string is too long for tsvector (2368732 bytes, max 1048575 bytes)/

Not sure what to do?

Also,  I would like those that match the above phase to be put into a new
table? Not sure how to do this.

Thanks heaps for any help.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/string-is-too-long-for-tsvector-tp5818131.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.