[SCM] PostGIS branch master updated. 3.6.0rc2-494-g7761433a5

[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  7761433a55ce7445282798f018d57819f44dc319 (commit)
      from  21949699858347065db080de31687841ce834ea0 (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 7761433a55ce7445282798f018d57819f44dc319
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Mon Jun 1 10:19:06 2026 -0700

    Improve "raster_overviews" efficiency, closes #6078,
    (from Laurenz Albe)

diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in
index 566a23b86..5a1bfc085 100644
--- a/raster/rt_pg/rtpostgis.sql.in
+++ b/raster/rt_pg/rtpostgis.sql.in
@@ -8344,11 +8344,9 @@ CREATE OR REPLACE VIEW raster_columns AS
 	FROM
 		pg_class c,
 		pg_attribute a,
-		pg_type t,
 		pg_namespace n
-	WHERE t.typname = 'raster'::name
-		AND a.attisdropped = false
-		AND a.atttypid = t.oid
+	WHERE a.attisdropped = false
+		AND a.atttypid = 'raster'::regtype
 		AND a.attrelid = c.oid
 		AND c.relnamespace = n.oid
 		AND c.relkind = ANY (ARRAY['r'::"char", 'v'::"char", 'm'::"char", 'f'::"char", 'p'::"char"] )

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

Summary of changes:
 raster/rt_pg/rtpostgis.sql.in | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)


hooks/post-receive
-- 
PostGIS