RE: Max Size of a text field - Mailing list pgsql-sql
From | Trewern, Ben |
---|---|
Subject | RE: Max Size of a text field |
Date | |
Msg-id | 996802F75C3CD411B424001083FA445B059561@CET_PONXX_FP001 Whole thread Raw |
In response to | Max Size of a text field ("Koen Antonissen" <Koen@Cee-Kay.net>) |
List | pgsql-sql |
<p><font size="2">You can edit config.h and recompile 7.0.3 to allow for larger tuples (up to 32K - Info used to be in theFAQ but that has changed so try the mailing list archives for info) or you can try 7.1 RC1 or the CVS snapshot as bothcan deal with almost unlimited text fields ;-)</font><p><font size="2">Regards</font><p><font size="2">Ben</font><p><fontsize="2">> -----Original Message-----</font><br /><font size="2">> From: Koen Antonissen[<a href="mailto:Koen@Cee-Kay.net">mailto:Koen@Cee-Kay.net</a>]</font><br /><font size="2">> Sent: 30 March2001 12:52</font><br /><font size="2">> To: pgsql-sql@postgresql.org</font><br /><font size="2">> Subject: [SQL]Max Size of a text field</font><br /><font size="2">> </font><br /><font size="2">> </font><br /><font size="2">>Hi there</font><br /><font size="2">> </font><br /><font size="2">> I just recieved this error:</font><br/><font size="2">> 'Warning: PostgreSQL query failed: ERROR: Tuple is too big: </font><br /><font size="2">>size 13872,</font><br /><font size="2">> max size 8140 '</font><br /><font size="2">> </font><br /><fontsize="2">> Is there anyting I can do about that other than tell my users just not</font><br /><font size="2">>typing so much text into the field?</font><br /><font size="2">> </font><br /><font size="2">> Kind regards,</font><br/><font size="2">> Koen Antonissen</font><br /><font size="2">> </font><br /><font size="2">>---------------------------(end of </font><br /><font size="2">> broadcast)---------------------------</font><br/><font size="2">> TIP 3: if posting/reading through Usenet, please sendan appropriate</font><br /><font size="2">> subscribe-nomail command to majordomo@postgresql.org so that your</font><br/><font size="2">> message can get through to the mailing list cleanly</font><br /><font size="2">> </font><code><fontsize="3"><br /><br /> *****************************************************************************<br/> This email and any attachments transmittedwith it are confidential<br /> and intended solely for the use of the individual or entity to whom<br /> theyare addressed. If you have received this email in error please<br /> notify the sender and do not store, copy or disclosethe content<br /> to any other person.<br /><br /> It is the responsibility of the recipient to ensure that openingthis<br /> message and/or any of its attachments will not adversely affect<br /> its systems. No responsibility isaccepted by the Company.<br /> *****************************************************************************<br /></font></code>