pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum
2+ messages / 2 participants
[nested] [flat]
* BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum
@ 2020-02-25 06:49 PG Bug reporting form <noreply@postgresql.org>
2020-02-25 15:05 ` Re: BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum Tomas Vondra <tomas.vondra@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2020-02-25 06:49 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: prachi.prachi97ps@gmail.com
The following bug has been logged on the website:
Bug reference: 16275
Logged by: prachi surangalikar
Email address: prachi.prachi97ps@gmail.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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum
2020-02-25 06:49 BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum PG Bug reporting form <noreply@postgresql.org>
@ 2020-02-25 15:05 ` Tomas Vondra <tomas.vondra@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tomas Vondra @ 2020-02-25 15:05 UTC (permalink / raw)
To: prachi.prachi97ps@gmail.com; pgsql-bugs@lists.postgresql.org
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.prachi97ps@gmail.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-02-25 15:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-25 06:49 BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum PG Bug reporting form <noreply@postgresql.org>
2020-02-25 15:05 ` Tomas Vondra <tomas.vondra@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox