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@ice.mpg.de
======================================================================
