Changes between Version 39 and Version 40 of CookBook join Temperature_CCM


Ignore:
Timestamp:
May 21, 2010 2:14:49 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • CookBook join Temperature_CCM

    v39 v40  
    3232 
    3333-- création d'index, clé primaire, et contraintes qui vont bien 
    34 alter table temperature.tmp_ccm add column pk serial PRIMARY KEY; 
     34alter table temperature.tmp_ccm ADD CONSTRAINT c_pk_gid PRIMARY KEY (gid); 
    3535alter table temperature.tmp_ccm add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2); 
    3636alter table temperature.tmp_ccm add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);