Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#4340 closed defect (fixed)

ST_Union of 2GB of simple boxes not allowed

Reported by: komzpa Owned by: pramsey
Priority: medium Milestone: PostGIS 3.0.0
Component: postgis Version: 2.4.x
Keywords: Cc:

Description

ST_Union collects an array that is too long. Instead of failing here it could have unioned what's available already, pushed into one object and continue collecting. 

[2019-03-06 18:50:46] [54000] ERROR: array size exceeds the maximum allowed (1073741823)

Change History (5)

comment:1 by robe, 5 years ago

Milestone: PostGIS 2.5.2 → PostGIS 3.0.0

comment:2 by komzpa, 5 years ago

Resolution: → fixed
Status: new → closed

In 17398:

ST_Union: allow to input more than 1GB of geometries.

Output still has to be below 1GB due to postgres tuple length limit.

Closes #4340
Closes ​https://github.com/postgis/postgis/pull/394

comment:3 by strk, 5 years ago

NOTE: this change likely broke upgrades in presence of views using ST_Union. Please see ​https://git.osgeo.org/gitea/postgis/postgis/pulls/30

comment:4 by strk, 5 years ago

This build shows the problem on upgrade: ​https://dronie.osgeo.org/postgis/postgis/241/3/2

That is: 

psql:/drone/src/regress/00-regress-install/share/contrib/postgis/postgis_upgrade.sql:3654: ERROR: cannot drop function st_union(geometry) because other objects depend on it

comment:5 by strk, 5 years ago

I've filed #4386 to tackle the regression

Note: See TracTickets for help on using tickets.