[SCM] PostGIS branch master updated. 3.5.0-214-g73fcd5657

git at osgeo.org git at osgeo.org
Sun Mar 2 21:39:28 PST 2025


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, master has been updated
       via  73fcd56570849f350c9bdc70cd6bbf18ea277b83 (commit)
      from  a5e29aa336a932f2ffa641aba89b1a99921dca5f (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 73fcd56570849f350c9bdc70cd6bbf18ea277b83
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Mar 3 00:38:17 2025 -0500

    Fix regress error on pg18
    Explain now returns fractional for actual rows for some reason
    References #5851 for PostGIS 3.6.0

diff --git a/regress/core/regress_index.sql b/regress/core/regress_index.sql
index 869ac8aaf..399fc8b32 100644
--- a/regress/core/regress_index.sql
+++ b/regress/core/regress_index.sql
@@ -57,11 +57,11 @@ BEGIN
   -- TODO: rewrite using json output ?
   EXECUTE 'EXPLAIN ANALYZE ' || qry INTO anl;
 
-  SELECT regexp_matches(anl, ' rows=([0-9]*) .* rows=([0-9]*) ')
+  SELECT regexp_matches(anl, ' rows=([0-9]*) .* rows=([0-9\.]*) ')
   INTO mat;
 
   est := mat[1];
-  act := mat[2];
+  act := mat[2]::numeric::integer;
 
   err = abs(est-act);
 

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

Summary of changes:
 regress/core/regress_index.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list