[postgis-tickets] r16079 - Make already-registered check in unpackaged extension create safer

[Sandro Santilli]

Author: strk
Date: 2017-10-29 13:13:47 -0700 (Sun, 29 Oct 2017)
New Revision: 16079

Modified:
   trunk/utils/create_unpackaged.pl
Log:
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

Modified: trunk/utils/create_unpackaged.pl
===================================================================
--- trunk/utils/create_unpackaged.pl	2017-10-29 18:38:53 UTC (rev 16078)
+++ trunk/utils/create_unpackaged.pl	2017-10-29 20:13:47 UTC (rev 16079)
@@ -134,7 +134,7 @@
  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