Changeset 55

Timestamp:

10/10/07 10:34:17 (1 year ago)

Author:

anton

Message:

Some indication added for assign_vertex_id()

Files:

• trunk/core/sql/routing_core_wrappers.sql (modified) (3 diffs)

trunk/core/sql/routing_core_wrappers.sql

@@ -128 +128 @@
-      
-      srid integer;
+      
+      countids integer;
-                                        
-      BEGIN
@@ -143 +145 @@
-                
-                srid := i.srid;
+
+                FOR i IN EXECUTE 'SELECT count(*) as countids FROM '|| quote_ident(geom_table) LOOP
+                END LOOP;
+                
+                countids := i.countids;
-                
-                EXECUTE 'SELECT addGeometryColumn(''vertices_tmp'', ''the_geom'', '||srid||', ''POINT'', 2)';
@@ -167 +174 @@
-                        || ' PointN('|| quote_ident(geo_cname) ||', NumPoints('|| quote_ident(geo_cname) ||')) as target'
-                        || ' FROM ' || quote_ident(geom_table) loop
+                        
+                        IF points.id%10=0 THEN
+                          RAISE NOTICE '% out of % edges processed', points.id, countids;
+                        END IF;
-
-                                source_id := point_to_id(setsrid(points.source, srid), tolerance);