[SCM] PostGIS branch master updated. 3.7.0beta1-248-gd445e93754

git at osgeo.org git at osgeo.org
Sun Aug 9 00:20:21 PDT 2026


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  d445e93754117d6e55b5092ac73623d55a2b1ae0 (commit)
      from  83b0e724322a8d737bd45fe5558222c9a6a7d642 (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 d445e93754117d6e55b5092ac73623d55a2b1ae0
Author: Regina Obe <lr at pcorp.us>
Date:   Sun Aug 9 02:48:22 2026 -0400

    Move adding geometry column to partitioned table after
    Prevent hook-after-create table  from disabling triggers on partitioned tables
    It triggers error ERROR:  cannot specify storage parameters for a partitioned table
    when running the full test suite and there are partitioned tables involved

diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
index 07cb6e6f1a..e04f022e9a 100644
--- a/regress/core/tickets.sql
+++ b/regress/core/tickets.sql
@@ -1850,7 +1850,7 @@ BEGIN
 
     SELECT count(*) INTO n FROM geometry_columns
       WHERE f_table_schema = 'test6110';
-    IF n <> 1501 THEN
+    IF n <> 2002 THEN
         RETURN 'FAIL: count=' || n || ' (expected 1000)';
     END IF;
 
@@ -1871,15 +1871,18 @@ $$ LANGUAGE plpgsql;
 DO $$
 DECLARE i integer;
 BEGIN
-		CREATE TABLE test6110.typmod_partition(id bigint, geom geometry(LINESTRING, 4269), part_key integer)
+		CREATE TABLE test6110.geom_partition(id bigint, part_key integer)
 			PARTITION BY LIST (part_key);
     FOR i IN 1..500 LOOP
         EXECUTE format('CREATE TABLE test6110.typmod_%s (geom geometry(Point, 4326))', i);
         EXECUTE format('CREATE TABLE test6110.constraint_%s (id integer)', i);
         EXECUTE format('SELECT AddGeometryColumn(%L, %L, %L, 4326, %L, 2, false)',
                        'test6110', 'constraint_' || i, 'geom', 'POINT');
-				EXECUTE format('CREATE TABLE test6110.partition_%s PARTITION OF test6110.typmod_partition FOR VALUES IN(%s)', i, i);
+				EXECUTE format('CREATE TABLE test6110.geom_partition_%s PARTITION OF test6110.geom_partition FOR VALUES IN(%s)', i, i);
     END LOOP;
+		ALTER TABLE test6110.geom_partition ADD COLUMN geom_typmod geometry(LINESTRING, 4269);
+		EXECUTE format('SELECT AddGeometryColumn(%L, %L, %L, 4326, %L, 2, false)',
+                       'test6110', 'geom_partition', 'geom_constraint', 'POINT');
 END
 $$;
 
diff --git a/regress/hooks/hook-after-create.sql b/regress/hooks/hook-after-create.sql
index 56492bbc80..1ff418994a 100644
--- a/regress/hooks/hook-after-create.sql
+++ b/regress/hooks/hook-after-create.sql
@@ -18,6 +18,9 @@ BEGIN
     LOOP
         IF obj.object_identity = 'public.spatial_ref_sys' THEN
             CONTINUE;
+        END IF;
+		IF (SELECT relkind FROM pg_catalog.pg_class WHERE oid = obj.objid) = 'p' THEN
+            CONTINUE;
         END IF;
         EXECUTE format('ALTER TABLE %s SET (autovacuum_enabled = false);',obj.object_identity);
     END LOOP;

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

Summary of changes:
 regress/core/tickets.sql            | 9 ++++++---
 regress/hooks/hook-after-create.sql | 3 +++
 2 files changed, 9 insertions(+), 3 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list