<!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.6000.16414" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi all ,</FONT></DIV>
<DIV><FONT face=Arial
size=2>
when I am trying to do </FONT>SELECT assign_vertex_id(’road′,
0.1);</DIV>
<DIV> </DIV>
<DIV> I am getting following errors,</DIV>
<DIV> -- While Executing query First time<BR>SELECT
assign_vertex_id('road', 1);</DIV>
<DIV> </DIV>
<DIV>ERROR: new row for relation "vertices_tmp" violates check constraint
"enforce_srid_the_geom"<BR>CONTEXT: SQL statement "INSERT INTO
vertices_tmp (the_geom) VALUES ( $1 )"<BR>PL/pgSQL function "point_to_id" line
11 at SQL statement<BR>PL/pgSQL function "assign_vertex_id" line 22 at
assignment</DIV>
<DIV> </DIV>
<DIV><BR>-- While Executing the same query Second time:<BR>SELECT
assign_vertex_id('road', 1);</DIV>
<DIV> </DIV>
<DIV>ERROR: relation with OID 18309 does not exist<BR>CONTEXT: SQL
statement "SELECT id, the_geom FROM vertices_tmp WHERE
distance(the_geom, $1 ) < $2 "<BR>PL/pgSQL function "point_to_id"
line 7 at select into variables<BR>PL/pgSQL function "assign_vertex_id" line 22
at assignment .</DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Can any one suggest me why these errors are
occurring and how can I rectify them?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks & Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Radhika.</FONT></DIV></BODY></HTML>