Thread: Tuple is too big ...

Tuple is too big ...

From
"Jens Hartwig"
Date:
Hello all,

I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in
"include/config.h" to 16384, recompiled and reinstalled the sources. After
having restarted the backend I tried to create a table with three
varchar(5000)-columns and tried to add three character-values with each 4000
characters.

The following error occurs:

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

What I am doing wrong? I would appreciate any ideas, because I urgently need
a solution ...

Best regards, Jens

-----------------------------------------------------

T-Systems
Projektleiter
debis Systemhaus GEI GmbH
Hausanschrift: Eichhornstraße 3, 10785 Berlin
Postanschrift: 10785 Berlin
Telefon: (004930) 25 54-32 82
Telefax: (004930) 25 54-31 87
Mobiltelefon: (0170) 167 26 48
E-Mail: jens.hartwig@t-systems.de
Internet: http://www.t-systems.de


Re: [SQL] Tuple is too big ...

From
Tom Lane
Date:
"Jens Hartwig" <jens.hartwig@t-systems.de> writes:
> I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in
> "include/config.h" to 16384, recompiled and reinstalled the sources.
> [ but it didn't take ]

Either you didn't do a full recompile (best to "make clean" then "make
all"), or you neglected to initdb, or some other procedural error.

            regards, tom lane