<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@01C616B2.B55564A0">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>115</w:Zoom>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;
mso-font-alt:"Courier New";
mso-font-charset:0;
mso-generic-font-family:modern;
mso-font-format:other;
mso-font-pitch:fixed;
mso-font-signature:3 0 0 0 1 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1218200129;
mso-list-type:hybrid;
mso-list-template-ids:-2073409058 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi all:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks everyone, especially <span class=SpellE>Alexandre</span>,
helping me to install <span class=SpellE>PostGIS</span> and <span class=SpellE>pgdijkstra</span>
on windows. Now I have a new problem need your help.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I download the demo data and following user manual (page 28)
to create a table <span class=SpellE>roads_europe</span> and populate the data.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When I run following command, I got an error.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Command:<span
style='mso-spacerun:yes'> </span></span></font><font size=1 face=Courier><span
style='font-size:8.0pt;font-family:Courier;mso-bidi-font-family:Courier'>SELECT
<span class=SpellE>assign_vertex_<span class=GramE>id</span></span><span
class=GramE>(</span>'<span class=SpellE>roads_europe</span>', 1);</span></font><font
size=2 face=Courier><span style='font-size:10.0pt;font-family:Courier;
mso-bidi-font-family:Courier'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Error message:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ERROR:<span style='mso-spacerun:yes'> </span>relation with
OID 17715 does not exist<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>CONTEXT:<span style='mso-spacerun:yes'> </span>SQL
statement "<span class=GramE>SELECT<span style='mso-spacerun:yes'>
</span>id</span>, <span class=SpellE>the_geom</span> FROM <span class=SpellE>vertices_tmp</span>
WHERE distance(<span class=SpellE>the_geom</span>,<span
style='mso-spacerun:yes'> </span>$1 ) <<span style='mso-spacerun:yes'>
</span>$2 "<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>PL/<span class=SpellE>pgSQL</span> function "<span
class=SpellE>point_to_id</span>" line 7 at select into variables<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>PL/<span class=SpellE>pgSQL</span> function "<span
class=SpellE>assign_vertex_id</span>" line 22 at assignment<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>What is OID 17715? Why I got this error? What I did wrong?
Following is step by step of what I did:<o:p></o:p></span></font></p>
<ol style='mso-margin-top-alt:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l0 level1 lfo1;tab-stops:list .5in'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>shp2pgsql
C:\temp\roadl.shp <span class=SpellE>roads_europe_tmp</span> > C:\temp\roadl.sql<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1;tab-stops:list .5in'><span
class=SpellE><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>psql</span></font></span><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> –d <span class=SpellE>dcmms</span>
–f <span style='mso-spacerun:yes'> </span>C:\temp\roadl.sql<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1;tab-stops:list .5in'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></li>
</ol>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'> </span>CREATE TABLE <span
class=SpellE>roads_europe</span> (<span class=SpellE>gid</span> <span
class=SpellE>int</span> UNIQUE, <span class=SpellE>source_id</span> <span
class=SpellE>int</span>, <span class=SpellE>target_id</span> <span
class=SpellE>int</span>);<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'> </span>SELECT <span
class=SpellE><span class=GramE>AddGeometryColumn</span></span><span
class=GramE>(</span>'<span class=SpellE>roads_europe</span>', '<span
class=SpellE>the_geom</span>', -1, 'MULTILINESTRING', 2 );<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'> </span>INSERT INTO <span
class=SpellE>roads_europe</span> (<span class=SpellE>gid</span>, <span
class=SpellE>the_geom</span>) (SELECT <span class=SpellE>gid</span>, <span
class=SpellE>the_geom</span> FROM <span class=SpellE>roads_europe_tmp</span>);<o:p></o:p></span></font></p>
<ol style='mso-margin-top-alt:0in' start=4 type=1>
<li class=MsoNormal style='mso-list:l0 level1 lfo1;tab-stops:list .5in'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><span
style='mso-spacerun:yes'> </span>SELECT <span class=SpellE>assign_vertex_id</span>(‘<span
class=SpellE>roads_europe</span>’, 1);<o:p></o:p></span></font></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>I created a new database and use different
data, I still got same error message.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Thanks in advance for your help.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Fay<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><span style='mso-spacerun:yes'> </span><o:p></o:p></span></font></p>
</div>
</body>
</html>