tuple too big error

Hi all,

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

INSERT INTO clone (clone_code1, seq)
VALUES ('TEL1N','CCCTAAACCCTAAA...<about 100,000 characters of DNA
sequence>'),

I get the following error message:

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.

Thank you,

Karl

----------------------------------------------------------------------
Dr. Karl Schmid
Max-Planck-Institute for Chemical Ecology
Carl-Zeiss-Promenade 10 Tel: +49 3641 / 643658
07745 Jena Fax: +49 3641 / 643669
Germany Email: schmid(at)ice(dot)mpg(dot)de
======================================================================