[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