tuple too big error

Поиск
Список
Период
Сортировка
От Karl Schmid
Тема tuple too big error
Дата
Msg-id 01040408475700.04254@GEN-24
обсуждение исходный текст
Ответы Re: tuple too big error  (Einar Karttunen <ekarttun@cs.Helsinki.FI>)
Re: tuple too big error  ("Poul L. Christiansen" <poulc@cs.auc.dk>)
Re: tuple too big error  (Marko Kreen <marko@l-t.ee>)
Список 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 по дате отправления:

Предыдущее
От: Steven Vajdic
Дата:
Сообщение: Is this a bug in 7.0.2?
Следующее
От: Einar Karttunen
Дата:
Сообщение: Re: tuple too big error