Thread: Max Size of a text field

Max Size of a text field

From
"Koen Antonissen"
Date:
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


Re: Max Size of a text field

From
Peter Eisentraut
Date:
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/