Re: NOTICE: word is too long INSERT 0 3014 - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: NOTICE: word is too long INSERT 0 3014
Date
Msg-id 4545B6E4.4000904@sigaev.ru
Whole thread Raw
In response to NOTICE: word is too long INSERT 0 3014  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: NOTICE: word is too long INSERT 0 3014
List pgsql-general
> I am running into this limitation ALOT with Tsearch2. What are my
> options to get around it. Do I have to compile PostgreSQL with a
> different block size?
>
> If yes, what are the downsides to doing so (outside of not being able to
> do straight upgrades)?

If you really need that, your should play around WordEntry definition
(tsvector.h). Sorry, right now I haven't possibility to look closer,
just tomorrow.
Limit for word is equal 2KB - I supposed that is long enough to store
any meaningful words.


pgsql-general by date:

Previous
From: louis gonzales
Date:
Subject: Re: postgresql books and convertion utilities
Next
From: Alban Hertroys
Date:
Subject: Re: Replicating changes