[postgis-tickets] r16745 - Report raster extension status from postgis_full_version()

[Sandro Santilli]

Author: strk
Date: 2018-09-11 02:19:46 -0700 (Tue, 11 Sep 2018)
New Revision: 16745

Modified:
   trunk/postgis/postgis.sql.in
Log:
Report raster extension status from postgis_full_version()

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2018-09-11 09:19:41 UTC (rev 16744)
+++ trunk/postgis/postgis.sql.in	2018-09-11 09:19:46 UTC (rev 16745)
@@ -3007,6 +3007,12 @@
 		IF rast_lib_ver != relproc THEN
 			fullver = fullver || ' (raster lib from "' || rast_lib_ver || '" need upgrade)';
 		END IF;
+		IF core_is_extension AND NOT EXISTS (
+			SELECT * FROM pg_catalog.pg_extension
+			WHERE extname = 'postgis_raster')
+		THEN
+				fullver = fullver || ' [UNPACKAGED!]';
+		END IF;
 	END IF;
 
 	IF rast_scr_ver IS NOT NULL AND rast_scr_ver != relproc THEN