[postgis-users] Newbie problems

[Christian Schwartze]

Hi Daniel,

its possible that '-1' in your SELECT-Statement is incorrect, because when
creating the spatial table may be the srid was set to another value
referencing to a spatial system...'-1 'means: none spatial reference
system...
May be you already know that...

Christian.

----- Original Message ----- 
From: "daniel khan" <datenpunk at gmail.com>
To: <postgis-users at postgis.refractions.net>
Sent: Thursday, May 19, 2005 3:09 PM
Subject: [postgis-users] Newbie problems


> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users