[postgis-tickets] [SCM] PostGIS branch main updated. 3.1.0rc1-269-g1766890

git at osgeo.org git at osgeo.org
Mon Jul 5 14:24:34 PDT 2021


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, main has been updated
       via  176689092ee63b221992ce888f318c1f3c7cf84a (commit)
      from  f21c1d835286d980d31b5e4eb1caf1102a2b8903 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 176689092ee63b221992ce888f318c1f3c7cf84a
Author: Sandro Santilli <strk at kbt.io>
Date:   Mon Jul 5 23:23:13 2021 +0200

    Have ValidateTopology debug-print limiting bbox and count of checked faces

diff --git a/topology/topology.sql.in b/topology/topology.sql.in
index bb9e884..a53d7c0 100644
--- a/topology/topology.sql.in
+++ b/topology/topology.sql.in
@@ -1454,7 +1454,7 @@ DECLARE
   retrec topology.ValidateTopology_ReturnType;
   rec RECORD;
   rec2 RECORD;
-  i integer;
+  affected_rows integer;
   invalid_edges integer[];
   invalid_faces integer[];
   search_path_backup text;
@@ -1482,6 +1482,10 @@ BEGIN
   EXECUTE 'SET search_PATH TO ' || quote_ident(toponame) || ','
                                 || search_path_backup;
 
+  IF bbox IS NOT NULL THEN
+    RAISE DEBUG 'Limiting topology checking to bbox %', ST_AsEWKT(ST_Envelope(bbox));
+  END IF;
+
 
   -- Check for coincident nodes
   RAISE DEBUG 'Checking for coincident nodes';
@@ -1764,10 +1768,13 @@ BEGIN
   -- Scan the table looking for NULL geometries
   -- or geometries with wrong MBR consistency
   RAISE DEBUG 'Checking faces';
+  affected_rows := 0;
   FOR rec IN
     SELECT * FROM face_check
   LOOP --{
 
+    affected_rows := affected_rows + 1;
+
     IF rec.geom IS NULL OR ST_IsEmpty(rec.geom)
     THEN
       -- Face missing !
@@ -1826,6 +1833,8 @@ BEGIN
 
   END LOOP; --}
 
+  RAISE DEBUG 'Checked % faces', affected_rows;
+
   -- Check nodes have correct containing_face (#3233)
   RAISE DEBUG 'Checking for node containing_face correctness';
   FOR rec IN

-----------------------------------------------------------------------

Summary of changes:
 topology/topology.sql.in | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list