<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im"><br>
</div>Yes, I have to build topology if I want to use pgRouting because id from<br>
TeleAtalas are 'long integer' and not 'integer' (this create a type error) and<br>
don't start from 1,<br>
this is an example: 173800024175760.<br>
<br>
<div><div class="h5"><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank"></a></div></div></blockquote><div><br></div><div>If your overall number of network links fits into type "integer" (what I think is the case for Italy), then you could create a temporary table with all existing start or end ID's. If you add a column with type serial, this column will be then populated with numbers starting from 1.</div>
<div>You then can add additional columns to your network table for integer start and end ID and update them with the serial ID from the temporary table.</div><div><br></div><div>Daniel</div></div><br clear="all"><br>-- <br>
<span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>