[postgis-users] Newbie problems

[daniel khan]

Hello List,

I am currently testing OpenGIS.
I am also quite new to postgres as I only want to use it as GIS
backend but I know how to use RDBMs in general.

I installed PostGIS and created the neccessary tables for the metadata
and I also was able to follow some of the examples at the beginning of
the manual.

But now I have a problem:

INSERT INTO ROADS_GEOM (ID,GEOM,NAME ) VALUES
(1,GeomFromText('LINESTRING(191232 243118,191108 243242)',-1),'Jeff
Rd');

gives

ERROR:  new row for relation "roads_geom" violates check constraint
"enforce_srid_geom"

I understand what this generally means but I don't understand it in
GIS context.
What am I doing wrong? I am trying to understand the whole thing so
removing the constraint may help in this case but won't explain the
problem to me..

Thanks in advance

-- 
Daniel