pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: pilsl@goldfisch.at
To: pgsql-general@postgresql.org
Subject: 7.2.3: tuple is too big (max 8136)
Date: Fri, 1 Nov 2002 14:33:48 +0100
Message-ID: <20021101143348.A7426@goldfisch.at> (raw)


I got this error on older versions and was told to
upgrade. Unfortunately I run into the very same error with 7.2.3.

I have a table with 1600 cols (for testing) and insert one row into
it which results in this error:

$ psql -U peter -f /tmp/t
Password:
psql:/tmp/t:1: ERROR:  Tuple is too big: size 19232, max size 8136

where /tmp/t is like:

insert into bigtable values ('testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest' .... and so on

I tried the same with a perl-program but as expected its exactely the same error.

I searched my whole systems for old libraries from a previous version
but I'm quite sure that my upgrade was quite a clean and successful
one...

thnx,
peter



-- 
mag. peter pilsl
IT-Consulting
tel: +43-699-1-3574035
fax: +43-699-4-3574035
pilsl@goldfisch.at



view thread (6+ messages)  latest in thread

Message-ID: <20021101143348.A7426@goldfisch.at>
Permalink:  ../20021101143348.A7426@goldfisch.at/
Also on:    postgresql.org/message-id/20021101143348.A7426@goldfisch.at

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: pilsl@goldfisch.at, pgsql-general@postgresql.org
  Subject: Re: 7.2.3: tuple is too big (max 8136)
  In-Reply-To: <20021101143348.A7426@goldfisch.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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