[postgis-devel] [PostGIS] #411: Invalid geometries are accepted in DB but no way to take them out

PostGIS trac at osgeo.org
Mon Feb 8 09:45:39 PST 2010


#411: Invalid geometries are accepted in DB but no way to take them out
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  critical  |   Milestone:  PostGIS 1.4.2
Component:  postgis   |     Version:  1.4.X        
 Keywords:            |  
----------------------+-----------------------------------------------------
 The attached shapefile contains shapes that are imported in PostGIS with
 no warning or error, but result in them being stuck in there forever. In
 particular you can NOT copy them somewhere:

 postgis_bugs=# copy poly_molto_critici to '/tmp/out';
 ERROR:  geometry requires more points

 Of course you can't even pg_dump:

 postgis_bugs=# select the_geom from poly_molto_critici;
 ERROR:  geometry requires more points

 Note that I'm testing this with current trunk, but the original reporter
 (Regione Toscana) mentioned they are using 1.4.1 so for them to be out of
 the induced nightmare
 we'd need a C-only fix and a 1.4.2.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/411>
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