From fb4b38a3207d77383dbcd16dc26adf4119f5482a Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@kbt.io>
Date: Sun, 29 Oct 2017 20:13:47 +0000
Subject: [PATCH] Make already-registered check in unpackaged extension create
 safer

This version just checks for "postgis" with word boundaries, so
it is immune to localization.

Closes #3913 again

git-svn-id: http://svn.osgeo.org/postgis/trunk@16079 b70326c6-7e19-0410-871a-916f4a2858ee
---
 utils/create_unpackaged.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/utils/create_unpackaged.pl b/utils/create_unpackaged.pl
index e64c8336f..b73d540a7 100755
--- a/utils/create_unpackaged.pl
+++ b/utils/create_unpackaged.pl
@@ -134,7 +134,7 @@ BEGIN
  ALTER EXTENSION $extname ADD $obj;
  RAISE NOTICE 'newly registered $obj';
 EXCEPTION WHEN object_not_in_prerequisite_state THEN
-  IF SQLERRM like '% already a member of extension "$extname"'
+  IF SQLERRM ~ '\\m$extname\\M'
   THEN
     RAISE NOTICE 'already registered $obj';
   ELSE
-- 
2.50.1