Changes between Version 2 and Version 3 of UsersWikiCheckInvalidGeometriesFromGeometryColumns

Timestamp:

May 8, 2011, 9:29:33 AM (13 years ago)

Author:

aperi2007

Comment:

—

UsersWikiCheckInvalidGeometriesFromGeometryColumns

@@ -9 +9 @@
 RETURNS VOID AS $$
 DECLARE
-        sql text;
-        sql2 text;
+    sql text;
+    sql2 text;
     _rec1 record;
     ris integer;
 BEGIN
-        sql := 'DROP TABLE IF EXISTS ' || quote_ident(tabris) ||';';
+    sql := 'DROP TABLE IF EXISTS ' || quote_ident(tabris) ||';';
     execute(sql);
     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';
+    execute(sql);
+    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 order by f_table_schema,f_table_name LIMIT 3';
 
-        FOR _rec1 IN execute (sql)
-                LOOP
-            raise notice 'executing: %', _rec1.query;
-            execute(_rec1.query) into ris;
-            sql := 'insert into ' || quote_ident(tabris) || ' (query, invalidity) values(' || _rec1.query || ',' || ris || ');';
-                END LOOP;
-
-        RETURN;
+    FOR _rec1 IN execute (sql)
+       LOOP
+           raise notice 'executing: %', _rec1.query;
+           execute(_rec1.query) into ris;
+           sql := 'insert into ' || quote_ident(tabris) || ' (query, invalidity) values(' || quote_literal(_rec1.query) || ',' || ris || ');';
+           execute(sql);
+       END LOOP;
+    RETURN;
 END;
 $$ LANGUAGE 'plpgsql' STRICT;