[postgis-tickets] [SCM] PostGIS branch master updated. 3.1.0alpha2-163-g5829c16

[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  5829c165ccf2afcfd6d59cbe12c363f61a903c77 (commit)
      from  e65386f7062a3013c0753a7d5cd83fcf8e6592ae (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 5829c165ccf2afcfd6d59cbe12c363f61a903c77
Author: Regina Obe <lr at pcorp.us>
Date:   Tue Nov 17 23:53:43 2020 -0500

    Change TopologyElementArray constraint to not exclude null and minor cleanup on news.  Closes #3372 for PostGIS 3.1

diff --git a/NEWS b/NEWS
index 70b4024..aaa227f 100644
--- a/NEWS
+++ b/NEWS
@@ -6,14 +6,14 @@ Only tickets not included in 3.1.0alpha2
   - #4737, Bump minimum protobuf-c requirement to 1.1.0 (Raúl Marín)
            The configure step will now fail if the requirement isn't
            met or explicitly disabled (--without-protobuf)
-  - #4258, Untangle postgis_sfcgal into its own .so (Regina Obe)
+  - #4258, Untangle postgis_sfcgal from postgis
+           into its own lib file (Regina Obe)
 
 * New features *
   - #4698, Add a precision parameter to ST_AsEWKT (Raúl Marín)
   - Add a gridSize optional parameter to ST_Union, ST_UnaryUnion,
     ST_Difference, ST_Intersection, ST_SymDifference, ST_Subdivide
-    (Sandro Santilli)
-  - GEOS 3.9
+    Requires GEOS 3.9 (Sandro Santilli)
 
 * Enhancements *
 
@@ -57,6 +57,7 @@ Only tickets not included in 3.1.0alpha2
   - #4769, Fix segfault in st_addband (Raúl Marín)
   - #4790, Fix ST_3dintersects calculations with identical vertices (Nicklas Avén)
   - #4742, tiger geocoder reverted to 2018 version on tiger upgrade (Regina Obe)
+  - #3372, TopoElementArray cannot be null - change domain constraint (Regina Obe)
 
 
 PostGIS 3.1.0alpha2
diff --git a/topology/topology.sql.in b/topology/topology.sql.in
index 9e67725..c08f1be 100644
--- a/topology/topology.sql.in
+++ b/topology/topology.sql.in
@@ -375,10 +375,22 @@ ALTER DOMAIN topology.TopoElement ADD
 --
 -- TopoElementArray domain
 --
+-- Changed: 3.1.0 - get rid of IS NOT NULL check
 CREATE DOMAIN topology.TopoElementArray AS integer[][]
   CONSTRAINT DIMENSIONS CHECK (
-    array_upper(VALUE, 2) IS NOT NULL
-    AND array_upper(VALUE, 2) = 2
+    array_upper(VALUE, 2) = 2
+    AND array_upper(VALUE, 3) IS NULL
+  );
+
+-- Changed: 3.1.0
+ALTER DOMAIN topology.TopoElementArray DROP CONSTRAINT
+  IF EXISTS
+  DIMENSIONS;
+
+-- Changed: 3.1.0 - get rid of IS NOT NULL check
+ALTER DOMAIN topology.TopoElementArray ADD
+        CONSTRAINT type_range CHECK (
+    array_upper(VALUE, 2) = 2
     AND array_upper(VALUE, 3) IS NULL
   );
 

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

Summary of changes:
 NEWS                     |  7 ++++---
 topology/topology.sql.in | 16 ++++++++++++++--
 2 files changed, 18 insertions(+), 5 deletions(-)


hooks/post-receive
-- 
PostGIS