Re: BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum

On Tue, Feb 25, 2020 at 06:49:06AM +0000, PG Bug reporting form wrote:
>The following bug has been logged on the website:
>
>Bug reference: 16275
>Logged by: prachi surangalikar
>Email address: prachi(dot)prachi97ps(at)gmail(dot)com
>PostgreSQL version: 12.0
>Operating system: windows 10
>Description:
>
>i am trying this program using python, i followed the steps but it did not
>helped; how can i solve this error please tell us
>

This simply meas that you're trying to insert data into a table, but the
resulting row is far too wide (it needs to fit into 8kB data page, but
it's way larger than that).

What exactly is happening depends on how is the table defined. Maybe it
has too many columns, or maybe the columns are wide enough to overflow
the page. Or something like that.

In general, I doubt this is a bug - it's expected behavior, essentially
an implementation limitation. But it's hard to say unless you show us
the table schema.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services