<html><body><div style="font-family: garamond, new york, times, serif; font-size: 12pt; color: #000000"><div><span style="color: rgb(0, 0, 0);">Hye.</span></div><div>I have a question about the check constraints on the PostGIS columns type<br>Can you explain me why we got check constraints on old version (here 1.5.2) of PostGIS and now we don't see such constraints with 2.0 when we ask a describe of such relation.<br>I precise that the 2 objects have been created with same query (same function) on two servers.<br><br></div><div>>>> select AddGeometryColumn('d1','contour',4326,'MULTIPOLYGON',2);</div><div><br></div><div>POSTGIS 1.5<br></div><div>___________________<br></div><div>bd=> \d d1<br> Column | Type | Modifiers<br>----------+----------+-----------<br> idmenage | integer | not null<br> contour | geometry |</div><div>Indexes:<br> "idx1_d1" btree (idmenage), tablespace "bde_data"<br>Check constraints:<br> "enforce_dims_contour" CHECK (st_ndims(contour) = 2)<br> "enforce_geotype_contour" CHECK (geometrytype(contour) = 'MULTIPOLYGON'::text OR contour IS NULL)<br> "enforce_srid_contour" CHECK (st_srid(contour) = 4326)</div><div><span data-mce-bogus="true"><span style="color: rgb(0, 0, 0);"><br></span></span></div><div><span data-mce-bogus="true"><span style="color: rgb(0, 0, 0);"><br></span></span></div><div>POSTGIS 2.0<br></div><div>___________________</div><div>bde=> \d d1<br> Column | Type | Modifiers<br>----------+-----------------------------+-----------<br> idmenage | integer | not null<br> contour | geometry(MultiPolygon,4326) |<br>Indexes:<br> "idx1_d1" btree (idmenage)<br><div><br></div></div><div><br></div><div>The difference is that the type added by function is not really the same.<br></div><div>Are constraints not visible but internal ?<br></div><div>Thanks.<br></div><div><br></div><div><span name="x"></span><div><div class="Section1"><span class="Object"></span><div class="Section1"><hr><p><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><b><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"></span></b></span></p><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><b><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;">David </span></b></span><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><b><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;">PEYRIERES</span></b></span><br><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><span style="font-size: 7.5pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 7.5pt; font-family: Arial; color: #001c4d;">Direction des Sytèmes d'Information</span></span><br><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><span style="font-size: 7.5pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 7.5pt; font-family: Arial; color: #001c4d;">Division Etudes et Développements</span></span><br><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><span style="font-size: 7.5pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 7.5pt; font-family: Arial; color: #001c4d;">Administration et Support Bases de Données<br></span></span><p><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><span style="font-size: 7.5pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 7.5pt; font-family: Arial; color: #001c4d;">Tel : <span class="Object" id="OBJ_PREFIX_DWT466_com_zimbra_phone"><a data-mce-href="callto:+33%20%280%295.6.07.83.36" href="callto:+33%20%280%295.61.07.83.36">+33 (0)5.61.07.83.36</a></span> <br> Fax : <span class="Object" id="OBJ_PREFIX_DWT467_com_zimbra_phone"><a href="callto:+33%20%280%295.61.07.81.09" data-mce-href="callto:+33%20%280%295.61.07.81.09">+33 (0)5.61.07.81.09</a></span> <br> </span><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><span class="Object" id="OBJ_PREFIX_DWT468_com_zimbra_email"><span class="Object" id="OBJ_PREFIX_DWT472_com_zimbra_email"><a href="mailto:david.peyrieres@meteo.fr" target="_blank" data-mce-href="mailto:david.peyrieres@meteo.fr">david.peyrieres@meteo.fr</a></span></span><br> </span><b><span style="font-family: Arial; color: #001c4d;" data-mce-style="font-family: Arial; color: #001c4d;"></span></b></span></p><p><b><span style="font-family: Arial; color: #001c4d;" data-mce-style="font-family: Arial; color: #001c4d;">METEO FRANCE</span></b><span style="font-family: Arial; color: #001c4d;" data-mce-style="font-family: Arial; color: #001c4d;"> </span><span style="font-size: 10pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 10pt; font-family: Arial; color: #001c4d;"><br> <span class="Object"><span class="Object"><a href="http://www.meteo.fr/" target="_blank" data-mce-href="http://www.meteo.fr/">www.meteo.fr</a></span></span> </span><span style="font-size: 7.5pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 7.5pt; font-family: Arial; color: #001c4d;"><br> 42 avenue Gustave Coriolis <br> 31057 TOULOUSE Cédex <br></span></p><p><span style="font-size: 7.5pt; font-family: Arial; color: #001c4d;" data-mce-style="font-size: 7.5pt; font-family: Arial; color: #001c4d;"></span></p><hr></div></div></div><span name="x"></span><br></div></div></body></html>