From e4327b57c88d11ae6eabf2dca604033a5b2f3a4e Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@kbt.io>
Date: Tue, 9 Jan 2018 10:32:22 +0000
Subject: [PATCH] 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

git-svn-id: http://svn.osgeo.org/postgis/trunk@16225 b70326c6-7e19-0410-871a-916f4a2858ee
---
 regress/regress.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/regress/regress.sql b/regress/regress.sql
index 1c4fdf443..402e216b4 100644
--- a/regress/regress.sql
+++ b/regress/regress.sql
@@ -280,3 +280,14 @@ select '226', ST_SRID(ST_Expand('SRID=4326;POINT (0 0)'::geometry, 1))=4326;
 
 -- 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;
-- 
2.40.0