[postgis-tickets] r15603 - Always show PGSQL version scripts were built against

[Sandro Santilli]

Author: strk
Date: 2017-08-29 00:27:47 -0700 (Tue, 29 Aug 2017)
New Revision: 15603

Modified:
   trunk/NEWS
   trunk/postgis/postgis.sql.in
Log:
Always show PGSQL version scripts were built against

also add a missing NEWS item

Modified: trunk/NEWS
===================================================================
--- trunk/NEWS	2017-08-28 20:29:14 UTC (rev 15602)
+++ trunk/NEWS	2017-08-29 07:27:47 UTC (rev 15603)
@@ -2,7 +2,8 @@
 2017/09/xx
 
  * New Features *
-
+  - #3822, Have postgis_full_version() also show and check version of
+           PostgreSQL the scripts were built against (Sandro Santilli)
   - #2411, curves support in ST_Reverse (Sandro Santilli)
   - #2951, ST_Centroid for geography (Danny Götte)
   - #3788, Allow postgis_restore.pl to work on directory-style (-Fd) dumps

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2017-08-28 20:29:14 UTC (rev 15602)
+++ trunk/postgis/postgis.sql.in	2017-08-29 07:27:47 UTC (rev 15603)
@@ -2877,6 +2877,10 @@
 		fullver = fullver || ' (liblwgeom version mismatch: "' || liblwgeomver || '")';
 	END IF;
 
+	fullver = fullver || ' PGSQL="' || pgsql_scr_ver || '"';
+	IF pgsql_scr_ver != pgsql_ver THEN
+		fullver = fullver || ' (procs need upgrade for use with "' || pgsql_ver || '")';
+	END IF;
 
 	IF  geosver IS NOT NULL THEN
 		fullver = fullver || ' GEOS="' || geosver || '"';
@@ -2913,10 +2917,6 @@
 		fullver = fullver || ' (core procs from "' || dbproc || '" need upgrade)';
 	END IF;
 
-	IF pgsql_scr_ver != pgsql_ver THEN
-		fullver = fullver || ' (procs built against PostgreSQL "' || pgsql_scr_ver || '" need upgrade)';
-	END IF;
-
 	IF topo_scr_ver IS NOT NULL THEN
 		fullver = fullver || ' TOPOLOGY';
 		IF topo_scr_ver != relproc THEN