[SCM] PostGIS branch master updated. 3.7.0beta1-143-g9f52dd2f9e

[git at osgeo.org]

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  9f52dd2f9eeb30f7bc5f774eefe280020f320c52 (commit)
      from  b5497a295063fa90cd4af4dfe860ce4d667dc94a (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 9f52dd2f9eeb30f7bc5f774eefe280020f320c52
Author: Regina Obe <lr at pcorp.us>
Date:   Fri Jul 31 22:21:48 2026 -0400

    geometry_columns view is very slow
    Closes #6110 for PostGIS 3.7.0

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 6ddc03af88..57088ad4d7 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -6704,7 +6704,7 @@ $$
 LANGUAGE 'plpgsql' STABLE STRICT PARALLEL SAFE;
 
 CREATE OR REPLACE VIEW geometry_columns AS
-WITH constraint_defs AS (
+WITH constraint_defs AS NOT MATERIALIZED (
     -- Trim trailing NOT VALID so metadata inference works before constraint validation (#4828).
     SELECT connamespace,
            conrelid,

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

Summary of changes:
 postgis/postgis.sql.in | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS