[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