pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTuple is too big ...
2+ messages / 2 participants
[nested] [flat]
* Tuple is too big ...
@ 2001-02-02 10:20 Jens Hartwig <jens.hartwig@t-systems.de>
2001-02-06 05:45 ` Re: [SQL] Tuple is too big ... Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Jens Hartwig @ 2001-02-02 10:20 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] Tuple is too big ...
2001-02-02 10:20 Tuple is too big ... Jens Hartwig <jens.hartwig@t-systems.de>
@ 2001-02-06 05:45 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2001-02-06 05:45 UTC (permalink / raw)
To: Jens Hartwig <jens.hartwig@t-systems.de>; +Cc: pgsql-sql; pgsql-admin@postgresql.org
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-02-06 05:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-02 10:20 Tuple is too big ... Jens Hartwig <jens.hartwig@t-systems.de>
2001-02-06 05:45 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox