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 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 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 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 href="http://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html" target="_blank">http://postgis.refractions.<u></u>net/pipermail/postgis-users/<u></u>2012-April/033745.html</a><br>
<a href="http://www.postgis.org/download/windows/#postgis-installers" target="_blank">http://www.postgis.org/<u></u>download/windows/#postgis-<u></u>installers</a><br>
and began to make more crossplatform build system.(I guess this means<br>
move to cmake/msvc in windows).<br>
<a href="http://blog.opengeo.org/2012/05/17/postgis-code-sprint-recap/" target="_blank">http://blog.opengeo.org/2012/<u></u>05/17/postgis-code-sprint-<u></u>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 href="https://github.com/sanak/pgrouting" target="_blank">https://github.com/sanak/<u></u>pgrouting</a>)<br>
mingw/msvc branch.<br>
Regards,<br>
2012/6/4 Ricardo Bayley <<a href="mailto:ricardo.bayley@gmail.com" target="_blank">ricardo.bayley@gmail.com</a><br></div>
<mailto:<a href="mailto:ricardo.bayley@gmail.com" target="_blank">ricardo.bayley@gmail.<u></u>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 href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a><br></div>
<mailto:<a href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a><u></u>>><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 href="https://github.com/sanak/pgrouting/downloads" target="_blank">https://github.com/sanak/<u></u>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 href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a><br></div><div class="im">
<mailto:<a href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a><u></u>>> 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 href="https://github.com/sanak/pgrouting/downloads" target="_blank">https://github.com/sanak/<u></u>pgrouting/downloads</a> -<br>
pgRouting-git-sanak-mingw_<u></u>20120310_pg-9.1(x86).zip).<br>
Because above module was based on git master<br>
branch(<a href="https://github.com/pgRouting/pgrouting" target="_blank">https://github.com/<u></u>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 href="https://github.com/pgRouting/pgrouting/pull/50" target="_blank">https://github.com/<u></u>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 href="mailto:jfuentes@estudiantes.uci.cu" target="_blank">jfuentes@estudiantes.<u></u>uci.cu</a><br></div>
<mailto:<a href="mailto:jfuentes@estudiantes.uci.cu" target="_blank">jfuentes@estudiantes.<u></u>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>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>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 href="http://www.uci.cu" target="_blank">http://www.uci.cu</a><br>
<a href="http://www.facebook.com/universidad.uci" target="_blank">http://www.facebook.com/<u></u>universidad.uci</a><br>
<a href="http://www.flickr.com/photos/universidad_uci" target="_blank">http://www.flickr.com/photos/<u></u>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 href="http://www.uci.cu" target="_blank">http://www.uci.cu</a><br>
<a href="http://www.facebook.com/universidad.uci" target="_blank">http://www.facebook.com/<u></u>universidad.uci</a><br>
<a href="http://www.flickr.com/photos/universidad_uci" target="_blank">http://www.flickr.com/photos/<u></u>universidad_uci</a><br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
<br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br></div>
<mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
</div><a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a> <mailto:<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.<u></u>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
</blockquote><div class="im">
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>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 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>
</div>