tuple too big error - Mailing list pgsql-general

From Karl Schmid
Subject tuple too big error
Date
Msg-id 01040408475700.04254@GEN-24
Whole thread Raw
Responses Re: tuple too big error
Re: tuple too big error
Re: tuple too big error
List 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 by date:

Previous
From: Steven Vajdic
Date:
Subject: Is this a bug in 7.0.2?
Next
From: Einar Karttunen
Date:
Subject: Re: tuple too big error