Changes between Version 34 and Version 35 of CookBook join RHT-BDMAP

Timestamp:

Oct 26, 2011 11:44:29 AM (14 years ago)

Author:

celine

Comment:

--

CookBook join RHT-BDMAP

@@ -310 +310 @@
 }}}
 
-BDMAP - Projection Laurent
+= BDMAP - Projection Laurent =
 {{{
 d:
@@ -320 +320 @@
 ---Changement du système de projection  RGF93_Lambert_93 (srid 2154) --> ETRS LAEA (srid 3035)
 alter table bdmap2009.station_geography drop constraint enforce_srid_the_geom;
-update bdmap2009.station_geography set the_geom =ST_Transform(the_geom,3035);
+---update bdmap2009.station_geography set the_geom =ST_Transform(the_geom,3035);
+update bdmap2009.station_geography set the_geom =ST_Transform(ST_SetSRID(the_geom,2154),3035);
+ERREUR:  Operation on two geometries with different SRIDs
+CONTEXT:  PL/pgSQL function "geom_update" line 5 at IF
+
+********** Erreur **********
+
+ERREUR: Operation on two geometries with different SRIDs
+État SQL :XX000
+Contexte : PL/pgSQL function "geom_update" line 5 at IF
 
 alter table bdmap2009.station_geography add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);