[postgis-tickets] [PostGIS] #5301: PostgreSQL 11 3.0.1 upgrade to 3.3.2 fails with ERROR: row is too big: size 8824, maximum size 8160
PostGIS
trac at osgeo.org
Sun Dec 11 10:09:30 PST 2022
#5301: PostgreSQL 11 3.0.1 upgrade to 3.3.2 fails with ERROR: row is too big:
size 8824, maximum size 8160
------------------------------------+---------------------------
Reporter: robe | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.3.3
Component: build/upgrade/install | Version: 3.3.x
Resolution: | Keywords:
------------------------------------+---------------------------
Comment (by robe):
I did a quick test running pg_extensions_postgis_upgrade() in a DO loop
100 times.
{{{
DO $$
BEGIN
FOR i IN 1..100 LOOP
PERFORM postgis_extensions_upgrade();
COMMIT;
END LOOP;
END;
$$;
}}}
and I checked:
{{{
SELECT extcondition
FROM pg_catalog.pg_extension where extname = 'postgis';
}}}
and it's not appending, so I think that old issue I remembered is long
fixed.
I guess I'll just have to wait till I have access to that server again, so
confirm that is just filled in with piles of stuff.
It is still a little suspicious it only broke on 3.3.2 upgrade and not any
of the others.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5301#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list