Postgres Pro
Downloads
Home   >   mailing lists

Re: row is too big: size 8168, maximum size 8160 - Mailing list pgsql-admin

From Tom Lane
Subject Re: row is too big: size 8168, maximum size 8160
Date
Msg-id 19464.1531320028@sss.pgh.pa.us
Whole thread Raw
In response to row is too big: size 8168, maximum size 8160  (Mario De Frutos Dieguez <mariodefrutos@gmail.com>)
Responses Re: row is too big: size 8168, maximum size 8160  (Mario de Frutos Dieguez <mariodefrutos@gmail.com>)
List pgsql-admin
Tree view 
Mario De Frutos Dieguez <mariodefrutos@gmail.com> writes:
> 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.

You can either rethink your data representation (maybe you could put a
bunch of those values into an array?) or recompile/re-initdb with a
larger value of BLCKSZ.  I'd favor the former --- 790 columns is too many.

            regards, tom lane

pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
Next
From: Tom Lane
Date:
Subject: Re: invalid value for parameter "client_encoding": "ISO_8859_8"