Re: tuple too big error

From: "Karl Schmid" <schmid@ice.mpg.de>

> Hi all,
>
> when I try to insert a long string (100 kByte) into a 'text' field using
the
> following command:

> ERROR:  Tuple is too big: size 104228, max size 8140
>
> If I understand the docs correctly, there is no length restriction in text
> fields and the above instruction should work.
>
> Did I overlook something? Is it necessary to import such a long string as
a
> large object?
>
> I am using PostgreSQL 7.0.3 under SuSE Linux 7.1.

Afraid you have overlooked something - the 8k row limit applies to text
fields too. You'll either need to use 7.1 (at release candidate stage) where
this limit no longer applies, or large-objects.

- Richard Huxton