Changes between Version 1 and Version 2 of UsersWikiCheckInvalidGeometriesFromGeometryColumns

Timestamp:

May 8, 2011, 9:19:59 AM (13 years ago)

Author:

aperi2007

Comment:

—

UsersWikiCheckInvalidGeometriesFromGeometryColumns

@@ -16 +16 @@
         sql := 'DROP TABLE IF EXISTS ' || quote_ident(tabris) ||';';
     execute(sql);
-    sql := 'CREATE TABLE ' || quote_ident(tabris) || ' (id serial, query TEXT, conteggio INTEGER);';
+    sql := 'CREATE TABLE ' || quote_ident(tabris) || ' (id serial, query TEXT, invalidity INTEGER);';
         sql := 'select ''select count(*) from '' || quote_ident(f_table_schema) || ''.'' || quote_ident(f_table_name) || '' where ST_IsValid('' || f_geometry_column || '')=false;'' as query from public.geometry_columns';
 
@@ -23 +23 @@
             raise notice 'executing: %', _rec1.query;
             execute(_rec1.query) into ris;
+            sql := 'insert into ' || quote_ident(tabris) || ' (query, invalidity) values(' || _rec1.query || ',' || ris || ');';
                 END LOOP;