[postgis-devel] [PostGIS] #2050: Unable to add constraint: 'extent'. Skipping
PostGIS
trac at osgeo.org
Wed Oct 17 07:15:14 PDT 2012
#2050: Unable to add constraint: 'extent'. Skipping
---------------------+------------------------------------------------------
Reporter: mgm1701 | Owner: pracine
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.0.2
Component: raster | Version: 2.0.x
Keywords: |
---------------------+------------------------------------------------------
Comment(by dustymugs):
After looking at your sql file, you're using partitions. So, I'm going to
assume many inherited tables, each holding many rows. It that situation,
you'll more than likely run out of memory. ST_Collect tries to be fast,
which means it tries to cache input geometries until the end. I'll add a
fallback approach using ST_MemUnion, which does not caching but is orders
of magnitude slower.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2050#comment:3>
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-devel
mailing list