Hello,
I recently upgraded both my postgresql (from 8.4.4 to 9.2.2) and postgis (from
1.5.3 to 2.0.2 r10789). With the previous versions I run these commands without
problems:
[code]
CREATE TABLE profiles_line_wgs84(
GID SERIAL,
ID SMALLINT,
FID SMALLINT,
SURVEY VARCHAR(100),
PROFILE VARCHAR(100),
TYPE VARCHAR(100),
SOURCE VARCHAR(100),
NR_TRACES VARCHAR(100),
TRACE_SPACE_M VARCHAR(100),
LENGTH_M FLOAT,
COMMENTS TEXT
);
SELECT AddGeometryColumn('public', profiles_line_wgs84', 'geom', 4326,
'LINESTRING', 2);
CREATE INDEX profiles_line_wgs84_geom ON profiles_line_wgs84 USING GIST ( geom
);
ALTER TABLE profiles_line_wgs84 DROP CONSTRAINT enforce_geotype_geom;
ALTER TABLE profiles_line_wgs84 ADD CONSTRAINT enforce_geotype_geom CHECK
((geometrytype(geom) = ANY (ARRAY['MULTILINESTRING'::text,
'LINESTRING'::text])) OR geom IS NULL);
[/code]
now with postgis 2.0.2 I get these errors:
[code]
CREATE TABLE
addgeometrycolumn
---------------------------------------------------------------------------
public.seismic_profiles_line_wgs84.geom SRID:4326 TYPE:LINESTRING DIMS:2
(1 row)
CREATE INDEX
psql:13_seismic_profiles_mergecsvshp2line.sql:119: ERROR: constraint
"enforce_geotype_geom" of relation "profiles_line_wgs84" does not exist
psql:13_seismic_profiles_mergecsvshp2line.sql:128: ERROR: Geometry type
(MultiLineString) does not match column type (LineString)
[/code]
it seems to me that the constraint statement is ok, or is it something
missing? any idea is appreciated,
Thanks in advance,
Best regards,
__________________________________________________________________________________________
Piensa en el medio ambiente - mantenlo en la pantalla. NO lo imprimas si NO es
necesario.
Think green - keep it on the screen. Do NOT print if it is NOT necessary.
Denken Sie an die Umwelt - bewahren Sie es auf dem Bildschirm. Drucken Sie
NICHT, wenn es NICHT notwendig ist.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
