Changes between Version 38 and Version 39 of CookBook join RHT-BDMAP

Timestamp:

Oct 26, 2011 4:47:13 PM (14 years ago)

Author:

celine

Comment:

--

CookBook join RHT-BDMAP

@@ -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);
+drop trigger tr_station_geography on  bdmap2009.station_geography ;
 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);