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>

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Max Size of a text field
Next
From: Najm Hashmi
Date:
Subject: Error on Drop table