[SCM] PostGIS branch master updated. 3.6.0rc2-631-g177963ca6

[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  177963ca6c91740aea1ab0000637017f9ad5dda5 (commit)
      from  6c7ab193ea99ea6dabd5fb05dac9a995f4aa6be4 (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 177963ca6c91740aea1ab0000637017f9ad5dda5
Author: Darafei Praliaskouski <me at komzpa.net>
Date:   Sat Jun 20 17:03:54 2026 +0400

    loader: test index creation during data loads
    
    Enable index creation in existing shapefile and raster loader regression fixtures, and verify the resulting GiST indexes after the loads complete.
    
    Pin the shapefile loader SQL so the regression also covers the unnamed CREATE INDEX form.
    
    Closes #2820
    
    Closes https://github.com/postgis/postgis/pull/994

diff --git a/raster/test/regress/loader/Basic.opts b/raster/test/regress/loader/Basic.opts
index d51cca218..d02bb6a13 100644
--- a/raster/test/regress/loader/Basic.opts
+++ b/raster/test/regress/loader/Basic.opts
@@ -1 +1 @@
--C
+-I -C
diff --git a/raster/test/regress/loader/Basic.select.expected b/raster/test/regress/loader/Basic.select.expected
index 484721c35..0e7dc191e 100644
--- a/raster/test/regress/loader/Basic.select.expected
+++ b/raster/test/regress/loader/Basic.select.expected
@@ -2,3 +2,4 @@
 POLYGON((0 0,1 0,1 -1,0 -1,0 0))|255
 POLYGON((89 -49,90 -49,90 -50,89 -50,89 -49))|0
 POLYGON((44 -24,45 -24,45 -25,44 -25,44 -24))|0
+1
diff --git a/raster/test/regress/loader/Basic.select.sql b/raster/test/regress/loader/Basic.select.sql
index bc0434c08..a412b8314 100644
--- a/raster/test/regress/loader/Basic.select.sql
+++ b/raster/test/regress/loader/Basic.select.sql
@@ -2,3 +2,8 @@ SELECT srid, scale_x::numeric(16, 10), scale_y::numeric(16, 10), blocksize_x, bl
 SELECT ST_AsEWKT(geom), val FROM (SELECT (ST_PixelAsPolygons(rast, 1)).* FROM loadedrast WHERE rid = 1) foo WHERE x = 1 AND y = 1;
 SELECT ST_AsEWKT(geom), val FROM (SELECT (ST_PixelAsPolygons(rast, 2)).* FROM loadedrast WHERE rid = 1) foo WHERE x = 90 AND y = 50;
 SELECT ST_AsEWKT(geom), val FROM (SELECT (ST_PixelAsPolygons(rast, 3)).* FROM loadedrast WHERE rid = 1) foo WHERE x = 45 AND y = 25;
+SELECT COUNT(*)
+FROM pg_indexes
+WHERE schemaname = 'public'
+  AND tablename = 'loadedrast'
+  AND indexdef LIKE 'CREATE INDEX % ON public.loadedrast USING gist (st_convexhull(rast))';
diff --git a/regress/loader/TestANALYZE.opts b/regress/loader/TestANALYZE.opts
index d82cb4c58..c865f6dca 100644
--- a/regress/loader/TestANALYZE.opts
+++ b/regress/loader/TestANALYZE.opts
@@ -1,2 +1,2 @@
-# Test with ANALYZE
--g the_geom {regdir}/loader/TestSkipANALYZE loadedshp
+# Test with ANALYZE and index creation
+-I -g the_geom {regdir}/loader/TestSkipANALYZE loadedshp
diff --git a/regress/loader/TestANALYZE.select.expected b/regress/loader/TestANALYZE.select.expected
index d00491fd7..6ed281c75 100644
--- a/regress/loader/TestANALYZE.select.expected
+++ b/regress/loader/TestANALYZE.select.expected
@@ -1 +1,2 @@
 1
+1
diff --git a/regress/loader/TestANALYZE.select.sql b/regress/loader/TestANALYZE.select.sql
index de569878f..90227e331 100644
--- a/regress/loader/TestANALYZE.select.sql
+++ b/regress/loader/TestANALYZE.select.sql
@@ -2,3 +2,8 @@
 SELECT COUNT(stanumbers1)
 FROM pg_statistic
 WHERE starelid = 'public.loadedshp'::regclass AND stanumbers1 IS NOT NULL;
+SELECT COUNT(*)
+FROM pg_indexes
+WHERE schemaname = 'public'
+  AND tablename = 'loadedshp'
+  AND indexdef LIKE 'CREATE INDEX % ON public.loadedshp USING gist (the_geom)';
diff --git a/regress/loader/TestANALYZE.sql.expected b/regress/loader/TestANALYZE.sql.expected
new file mode 100644
index 000000000..fe56dd4b1
--- /dev/null
+++ b/regress/loader/TestANALYZE.sql.expected
@@ -0,0 +1,12 @@
+SET CLIENT_ENCODING TO UTF8;
+SET STANDARD_CONFORMING_STRINGS TO ON;
+BEGIN;
+CREATE TABLE "loadedshp" (gid serial);
+ALTER TABLE "loadedshp" ADD PRIMARY KEY (gid);
+SELECT AddGeometryColumn('','loadedshp','the_geom','0','POINT',2);
+INSERT INTO "loadedshp" (the_geom) VALUES ('01010000000000000000000000000000000000F03F');
+INSERT INTO "loadedshp" (the_geom) VALUES ('01010000000000000000002240000000000000F0BF');
+INSERT INTO "loadedshp" (the_geom) VALUES ('01010000000000000000002240000000000000F0BF');
+CREATE INDEX ON "loadedshp" USING GIST ("the_geom");
+COMMIT;
+ANALYZE "loadedshp";

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

Summary of changes:
 raster/test/regress/loader/Basic.opts            |  2 +-
 raster/test/regress/loader/Basic.select.expected |  1 +
 raster/test/regress/loader/Basic.select.sql      |  5 +++++
 regress/loader/TestANALYZE.opts                  |  4 ++--
 regress/loader/TestANALYZE.select.expected       |  1 +
 regress/loader/TestANALYZE.select.sql            |  5 +++++
 regress/loader/TestANALYZE.sql.expected          | 12 ++++++++++++
 7 files changed, 27 insertions(+), 3 deletions(-)
 create mode 100644 regress/loader/TestANALYZE.sql.expected


hooks/post-receive
-- 
PostGIS