[SCM] PostGIS branch master updated. 3.6.0rc2-611-g8868c689e

[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  8868c689e96dc91c50a0549aac3d7bf5b8b6238e (commit)
      from  d56c04e9a8e23f5f6ebddc1f9a0269b230838abf (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 8868c689e96dc91c50a0549aac3d7bf5b8b6238e
Author: Darafei Praliaskouski <me at komzpa.net>
Date:   Thu Jun 18 20:55:30 2026 +0400

    regress: cover find_srid duplicate-table lookups
    
    Add ticket coverage for exact-schema find_srid calls, dotted table-name lookup, and geometry_columns rows when two schemas contain same-named geometry tables.
    
    Closes https://github.com/postgis/postgis/pull/951
    
    Closes #3103

diff --git a/NEWS b/NEWS
index ebfe62cef..33f074411 100644
--- a/NEWS
+++ b/NEWS
@@ -58,6 +58,8 @@ To take advantage of all postgis_sfcgal extension features SFCGAL 2.3+ is needed
 
 * Bug Fixes *
 
+ - #3103, Add regression coverage for exact-schema find_srid and
+          geometry_columns lookups (Darafei Praliaskouski)
  - #5655, [doc] Skip XML validation during `make check` when xsltproc is
           unavailable (Darafei Praliaskouski)
  - #5487, Improve error detail for repeated upgrades after an incomplete
diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
index 7da7f4c1f..3e0533a76 100644
--- a/regress/core/tickets.sql
+++ b/regress/core/tickets.sql
@@ -1584,6 +1584,26 @@ SELECT f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, t
  ORDER BY f_table_name, f_geometry_column;
 DROP TABLE IF EXISTS test5829, test5978;
 
+-- -------------------------------------------------------------------------------------
+-- #3103, geometry_columns/find_srid exact-match behavior
+CREATE SCHEMA test3103a;
+CREATE SCHEMA test3103b;
+CREATE TABLE test3103a.geomtab (geom geometry(Point, 4326));
+CREATE TABLE test3103b.geomtab (geom geometry(Point, 3857));
+
+SELECT '#3103.1', find_srid('test3103a', 'geomtab', 'geom');
+SELECT '#3103.2', find_srid('', 'test3103b.geomtab', 'geom');
+SELECT '#3103.3', f_table_schema, srid
+  FROM geometry_columns
+ WHERE f_table_name = 'geomtab'
+   AND f_geometry_column = 'geom'
+ ORDER BY srid;
+
+DROP TABLE test3103a.geomtab;
+DROP TABLE test3103b.geomtab;
+DROP SCHEMA test3103a;
+DROP SCHEMA test3103b;
+
 -- -------------------------------------------------------------------------------------
 -- #4828, geometry_columns should ignore pending NOT VALID SRID checks
 CREATE TABLE test4828 (
@@ -1643,4 +1663,3 @@ DROP TABLE IF EXISTS fault6028;
 
 -- #5357
 SELECT '#5357', ST_AsText(ST_LineFromEncodedPolyline('__nphBgcoeiA?@', 6), 6);
-
diff --git a/regress/core/tickets_expected b/regress/core/tickets_expected
index dcdffa995..9c3451edd 100644
--- a/regress/core/tickets_expected
+++ b/regress/core/tickets_expected
@@ -490,6 +490,10 @@ public.test5978.geometry SRID:4326 TYPE:POINT DIMS:2
 public|test5829|geom|2|4326|GEOMETRY
 public|test5978|geometry|2|4326|POINT
 public|test5978|shape|2|4326|POINT
+#3103.1|4326
+#3103.2|3857
+#3103.3|test3103b|3857
+#3103.3|test3103a|4326
 #4828|4326
 #5987|LINESTRING(20 20,20.1 20,20.2 19.9)|LINESTRING(20 20,20.1 20,20.2 19.9)
 #5962|MULTIPOINT((1 1),(3 4))|POINT(1 1)

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

Summary of changes:
 NEWS                          |  2 ++
 regress/core/tickets.sql      | 21 ++++++++++++++++++++-
 regress/core/tickets_expected |  4 ++++
 3 files changed, 26 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS