Re: 7.2.3: tuple is too big (max 8136)

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: pilsl(at)goldfisch(dot)at
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2.3: tuple is too big (max 8136)
Date: 2002-11-01 13:50:54
Message-ID: m37kfx9z5t.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

pilsl(at)goldfisch(dot)at writes:

> 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:

It's possible you are hitting the maximum column limit rather than the
tuple size limit. The FAQ list the max columns in a table as:

"250-1600 depending on column types"

So try a tuple of the same size but fewer columns and see if that's
the issue.

> 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...

I'm sure you're right but it's always good to double-check. ;)

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-11-01 14:17:48 Re: limit 0,10 within SELECT ..... FROM ......
Previous Message pilsl 2002-11-01 13:33:48 7.2.3: tuple is too big (max 8136)

Browse pgsql-sql by date

  From Date Subject
Next Message Maurício Sessue Otta 2002-11-01 14:09:12 Different size in the DATA directory
Previous Message pilsl 2002-11-01 13:33:48 7.2.3: tuple is too big (max 8136)