<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Daniel,<br>
<br>
I don't know how to fix that but if anybody have an idea i can spent
some time trying...<br>
<span id="result_box" class="short_text" lang="en"><span class="hps">any
tips on</span> <span class="hps">how to solve the</span> <span
class="hps">problem?<br>
</span></span><span id="result_box" class="short_text" lang="en"><span
class="hps">I created</span> <span class="hps">a</span> <span
class="hps">new ticket:<br>
<br>
<a class="moz-txt-link-freetext" href="https://github.com/pgRouting/pgrouting/issues/58">https://github.com/pgRouting/pgrouting/issues/58</a><br>
<br>
<br>
thanks<br>
<br>
</span></span><br>
<br>
<br>
<br>
Em 06-06-2012 20:19, Daniel Kastl escreveu:
<blockquote
cite="mid:CABXBSH8+FU-dijUbwzrXQwNMRqwU8j93=FBmr9qoQWnur5GvbQ@mail.gmail.com"
type="cite">Hi Pedro,
<div><br>
</div>
<div>If you were able to fix assign_vertex_id function for PostGIS
2.0, adding a ticket to the GitHub issue tracker [1] would be
nice ... and even better with some patch.</div>
<div><br>
</div>
<div>Daniel</div>
<div><br>
</div>
<div>[1] <a moz-do-not-send="true"
href="https://github.com/pgrouting/pgrouting/issues?state=open">https://github.com/pgrouting/pgrouting/issues?state=open</a></div>
<div><br>
<br>
<div class="gmail_quote">On Wed, Jun 6, 2012 at 8:00 PM, Stephen
Woodbridge <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On 6/6/2012 12:53 PM, Pedro Costa wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
I'm trying now with postgis 2.0 and successfully create
the templatefor<br>
routing based on postgis template 2.0.<br>
<br>
The problem I found is the function assign_vertex that
gives the<br>
following error:<br>
<br>
<br>
NOTICE: CREATE TABLE will create implicit sequence
"vertices_tmp_id_seq"<br>
for serial column "<a moz-do-not-send="true"
href="http://vertices_tmp.id" target="_blank">vertices_tmp.id</a>"<br>
CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id
serial)"<br>
PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE
statement<br>
<br>
<br>
ERROR: find_srid() - couldnt find the corresponding SRID
- is the<br>
geometry registered in the GEOMETRY_COLUMNS table? Is
there an<br>
uppercase/lowercase missmatch?<br>
<br>
<br>
In postgis 2.0 we do not have table geometry_columns,
anybody know how<br>
to solve this problem?<br>
</blockquote>
<br>
</div>
select Populate_Geometry_Columns();<br>
<br>
should fix this.<br>
<br>
-Steve<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">
Thanks<br>
<br>
Pedro<br>
<br>
<br>
<br>
Em 05-06-2012 03:40, Sanak escreveu:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">
Hi Ricardo,<br>
I don't know all of the windows binaries, but I have
not build 64bit<br>
one yet.<br>
PostGIS team have already supported windows
mingw-64bit build,<br>
<a moz-do-not-send="true"
href="http://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html"
target="_blank">http://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html</a><br>
<a moz-do-not-send="true"
href="http://www.postgis.org/download/windows/#postgis-installers"
target="_blank">http://www.postgis.org/download/windows/#postgis-installers</a><br>
and began to make more crossplatform build system.(I
guess this means<br>
move to cmake/msvc in windows).<br>
<a moz-do-not-send="true"
href="http://blog.opengeo.org/2012/05/17/postgis-code-sprint-recap/"
target="_blank">http://blog.opengeo.org/2012/05/17/postgis-code-sprint-recap/</a><br>
So, if the demand for windows 64bit binary seems to be
large,<br>
I will begin to investigate about it on my<br>
git(<a moz-do-not-send="true"
href="https://github.com/sanak/pgrouting"
target="_blank">https://github.com/sanak/pgrouting</a>)<br>
mingw/msvc branch.<br>
Regards,<br>
2012/6/4 Ricardo Bayley <<a moz-do-not-send="true"
href="mailto:ricardo.bayley@gmail.com"
target="_blank">ricardo.bayley@gmail.com</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:ricardo.bayley@gmail.com" target="_blank">ricardo.bayley@gmail.com</a>>>
<div class="im"><br>
<br>
Is there a build for postgis under windows in a
64bit enviroment ?<br>
<br>
thanks<br>
<br>
2012/5/23 Pedro Costa <<a moz-do-not-send="true"
href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a>>>
<div class="im"><br>
<br>
<br>
Hello James,<br>
<br>
Of course. I have win7 64 bits with postgresql
9.1.2 and<br>
postgis 1.5.3. I'm only copy the binaries [1]
to the C path.<br>
Now I will try with postgis 2.0 and return the
results.<br>
<br>
Thanks<br>
<br>
[1] <a moz-do-not-send="true"
href="https://github.com/sanak/pgrouting/downloads"
target="_blank">https://github.com/sanak/pgrouting/downloads</a><br>
<br>
<br>
<br>
Em 23-05-2012 11:18, James David Smith
escreveu:<br>
<br>
Hi Pedro,<br>
<br>
Would be very grateful if you'd provide a
short summary of<br>
what you<br>
did to get it all working - along with
links to the<br>
download packages?<br>
<br>
Thanks<br>
<br>
James<br>
<br>
<br>
<br>
<br>
On 23 May 2012 11:13, Pedro Costa<<a
moz-do-not-send="true"
href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a><br>
</div>
<div class="im"> <mailto:<a
moz-do-not-send="true"
href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a>>>
wrote:<br>
<br>
Perfect....works....<br>
<br>
Thanks<br>
<br>
<br>
<br>
Em 22-05-2012 23:42, Sanak escreveu:<br>
<br>
Hi Pedro,<br>
If you use pgRouting on Windows,
download module from<br>
here(<a moz-do-not-send="true"
href="https://github.com/sanak/pgrouting/downloads"
target="_blank">https://github.com/sanak/pgrouting/downloads</a>
-<br>
pgRouting-git-sanak-mingw_20120310_pg-9.1(x86).zip).<br>
Because above module was based on git
master<br>
branch(<a moz-do-not-send="true"
href="https://github.com/pgRouting/pgrouting"
target="_blank">https://github.com/pgRouting/pgrouting</a>)
after<br>
justjkk's latest<br>
commit(2011/08/08), some drnextgis's
sql fixes had<br>
already applied after<br>
release 1.0.5,<br>
but more drnextgis's<br>
fix(<a moz-do-not-send="true"
href="https://github.com/pgRouting/pgrouting/pull/50"
target="_blank">https://github.com/pgRouting/pgrouting/pull/50</a>)
may<br>
be necessary.<br>
<br>
<br>
Hi Jorge,<br>
<br>
Thanks for your report about PostgreSQL
version<br>
incompatibility.<br>
I will check about this problem.<br>
<br>
<br>
Sorry for my english.<br>
<br>
Regards,<br>
<br>
2012/5/23 Jorge Fuentes<<a
moz-do-not-send="true"
href="mailto:jfuentes@estudiantes.uci.cu"
target="_blank">jfuentes@estudiantes.uci.cu</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:jfuentes@estudiantes.uci.cu"
target="_blank">jfuentes@estudiantes.uci.cu</a>>>
<div class="im"><br>
<br>
Was just easy like double clik and
next next...<br>
but a had to download binaries from
(I don't remember)<br>
.. but I'm sure that you will find
that url in<br>
older post or googlering<br>
it..<br>
and be sure that you had postgreSQL
9.1.3 32 bit<br>
because i try with 9.1.1<br>
and not work because a dll change
from that<br>
version to 9.1.3<br>
remember to execute .slq file from
pgrouting<br>
best regards<br>
<br>
<br>
El 22/05/2012 12:35 pm, Pedro Costa
escribió:<br>
<br>
Em 22-05-2012 16:48, Jorge
Fuentes escreveu:<br>
<br>
Yes I had them install and
running<br>
PosgreSQL 9.1.3, postGIS
2.0 and<br>
pgrouting on win 7-32bits<br>
<br>
<br>
<br>
Hi Jorge,<br>
<br>
It was necessary to any change
in code? Or<br>
were the normal procedures?<br>
<br>
Thanks<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a
moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
10mo. ANIVERSARIO DE LA
CREACION DE LA<br>
UNIVERSIDAD DE LAS CIENCIAS<br>
INFORMATICAS...<br>
CONECTADOS AL FUTURO,
CONECTADOS A LA REVOLUCION<br>
<br>
<a moz-do-not-send="true"
href="http://www.uci.cu" target="_blank">http://www.uci.cu</a><br>
<a moz-do-not-send="true"
href="http://www.facebook.com/universidad.uci"
target="_blank">http://www.facebook.com/universidad.uci</a><br>
<a moz-do-not-send="true"
href="http://www.flickr.com/photos/universidad_uci"
target="_blank">http://www.flickr.com/photos/universidad_uci</a><br>
<br>
<br>
<br>
10mo. ANIVERSARIO DE LA CREACION DE
LA UNIVERSIDAD<br>
DE LAS CIENCIAS<br>
INFORMATICAS...<br>
CONECTADOS AL FUTURO, CONECTADOS A
LA REVOLUCION<br>
<br>
<a moz-do-not-send="true"
href="http://www.uci.cu" target="_blank">http://www.uci.cu</a><br>
<a moz-do-not-send="true"
href="http://www.facebook.com/universidad.uci"
target="_blank">http://www.facebook.com/universidad.uci</a><br>
<a moz-do-not-send="true"
href="http://www.flickr.com/photos/universidad_uci"
target="_blank">http://www.flickr.com/photos/universidad_uci</a><br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
</div>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>>
<div class="im"><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
</div>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>
<mailto:<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a>><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</blockquote>
<div class="im">
<br>
<br>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</div>
</blockquote>
<div class="HOEnZb">
<div class="h5">
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<span
style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic
UG & Georepublic Japan<br>
eMail: <a moz-do-not-send="true"
href="mailto:daniel.kastl@georepublic.de"
style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a moz-do-not-send="true" href="http://georepublic.de/"
style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Pgrouting-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
</blockquote>
<br>
</body>
</html>