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

PostGIS trac at osgeo.org
Wed Jan 12 14:51:53 PST 2011


#768: Probe_geometry_columns() don't work correctly
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  robe         
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by aperi2007):

 I tested r6609.
 Unfortunately it seem still don't work correctly.

 This is what is happened:

 #select f_table_schema || '.' || f_table_name as tables from
 public.geometry_columns;

 -->Results:
 tables
 caricamento._am_com_arc
 caricamento._am_com_region_am_com
 caricamento._pcca_spt_arc
 caricamento._pcca_spt_polygon
 caricamento._pcca_spt_labelpoint
 caricamento._csr_map_crop
 caricamento._world_borders
 caricamento._v_linee_elementari_250
 caricamento._v_suolo_250

 #drop table if exists caricamento._csr_map_crop_multiline;

 #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();

 Results:

 probed:9 inserted:0 conflicts:9 stale:0

 #select f_table_schema || '.' || f_table_name as tables from
 public.geometry_columns;

 -->Results:
 tables
 caricamento._am_com_arc
 caricamento._am_com_region_am_com
 caricamento._pcca_spt_arc
 caricamento._pcca_spt_polygon
 caricamento._pcca_spt_labelpoint
 caricamento._csr_map_crop
 caricamento._world_borders
 caricamento._v_linee_elementari_250
 caricamento._v_suolo_250

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