[postgis-tickets] r16881 - Mark postgis_extensions_upgrade as volatile

[Sandro Santilli]

Author: strk
Date: 2018-10-10 13:41:27 -0700 (Wed, 10 Oct 2018)
New Revision: 16881

Modified:
   trunk/postgis/postgis.sql.in
Log:
Mark postgis_extensions_upgrade as volatile

NOTE: does not solve the problem of not noticing
      repackaging (reported in
      https://trac.osgeo.org/postgis/ticket/4196#comment:4)

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2018-10-10 20:36:51 UTC (rev 16880)
+++ trunk/postgis/postgis.sql.in	2018-10-10 20:41:27 UTC (rev 16881)
@@ -2902,7 +2902,7 @@
 	RETURN @extschema at .postgis_full_version();
 
 END
-$$ language plpgsql;
+$$ LANGUAGE plpgsql VOLATILE;
 
 -- Changed: 2.4.0
 CREATE OR REPLACE FUNCTION postgis_full_version() RETURNS text