Changes between Version 39 and Version 40 of CookBook join Temperature_CCM
- Timestamp:
- May 21, 2010 2:14:49 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join Temperature_CCM
v39 v40 32 32 33 33 -- création d'index, clé primaire, et contraintes qui vont bien 34 alter table temperature.tmp_ccm add column pk serial PRIMARY KEY;34 alter table temperature.tmp_ccm ADD CONSTRAINT c_pk_gid PRIMARY KEY (gid); 35 35 alter table temperature.tmp_ccm add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2); 36 36 alter table temperature.tmp_ccm add CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);