| 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: | Whole Thread | Raw Message | 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
| 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) |
| 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) |