<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<font style="font-size:10pt" color="#366092" face="Arial" size="2">Hello,<br><br><font style="font-size: 10pt;" size="2">I recen<font style="font-size: 10pt;" size="2">tly up<font style="font-size: 10pt;" size="2">graded <font style="font-size: 10pt;" size="2">both my postgresql (from 8.4.4 to 9.2</font></font></font></font>.2) and postgis (from 1.5.3 to 2.<font style="font-size: 10pt;" size="2">0.2 r1<font style="font-size: 10pt;" size="2">0789). With the <font style="font-size: 10pt;" size="2">previous versions I run th<font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2">ese</font> commands without problems:<br><br><font style="font-size: 10pt;" size="2">[code]<br></font></font></font></font></font></font>CREATE TABLE profiles_line_wgs84(<br>GID SERIAL,<br>ID SMALLINT,<br>FID SMALLINT,<br>SURVEY VARCHAR(100),<br>PROFILE VARCHAR(100),<br>TYPE VARCHAR(100),<br>SOURCE VARCHAR(100),<br>NR_TRACES VARCHAR(100),<br>TRACE_SPACE_M VARCHAR(100),<br>LENGTH_M FLOAT,<br>COMMENTS TEXT<br>);<br>SELECT AddGeometryColumn('public', profiles_line_wgs84', 'geom', 4326, 'LINESTRING', 2);<br>CREATE INDEX profiles_line_wgs84_geom ON profiles_line_wgs84 USING GIST ( geom );<br><br>ALTER TABLE profiles_line_wgs84 DROP CONSTRAINT enforce_geotype_geom;<br>ALTER TABLE profiles_line_wgs84 ADD CONSTRAINT enforce_geotype_geom CHECK ((geometrytype(geom) = ANY (ARRAY['MULTILINESTRING'::text, 'LINESTRING'::text])) OR geom IS NULL);<br><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><font style="font-size: 10pt;" size="2">[/code]<br></font><br><font style="font-size: 10pt;" size="2">now <font style="font-size: 10pt;" size="2">wi<font style="font-size: 10pt;" size="2">th postgis 2.0.2</font></font></font> I get these err<font style="font-size: 10pt;" size="2">ors:<br><br>[code<font style="font-size: 10pt;" size="2">]<br>CREATE TABLE<br> addgeometrycolumn <br>---------------------------------------------------------------------------<br> public.seismic_profiles_line_wgs84.geom SRID:4326 TYPE:LINESTRING DIMS:2 <br>(1 row)<br><br>CREATE INDEX<br>psql:13_seismic_profiles_mergecsvshp2line.sql:119: ERROR: constraint "enforce_geotype_geom" of relation "profiles_line_wgs84" does not exist<br>psql:13_seismic_profiles_mergecsvshp2line.sql:128: ERROR: Geometry type (MultiLineString) does not match column type (LineString)</font><br></font>[/code]<br><br><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2">it see<font style="font-size: 10pt;" size="2">ms to me that t<font style="font-size: 10pt;" size="2">he constraint statement is ok, or<font style="font-size: 10pt;" size="2"> is it something missing? any idea is appreciated,<br><br><font style="font-size: 10pt;" size="2">Thanks in advance<font style="font-size: 10pt;" size="2">,<br><br><font style="font-size: 10pt;" size="2">Best regards,<br><br></font></font></font></font></font></font></font><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"></font></font></font></font></font>__________________________________________________________________________________________<br>Piensa en el medio ambie<font style="" face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><br></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><br></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span> <span class="ecxhps">die Umwelt</span></span></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span> <span class="ecxhps">bewahren Sie es</span> <span class="ecxhps">auf dem Bildschirm.</span> <span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span> <span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br> </div></body>
</html>