[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