RE: Max Size of a text field

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: "'Koen Antonissen'" <Koen(at)Cee-Kay(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: RE: Max Size of a text field
Date: 2001-03-30 14:42:29
Message-ID: 996802F75C3CD411B424001083FA445B059561@CET_PONXX_FP001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

You can edit config.h and recompile 7.0.3 to allow for larger tuples (up to
32K - Info used to be in the FAQ but that has changed so try the mailing
list archives for info) or you can try 7.1 RC1 or the CVS snapshot as both
can deal with almost unlimited text fields ;-)

Regards

Ben

> -----Original Message-----
> From: Koen Antonissen [mailto:Koen(at)Cee-Kay(dot)net]
> Sent: 30 March 2001 12:52
> To: pgsql-sql(at)postgresql(dot)org
> Subject: [SQL] Max Size of a text field
>
>
> Hi there
>
> I just recieved this error:
> 'Warning: PostgreSQL query failed: ERROR: Tuple is too big:
> size 13872,
> max size 8140 '
>
> Is there anyting I can do about that other than tell my users just not
> typing so much text into the field?
>
> Kind regards,
> Koen Antonissen
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************

Browse pgsql-sql by date

  From Date Subject
Next Message Trewern, Ben 2001-03-30 14:49:46 RE: Help with 'now', now(), timestamp 'now', ...
Previous Message D'Arcy J.M. Cain 2001-03-30 12:27:35 Re: serial type; race conditions