<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>Sandro is righ for the sirdt....To my
point of view U have follow example </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><!--StartFragment -->
<P>Example1: <SPAN><B class=command>SELECT AddGeometryColumn('public',
'roads_geom', 'geom', 423, 'LINESTRING', 2)</B></SPAN></P>
<P>Example2: <SPAN><B class=command>SELECT AddGeometryColumn( 'roads_geom',
'geom', 423, 'LINESTRING', 2)</B></SPAN></P>
<P><SPAN><FONT face=Arial color=#0000ff size=2>from <A
href="http://postgis.refractions.net/docs/ch04.html#id3212013">http://postgis.refractions.net/docs/ch04.html#id3212013</A></FONT></SPAN></P>
<P><SPAN><FONT face=Arial color=#0000ff size=2>here sird=-1 and not
423</FONT></SPAN></P>
<P><SPAN><FONT face=Arial color=#0000ff size=2>use <SPAN><B class=command><FONT
face="Times New Roman" color=#000000 size=3>SELECT AddGeometryColumn('public',
'roads_geom', 'geom', -1, 'LINESTRING', 2)
instead</FONT></B></SPAN></FONT></SPAN></P></DIV>
<DIV>---------------------------------------------------------------<BR>TECHER
Jean David<BR>01MAP<BR>e-mail: <A
href="mailto:david@01map.net">david@01map.net</A><BR>Tél: 04 67 45 60
27<BR>Entreprise: <A
href="http://www.01map.net">http://www.01map.net</A><BR>Perso: <A
href="http://techer.pascal.free.fr/postgis/">http://techer.pascal.free.fr/postgis/</A><BR>---------------------------------------------------------------</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=datenpunk@gmail.com href="mailto:datenpunk@gmail.com">daniel khan</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 19, 2005 3:09
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [postgis-users] Newbie
problems</DIV>
<DIV><BR></DIV>Hello List,<BR><BR>I am currently testing OpenGIS.<BR>I am also
quite new to postgres as I only want to use it as GIS<BR>backend but I know
how to use RDBMs in general.<BR><BR>I installed PostGIS and created the
neccessary tables for the metadata<BR>and I also was able to follow some of
the examples at the beginning of<BR>the manual.<BR><BR>But now I have a
problem:<BR><BR>INSERT INTO ROADS_GEOM (ID,GEOM,NAME )
VALUES<BR>(1,GeomFromText('LINESTRING(191232 243118,191108
243242)',-1),'Jeff<BR>Rd');<BR><BR>gives<BR><BR>ERROR: new row for
relation "roads_geom" violates check
constraint<BR>"enforce_srid_geom"<BR><BR>I understand what this generally
means but I don't understand it in<BR>GIS context.<BR>What am I doing wrong? I
am trying to understand the whole thing so<BR>removing the constraint may help
in this case but won't explain the<BR>problem to me..<BR><BR>Thanks in
advance<BR><BR>--
<BR>Daniel<BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></BLOCKQUOTE></BODY></HTML>