row is too big: size 8168, maximum size 8160

Поиск
Список
Период
Сортировка
От Mario De Frutos Dieguez
Тема row is too big: size 8168, maximum size 8160
Дата
Msg-id CAFYwGJ0Sphm9m3noXMgYf=1iDCn1=V2+7+VCD-nRg+C21Ee-gA@mail.gmail.com
обсуждение исходный текст
Ответы Re: row is too big: size 8168, maximum size 8160  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: row is too big: size 8168, maximum size 8160  (ramsiddu007 <ramsiddu007@gmail.com>)
Список pgsql-admin
Hello every one!

I've found this error message and it's driving me crazy.

I have a table with 790 numeric columns, I'm trying to make an INSERT INTO x SELECT... and in the same column/s I'm getting this message.

I've tried everything VACUUM FULL, Batch the insert with updates...but nothing always the same error.

THe BLCKSZ is set to 8Kb here: https://github.com/postgres/postgres/blob/master/src/include/pg_config.h.in#L36 but I'm suspecting that this or corrupted data or something I'm missing.

I've also read about TOAST-able and so on and I haven't messed with storage properties. The data into that columns aren't big numbers (maybe having many decimal counts)

Any clues? help?

Thank you

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

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: wal exist in slave but getting err requested WAL segment hasalready been removed
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: invalid value for parameter "client_encoding": "ISO_8859_8"