Stephen, Had to fix the typos, but this does seem to work. thanks. Here is the updated SQL:
CREATE TABLE parks ( park_id INTEGER, park_name VARCHAR, park_date DATE, park_type VARCHAR, park_geom geometry, CONSTRAINT enforce_dims_park_geom CHECK (st_ndims(park_geom) = 2), CONSTRAINT enforce_geotype_park_geom CHECK (geometrytype(park_geom) = 'MULTIPOLYGON'::text OR park_geom IS NULL), CONSTRAINT enforce_srid_park_geom CHECK (st_srid(park_geom) = 4326) ); -Greg On Jun 27, 2010, at 11:14 PM, Stephen Woodbridge wrote: > CREATE TABLE parks ( > park_id INTEGER, > park_name VARCHAR, > park_date DATE, > park_type VARCHAR, > park_geom geomtery, > CONSTRAINT enforce_dims_park_geom CHECK (st_ndims(park_geom) = 2), > CONSTRAINT enforce_geotype_park_geom CHECK (geometrytype(park_geom) = > 'MULTIPOLYGON'::text OR the_geom IS NULL), > CONSTRAINT enforce_srid_park_geom CHECK (st_srid(park_geom) = 4326) > );
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
