Well, I'd upgrade to at least 7.0.3 and change the BLCKSZ to 32k (in
src/include/config.h.in before configure config.h after).. That will give
you a 32k limit on tuple size.
7.1 eliminates the need for such things as TOAST does away with all tuple
size limits.. If you can wait, it should be out fairly soon.. I've been
using a 7.1 Beta 4 without a problem though I'm sure some bugs will
to pop up before the stable release..
Good luck!
-Mitch
On Thu, 8 Feb 2001, Michelle Murrain wrote:
> Hi folks,
>
> I've got a problem - I need a little help. I'm using 6.5.3 from Debian stable.
>
> I've got a database, which has some fields in one table that need to hold a
> fair bit of text (say, 8000-10,000+ characters). Right now, I've got those
> fields as simple text.
>
> When I try to enter data into those fields, I get the "Tuple too large"
> error.
>
> I can't chop up the fields into smaller pieces, and 8104 is not enough.
>
> Suggestions?
>
> Michelle
> --
> ------------
> Michelle Murrain, Ph.D.
> President
> Norwottuck Technology Resources
> mpm@norwottuck.com
> http://www.norwottuck.com
>