[postgis-tickets] r16066 - Don't forget "OR REPLACE" in "CREATE FUNCTION!"

Sandro Santilli strk at kbt.io
Thu Oct 26 01:52:00 PDT 2017


Author: strk
Date: 2017-10-26 01:52:00 -0700 (Thu, 26 Oct 2017)
New Revision: 16066

Modified:
   trunk/postgis/postgis.sql.in
Log:
Don't forget "OR REPLACE" in "CREATE FUNCTION!"

Fixes #3919

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2017-10-26 08:48:43 UTC (rev 16065)
+++ trunk/postgis/postgis.sql.in	2017-10-26 08:52:00 UTC (rev 16066)
@@ -413,7 +413,7 @@
 --
 
 -- Availability: 2.5.0
-CREATE FUNCTION geometry_hash(geometry)
+CREATE OR REPLACE FUNCTION geometry_hash(geometry)
 	RETURNS integer
 	AS 'MODULE_PATHNAME','lwgeom_hash'
 	LANGUAGE 'c' STRICT IMMUTABLE _PARALLEL;



More information about the postgis-tickets mailing list