tuple too big error
От | Karl Schmid |
---|---|
Тема | tuple too big error |
Дата | |
Msg-id | 01040408475700.04254@GEN-24 обсуждение исходный текст |
Ответы |
Re: tuple too big error
Re: tuple too big error Re: tuple too big error |
Список | pgsql-general |
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 ======================================================================
В списке pgsql-general по дате отправления: