[postgis-devel] [PostGIS] #768: Probe_geometry_columns() don't work correctly

[PostGIS]

#768: Probe_geometry_columns() don't work correctly
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------
 Hi,
 the probe_geometry_column seem don't work correctly.

 I try this code sql:

 drop table if exists caricamento._csr_map_crop_multiline;
 -- _csr_map_crop is a multipolygon table
 create table caricamento._csr_map_crop_multiline as select
 a.gid,a.idmappa,ST_Boundary(a.geom) from caricamento._csr_map_crop as a
 where ST_IsValid(a.geom)=true;
 SELECT Probe_Geometry_Columns();

 the result seem ok because no error is given.
 But opening the geometry_columns table there isn't the
 "_csr_map_crop_multiline" table.

 I try this on a debain 32bit with postgis 200 trunk and with postgres
 9.0.2

 More information:

 executing the sql I have reported a good number of self-intersection.
 But I don't think that self-intersection are relate to this problem.

 ...
 W (183): Self-intersection at or near point 1.70284e+06 4.84765e+06
    W (184): Self-intersection at or near point 1.70402e+06 4.85107e+06
    W (185): Self-intersection at or near point 1.68837e+06 4.85484e+06
    W (186): IllegalArgumentException: Invalid number of points in
 LinearRing found 3 - must be 0 or >= 4
    W (187): Self-intersection at or near point 1.69997e+06 4.8436e+06
    W (188): Self-intersection at or near point 1.67601e+06 4.85714e+06
    W (189): Self-intersection at or near point 1.67035e+06 4.87667e+06
    W (190): Self-intersection at or near point 1.67163e+06 4.87903e+06
 ...   W (260): Self-intersection at or near point 1.62796e+06 4.84335e+06
    W (261): Self-intersection at or near point 1.69071e+06 4.84526e+06
    W (262): IllegalArgumentException: Invalid number of points in
 LinearRing found 3 - must be 0 or >= 4
    W (263): IllegalArgumentException: Invalid number of points in
 LinearRing found 3 - must be 0 or >= 4
    W (264): Self-intersection at or near point 1.70798e+06 4.85299e+06
    W (265): Self-intersection at or near point 1.59653e+06 4.87314e+06
    W (266): Self-intersection at or near point 1.63454e+06 4.87679e+06
    W (267): Self-intersection at or near point 1.68673e+06 4.84699e+06
    W (268): Self-intersection at or near point 1.69834e+06 4.89465e+06
 ...

 Regards.

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