From: "Karl Schmid" <schmid(at)ice(dot)mpg(dot)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