[postgis-tickets] r16236 - Also test unexpected probin in sfcgal

[Sandro Santilli]

Author: strk
Date: 2018-01-09 09:51:22 -0800 (Tue, 09 Jan 2018)
New Revision: 16236

Modified:
   trunk/regress/sfcgal/regress.sql
Log:
Also test unexpected probin in sfcgal

Modified: trunk/regress/sfcgal/regress.sql
===================================================================
--- trunk/regress/sfcgal/regress.sql	2018-01-09 17:17:28 UTC (rev 16235)
+++ trunk/regress/sfcgal/regress.sql	2018-01-09 17:51:22 UTC (rev 16236)
@@ -289,3 +289,14 @@
 
 -- Drop test table
 DROP table test;
+
+-- Make sure all postgis-referencing probin are using the module
+-- version expected by postgis_lib_version()
+--
+SELECT distinct 'unexpected probin', proname || ':' || probin
+FROM pg_proc
+WHERE probin like '%postgis%'
+	AND probin NOT LIKE '%' ||
+		substring(postgis_lib_version() from '([0-9]*\.[0-9]*)')
+		|| '%'
+ORDER BY 2;