Postgres Pro
Downloads
Home   >   mailing lists

Re: Max Size of a text field - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Max Size of a text field
Date
Msg-id Pine.LNX.4.30.0103301709580.1063-100000@peter.localdomain
Whole thread Raw
In response to Max Size of a text field  ("Koen Antonissen" <Koen@Cee-Kay.net>)
List pgsql-sql
Tree view 
Koen Antonissen writes:

> 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?

Option 1:   increase BLCKSZ in src/include/config.h

Option 1.5: use lztext (7.0* only)

Option 2:   upgrade to 7.1

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

pgsql-sql by date:

Previous
From: Daniel Wickstrom
Date:
Subject: Help with 'now', now(), timestamp 'now', ...
Next
From: "Trewern, Ben"
Date:
Subject: RE: Max Size of a text field