7.2.3: tuple is too big (max 8136)

From: pilsl(at)goldfisch(dot)at
To: pgsql-general(at)postgresql(dot)org
Subject: 7.2.3: tuple is too big (max 8136)
Date: 2002-11-01 13:33:48
Message-ID: 20021101143348.A7426@goldfisch.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


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(at)goldfisch(dot)at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-11-01 13:50:54 Re: 7.2.3: tuple is too big (max 8136)
Previous Message Richard Huxton 2002-11-01 12:37:42 Re: SELECT Query

Browse pgsql-sql by date

  From Date Subject
Next Message Doug McNaught 2002-11-01 13:50:54 Re: 7.2.3: tuple is too big (max 8136)
Previous Message Achilleus Mantzios 2002-11-01 07:51:04 Re: How do you write this query?