ERROR: Tuple is too big: size 15880, max size 8140

Started by Konstantinos Agourosover 24 years ago2 messagesgeneral
Jump to latest
#1Konstantinos Agouros
elwood@agouros.de

Hi,

I have a table with just one column of type varchar which gives me from time
to time (I guess when data is bigger then 8140 bytes) this message.
select version() says:
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
Besides Upgrading to 7.1 somebody has an idea about this?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres

#2Doug McNaught
doug@wireboard.com
In reply to: Konstantinos Agouros (#1)
Re: ERROR: Tuple is too big: size 15880, max size 8140

elwood@agouros.de (Konstantinos Agouros) writes:

Hi,

I have a table with just one column of type varchar which gives me from time
to time (I guess when data is bigger then 8140 bytes) this message.
select version() says:
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
Besides Upgrading to 7.1 somebody has an idea about this?

PG 7.0 and earlier has a hard-coded limit on row size. You can
increase the limit and recompile, but that requires you to dump all
your databases, initdb, and reload. So you might as well upgrade...

-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm. -Dylan