[postgis-tickets] r17326 - Remove zcta5 geometry constraint

[Regina Obe]

Author: robe
Date: 2019-03-11 07:30:43 -0700 (Mon, 11 Mar 2019)
New Revision: 17326

Modified:
   branches/2.5/NEWS
   branches/2.5/doc/release_notes.xml
   branches/2.5/extras/tiger_geocoder/tables/lookup_tables_2011.sql
Log:
Remove zcta5 geometry constraint
Closes #4086 for PostGIS 2.5.2

Modified: branches/2.5/NEWS
===================================================================
--- branches/2.5/NEWS	2019-03-11 14:24:05 UTC (rev 17325)
+++ branches/2.5/NEWS	2019-03-11 14:30:43 UTC (rev 17326)
@@ -30,9 +30,9 @@
   - #4314, ST_ClipByBox2D: Do not throw when the geometry is invalid (Raúl Marín)
   - #4313, #4307, PostgreSQL 12 compatibility (Laurenz Albe, Raúl Marín)
   - #4290, Schema qualify geometry casts in raster functions (Regina Obe)
+  - #4086, Constraint violation loading tiger_data (zcta5 geometry type) (Regina Obe)
 
 
-
 PostGIS 2.5.1
 2018/11/18
 

Modified: branches/2.5/doc/release_notes.xml
===================================================================
--- branches/2.5/doc/release_notes.xml	2019-03-11 14:24:05 UTC (rev 17325)
+++ branches/2.5/doc/release_notes.xml	2019-03-11 14:30:43 UTC (rev 17326)
@@ -38,6 +38,7 @@
           <para>#4314, ST_ClipByBox2D: Do not throw when the geometry is invalid (Raúl Marín)</para>
           <para>#4313, #4307, PostgreSQL 12 compatibility (Laurenz Albe, Raúl Marín)</para>
           <para>#4290, Schema qualify geometry casts in raster functions (Regina Obe)</para>
+          <para>#4086, Constraint violation loading tiger_data (zcta5 geometry type) (Regina Obe)</para>
       </simplesect>
     </sect1>
 

Modified: branches/2.5/extras/tiger_geocoder/tables/lookup_tables_2011.sql
===================================================================
--- branches/2.5/extras/tiger_geocoder/tables/lookup_tables_2011.sql	2019-03-11 14:24:05 UTC (rev 17325)
+++ branches/2.5/extras/tiger_geocoder/tables/lookup_tables_2011.sql	2019-03-11 14:30:43 UTC (rev 17326)
@@ -1327,7 +1327,6 @@
   the_geom geometry,
   CONSTRAINT uidx_tiger_zcta5_gid UNIQUE (gid),
   CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
-  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL),
   CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4269),
   CONSTRAINT pk_tiger_zcta5_zcta5ce PRIMARY KEY (zcta5ce,statefp)
  );