pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Tuple 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>
  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-06 05:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jens Hartwig <jens.hartwig@t-systems.de>
  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