<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>
Dear all,<br>When i create an sql using shp2pgsql, the sql creates a constraint, i dont understand and it is not explicit in the sql. The sql is thus:-<br><font size="2"><span style="font-style: italic;">CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL),</span></font><br>The problem is it wont allow me to edit_move or edit_line a line. Could it be implicit in these and what does it mean?<br><font style="font-style: italic;" size="2">SELECT AddGeometryColumn('','contours,'the_geom','-1','MULTILINESTRING',4);<br>CREATE INDEX "contours_the_geom_gist" ON "contours" using gist ("the_geom" gist_geometry_ops);</font><br><br>Broun Uganda<br><br /><hr />Change is good. See what's different about Windows Live Hotmail. <a href='http://www.windowslive-hotmail.com/learnmore/default.html?locale=en-us&ocid=RMT_TAGLM_HMWL_reten_changegood_0607' target='_new'>Check it out!</a></body>
</html>