Tuple is too big ...

From: "Jens Hartwig" <jens(dot)hartwig(at)t-systems(dot)de>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Tuple is too big ...
Date: 2001-02-02 10:20:31
Message-ID: 001001c08d01$c64db900$c10ac98a@0000864A433A
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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(dot)hartwig(at)t-systems(dot)de
Internet: http://www.t-systems.de

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gianluigi Roveda 2001-02-02 12:19:11 hello
Previous Message Leland V. Lammert 2001-02-02 04:33:54 Dumb Question

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Ansley 2001-02-02 13:02:05 RE: const cast ?
Previous Message Florian Steffen 2001-02-02 08:15:47 Timestamp accuracy