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

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: 7.2.3: tuple is too big (max 8136)
Дата
Msg-id m37kfx9z5t.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на 7.2.3: tuple is too big (max 8136)  (pilsl@goldfisch.at)
Ответы Re: 7.2.3: tuple is too big (max 8136)  (pilsl@goldfisch.at)
Список pgsql-general
pilsl@goldfisch.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

В списке pgsql-general по дате отправления:

Предыдущее
От: pilsl@goldfisch.at
Дата:
Сообщение: 7.2.3: tuple is too big (max 8136)
Следующее
От: "Paul Ottar Tornes"
Дата:
Сообщение: limit 0,10 within SELECT ..... FROM ......