[postgis-tickets] r15190 - Fix aggregates upgrade

[Sandro Santilli]

Author: strk
Date: 2016-10-07 13:05:59 -0700 (Fri, 07 Oct 2016)
New Revision: 15190

Modified:
   branches/2.3/.drone.yml
   branches/2.3/NEWS
   branches/2.3/postgis/postgis.sql.in
Log:
Fix aggregates upgrade

Fixes #3656 (aggregate upgrades)

Enables automated ugprade testing

Modified: branches/2.3/.drone.yml
===================================================================
--- branches/2.3/.drone.yml	2016-10-07 20:00:46 UTC (rev 15189)
+++ branches/2.3/.drone.yml	2016-10-07 20:05:59 UTC (rev 15190)
@@ -19,3 +19,5 @@
     commands:
       - service postgresql start
       - make check
+      - make install
+      - utils/check_all_upgrades.sh 2.4.0dev

Modified: branches/2.3/NEWS
===================================================================
--- branches/2.3/NEWS	2016-10-07 20:00:46 UTC (rev 15189)
+++ branches/2.3/NEWS	2016-10-07 20:05:59 UTC (rev 15190)
@@ -5,6 +5,7 @@
   - #3643, PostGIS not building on latest OSX XCode
   - #3644, Deadlock on interrupt
   - #3652, Crash on Collection(MultiCurve())
+  - #3656, Fix upgrade of aggregates from 2.2 or lower version
 
 PostGIS 2.3.0
 2016/09/26

Modified: branches/2.3/postgis/postgis.sql.in
===================================================================
--- branches/2.3/postgis/postgis.sql.in	2016-10-07 20:00:46 UTC (rev 15189)
+++ branches/2.3/postgis/postgis.sql.in	2016-10-07 20:05:59 UTC (rev 15190)
@@ -3742,6 +3742,8 @@
 
 
 -- Availability: 1.2.2
+-- Changed: 2.2.0 to use non-deprecated ST_CombineBBox (r13535)
+-- Changed: 2.3.0 to support PostgreSQL 9.6
 CREATE AGGREGATE ST_Extent(
 	sfunc = ST_CombineBBox,
 #if POSTGIS_PGSQL_VERSION >= 96
@@ -3753,6 +3755,8 @@
 	);
 
 -- Availability: 2.0.0
+-- Changed: 2.2.0 to use non-deprecated ST_CombineBBox (r13535)
+-- Changed: 2.3.0 to support PostgreSQL 9.6
 CREATE AGGREGATE ST_3DExtent(
 	sfunc = ST_CombineBBox,
 #if POSTGIS_PGSQL_VERSION >= 96
@@ -3769,6 +3773,7 @@
 	LANGUAGE 'c' IMMUTABLE  _PARALLEL;
 
 -- Availability: 1.2.2
+-- Changed: 2.3.0 to support PostgreSQL 9.6
 CREATE AGGREGATE ST_MemCollect(
 	sfunc = ST_collect,
 #if POSTGIS_PGSQL_VERSION >= 96
@@ -3785,6 +3790,7 @@
 	LANGUAGE 'c' IMMUTABLE STRICT  _PARALLEL;
 
 -- Availability: 1.2.2
+-- Changed: 2.3.0 to support PostgreSQL 9.6
 CREATE AGGREGATE ST_MemUnion (
 	basetype = geometry,
 	sfunc = ST_Union,