[postgis-tickets] r15509 - add missing file missed in last commit

[Regina Obe]

Author: robe
Date: 2017-07-27 10:45:39 -0700 (Thu, 27 Jul 2017)
New Revision: 15509

Added:
   trunk/extensions/postgis_tiger_geocoder/sql_bits/upgrade_before.sql.in
Log:
add missing file missed in last commit 
References #3747

Added: trunk/extensions/postgis_tiger_geocoder/sql_bits/upgrade_before.sql.in
===================================================================
--- trunk/extensions/postgis_tiger_geocoder/sql_bits/upgrade_before.sql.in	                        (rev 0)
+++ trunk/extensions/postgis_tiger_geocoder/sql_bits/upgrade_before.sql.in	2017-07-27 17:45:39 UTC (rev 15509)
@@ -0,0 +1,10 @@
+-- these introduced in PostGIS 2.4
+DO language plpgsql
+$$
+    BEGIN
+        ALTER TYPE tiger.norm_addy ADD ATTRIBUTE zip4 varchar;
+        ALTER TYPE tiger.norm_addy ADD ATTRIBUTE address_alphanumeric varchar;
+    EXCEPTION
+        WHEN others THEN  -- ignore the error probably cause it already exists
+    END;
+$$;
\ No newline at end of file