[postgis-tickets] r16225 - Add a test for probin correctness

[Sandro Santilli]

Author: strk
Date: 2018-01-09 02:32:22 -0800 (Tue, 09 Jan 2018)
New Revision: 16225

Modified:
   trunk/regress/regress.sql
Log:
Add a test for probin correctness

Hopefully helps catching the bug reported as #3956
(geog_brin_inclusion_add_value not upgraded)

NOTE: only an upgrade test would catch this

Modified: trunk/regress/regress.sql
===================================================================
--- trunk/regress/regress.sql	2018-01-08 17:09:09 UTC (rev 16224)
+++ trunk/regress/regress.sql	2018-01-09 10:32:22 UTC (rev 16225)
@@ -280,3 +280,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;