[SCM] PostGIS branch master updated. 3.6.0rc2-707-g8c9f8a734
git at osgeo.org
git at osgeo.org
Tue Jun 30 22:55:22 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 8c9f8a7342ad924ab0c65f0d412b72f39cdb80ee (commit)
via 19d927334da93ada4227e9787b152cf09ea8ccd7 (commit)
via aadcd5314909590326610e6efa1520d701b4d54a (commit)
via 2c116b7da3ebed1d4b1aa0a87be10afb726721b6 (commit)
via 92dcd395d0563227124bac9a21c79ec3404cd408 (commit)
from 30030a7f28a73a3d14ebb7272f7498656e9233db (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 8c9f8a7342ad924ab0c65f0d412b72f39cdb80ee
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jul 1 09:53:53 2026 +0400
Remove test-only NEWS entries
diff --git a/NEWS b/NEWS
index d6e142406..5f3f75770 100644
--- a/NEWS
+++ b/NEWS
@@ -72,10 +72,6 @@ To take advantage of all postgis_sfcgal extension features SFCGAL 2.3+ is needed
- #2804, #4315, [raster] Support two-argument ST_MapAlgebra callbacks
and pass callback call data as actual arguments (Darafei Praliaskouski)
- #2898, Document SQL function cost tiers for contributors
- - #4253, Add GiST 2D index regression coverage for containment operators
- (Darafei Praliaskouski)
- - #3340, Add regression coverage for Populate_Geometry_Columns on
- foreign tables (Darafei Praliaskouski)
- #6062, [topology] Stop using recursive snapping, for improved robustness (Sandro Santilli)
- #6065, Improved winding order computation robustness for rings having collapsed elements
(Sandro Santilli)
commit 19d927334da93ada4227e9787b152cf09ea8ccd7
Merge: aadcd5314 92dcd395d
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jul 1 09:53:30 2026 +0400
Merge pull request https://github.com/postgis/postgis/pull/926
Add GiST 2D containment index coverage
diff --cc NEWS
index 20518aef0,18f85b61f..d6e142406
--- a/NEWS
+++ b/NEWS
@@@ -72,9 -72,8 +72,10 @@@ To take advantage of all postgis_sfcga
- #2804, #4315, [raster] Support two-argument ST_MapAlgebra callbacks
and pass callback call data as actual arguments (Darafei Praliaskouski)
- #2898, Document SQL function cost tiers for contributors
+ - #4253, Add GiST 2D index regression coverage for containment operators
(Darafei Praliaskouski)
+ - #3340, Add regression coverage for Populate_Geometry_Columns on
+ foreign tables (Darafei Praliaskouski)
- #6062, [topology] Stop using recursive snapping, for improved robustness (Sandro Santilli)
- #6065, Improved winding order computation robustness for rings having collapsed elements
(Sandro Santilli)
commit aadcd5314909590326610e6efa1520d701b4d54a
Merge: 30030a7f2 2c116b7da
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jul 1 09:53:27 2026 +0400
Merge pull request https://github.com/postgis/postgis/pull/927
Add foreign table coverage for Populate_Geometry_Columns
commit 2c116b7da3ebed1d4b1aa0a87be10afb726721b6
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jun 17 08:21:26 2026 +0400
Add foreign table coverage for Populate_Geometry_Columns
Closes #3340
diff --git a/NEWS b/NEWS
index a636077cb..7ba46c2a4 100644
--- a/NEWS
+++ b/NEWS
@@ -73,6 +73,8 @@ To take advantage of all postgis_sfcgal extension features SFCGAL 2.3+ is needed
and pass callback call data as actual arguments (Darafei Praliaskouski)
- #2898, Document SQL function cost tiers for contributors
(Darafei Praliaskouski)
+ - #3340, Add regression coverage for Populate_Geometry_Columns on
+ foreign tables (Darafei Praliaskouski)
- #6062, [topology] Stop using recursive snapping, for improved robustness (Sandro Santilli)
- #6065, Improved winding order computation robustness for rings having collapsed elements
(Sandro Santilli)
diff --git a/regress/core/regress_management.sql b/regress/core/regress_management.sql
index 2b5027bd4..47351a758 100644
--- a/regress/core/regress_management.sql
+++ b/regress/core/regress_management.sql
@@ -66,3 +66,58 @@ BEGIN
END
$$;
SELECT 'Unexistant: ' || DropGeometryTable('unexistent'); -- see ticket #861
+
+-- Foreign data wrapper creation is superuser-only. Exercise the real foreign
+-- table path when allowed, and keep restricted regression runs deterministic.
+SELECT current_setting('is_superuser')::boolean
+ AND EXISTS (
+ SELECT 1
+ FROM pg_available_extensions
+ WHERE name = 'file_fdw'
+ ) AS regress_management_has_fdw \gset
+
+\if :regress_management_has_fdw
+SELECT current_setting('data_directory') || '/regress_management_fdw_' || pg_backend_pid() || '_' || to_char(clock_timestamp(), 'YYYYMMDDHH24MISSUS') || '.csv' AS regress_management_file \gset
+
+COPY (SELECT 'SRID=4326;POINT(1 2)') TO :'regress_management_file' WITH (FORMAT csv);
+
+CREATE EXTENSION file_fdw;
+CREATE SERVER regress_management_server FOREIGN DATA WRAPPER file_fdw;
+CREATE FOREIGN TABLE test_fdw_geom(geom geometry)
+ SERVER regress_management_server
+ OPTIONS (filename :'regress_management_file', format 'csv');
+
+SELECT 'foreign before', coord_dimension, srid, type
+ FROM geometry_columns
+ WHERE f_table_schema = 'public'
+ AND f_table_name = 'test_fdw_geom'
+ AND f_geometry_column = 'geom';
+SELECT 'foreign typmod', populate_geometry_columns('test_fdw_geom'::regclass);
+SELECT 'foreign after typmod', coord_dimension, srid, type
+ FROM geometry_columns
+ WHERE f_table_schema = 'public'
+ AND f_table_name = 'test_fdw_geom'
+ AND f_geometry_column = 'geom';
+
+DROP FOREIGN TABLE test_fdw_geom;
+CREATE FOREIGN TABLE test_fdw_geom(geom geometry)
+ SERVER regress_management_server
+ OPTIONS (filename :'regress_management_file', format 'csv');
+
+SELECT 'foreign constraints', populate_geometry_columns('test_fdw_geom'::regclass, false);
+SELECT 'foreign after constraints', coord_dimension, srid, type
+ FROM geometry_columns
+ WHERE f_table_schema = 'public'
+ AND f_table_name = 'test_fdw_geom'
+ AND f_geometry_column = 'geom';
+
+DROP FOREIGN TABLE test_fdw_geom;
+DROP SERVER regress_management_server;
+DROP EXTENSION file_fdw;
+\else
+SELECT 'foreign before', 2, 0, 'GEOMETRY';
+SELECT 'foreign typmod', 1;
+SELECT 'foreign after typmod', 2, 4326, 'POINT';
+SELECT 'foreign constraints', 1;
+SELECT 'foreign after constraints', 2, 4326, 'POINT';
+\endif
diff --git a/regress/core/regress_management_expected b/regress/core/regress_management_expected
index ac137e244..ced6d2815 100644
--- a/regress/core/regress_management_expected
+++ b/regress/core/regress_management_expected
@@ -3,3 +3,8 @@
The result: public.test_pt dropped.
#6038.after|0
Unexistant: public.unexistent dropped.
+foreign before|2|0|GEOMETRY
+foreign typmod|1
+foreign after typmod|2|4326|POINT
+foreign constraints|1
+foreign after constraints|2|4326|POINT
commit 92dcd395d0563227124bac9a21c79ec3404cd408
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Wed Jun 17 08:15:03 2026 +0400
Add GiST 2D containment index coverage
Closes #4253
diff --git a/NEWS b/NEWS
index a636077cb..18f85b61f 100644
--- a/NEWS
+++ b/NEWS
@@ -72,6 +72,7 @@ To take advantage of all postgis_sfcgal extension features SFCGAL 2.3+ is needed
- #2804, #4315, [raster] Support two-argument ST_MapAlgebra callbacks
and pass callback call data as actual arguments (Darafei Praliaskouski)
- #2898, Document SQL function cost tiers for contributors
+ - #4253, Add GiST 2D index regression coverage for containment operators
(Darafei Praliaskouski)
- #6062, [topology] Stop using recursive snapping, for improved robustness (Sandro Santilli)
- #6065, Improved winding order computation robustness for rings having collapsed elements
diff --git a/regress/core/regress_index.sql b/regress/core/regress_index.sql
index 3b874e974..59c62f281 100644
--- a/regress/core/regress_index.sql
+++ b/regress/core/regress_index.sql
@@ -29,12 +29,20 @@ $$;
CREATE INDEX quick_gist on test using gist (the_geom);
+CREATE TABLE test_gist_idx_2d AS
+SELECT i, ST_MakeEnvelope(i, i, i + 10, i + 10) AS geom
+FROM generate_series(1, 1000) i;
+
+CREATE INDEX test_gist_idx_2d_gist on test_gist_idx_2d using gist (geom);
+
set enable_indexscan = off;
set enable_bitmapscan = off;
set enable_seqscan = on;
SELECT 'scan_idx', qnodes('select * from test where the_geom && ST_MakePoint(0,0)');
select num,ST_astext(the_geom) from test where the_geom && 'BOX3D(125 125,135 135)'::box3d order by num;
+SELECT 'gist 2d @ seq', qnodes('select * from test_gist_idx_2d where geom @ ST_MakeEnvelope(120,120,140,140)'), count(*) FROM test_gist_idx_2d WHERE geom @ ST_MakeEnvelope(120,120,140,140);
+SELECT 'gist 2d ~ seq', qnodes('select * from test_gist_idx_2d where geom ~ ST_MakePoint(125,125)'), count(*) FROM test_gist_idx_2d WHERE geom ~ ST_MakePoint(125,125);
set enable_indexscan = on;
set enable_bitmapscan = off;
@@ -42,6 +50,8 @@ set enable_seqscan = off;
SELECT 'scan_seq', qnodes('select * from test where the_geom && ST_MakePoint(0,0)');
select num,ST_astext(the_geom) from test where the_geom && 'BOX3D(125 125,135 135)'::box3d order by num;
+SELECT 'gist 2d @ idx', qnodes('select * from test_gist_idx_2d where geom @ ST_MakeEnvelope(120,120,140,140)'), count(*) FROM test_gist_idx_2d WHERE geom @ ST_MakeEnvelope(120,120,140,140);
+SELECT 'gist 2d ~ idx', qnodes('select * from test_gist_idx_2d where geom ~ ST_MakePoint(125,125)'), count(*) FROM test_gist_idx_2d WHERE geom ~ ST_MakePoint(125,125);
CREATE FUNCTION estimate_error(qry text, tol int)
RETURNS text
@@ -104,6 +114,7 @@ SELECT 'expr &&', id, estimate_error(
FROM sample_queries ORDER BY id;
DROP TABLE test;
+DROP TABLE test_gist_idx_2d;
DROP TABLE sample_queries;
DROP FUNCTION estimate_error(text, int);
diff --git a/regress/core/regress_index_expected b/regress/core/regress_index_expected
index cfc954ecf..69d730748 100644
--- a/regress/core/regress_index_expected
+++ b/regress/core/regress_index_expected
@@ -4,12 +4,16 @@ scan_idx|Seq Scan
27373|POINT(125.017705 130.219927)
33863|POINT(131.608071 127.468328)
45851|POINT(130.986464 132.890625)
+gist 2d @ seq|Seq Scan|11
+gist 2d ~ seq|Seq Scan|11
scan_seq|Index Scan
11208|POINT(126.522745 128.356924)
19845|POINT(127.584643 134.083138)
27373|POINT(125.017705 130.219927)
33863|POINT(131.608071 127.468328)
45851|POINT(130.986464 132.890625)
+gist 2d @ idx|Index Scan|11
+gist 2d ~ idx|Index Scan|11
&&|1|5+-5:true
&&|2|912+-60:true
&&|3|12505+-500:true
-----------------------------------------------------------------------
Summary of changes:
NEWS | 1 -
regress/core/regress_index.sql | 11 +++++++
regress/core/regress_index_expected | 4 +++
regress/core/regress_management.sql | 55 ++++++++++++++++++++++++++++++++
regress/core/regress_management_expected | 5 +++
5 files changed, 75 insertions(+), 1 deletion(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list