Changes between Version 25 and Version 26 of Cookbook CCM21_France


Ignore:
Timestamp:
Jul 27, 2010 2:56:02 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Cookbook CCM21_France

    v25 v26  
    103103    SELECT * FROM ccm21.riversegments 
    104104        WHERE wso_id IN (SELECT wso_id FROM france.wso WHERE area='France'); 
    105 ALTER TABLE ccm21.riversegments_France ADD CONSTRAINT c_pk_gid_riversegments_Bretagne PRIMARY KEY  (gid); 
     105ALTER TABLE ccm21.riversegments_France ADD CONSTRAINT c_pk_gid_riversegments_France PRIMARY KEY  (gid); 
    106106INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") 
    107107SELECT '', 'ccm21', 'riversegments_Bretagne', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)