<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<span id="result_box" class="" lang="en"><span class="hps">I'm
trying</span> <span class="hps">now with</span> <span
class="hps">postgis</span> <span class="hps">2.0 and</span> <span
class="hps">successfully</span> <span class="hps"> create</span>
<span class="hps">the template</span><span> for</span> <span
class="hps">routing</span> <span class="hps">based on </span><span
class="hps">postgis</span> <span class="hps">template 2.0</span><span>.</span><br>
<br>
<span class="hps">The problem</span> <span class="hps">I found is</span>
<span class="hps">the function assign_vertex that</span> <span
class="hps">gives</span> <span class="hps">the following error</span><span>:</span></span><br>
<br>
<br>
NOTICE: CREATE TABLE will create implicit sequence
"vertices_tmp_id_seq" for serial column "vertices_tmp.id"<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
geometry registered in the GEOMETRY_COLUMNS table? Is there an
uppercase/lowercase missmatch?<br>
<br>
<br>
In postgis 2.0 we do not have table geometry_columns, anybody know
how to solve this problem?<br>
<br>
Thanks<br>
<br>
Pedro<br>
<br>
<br>
<br>
Em 05-06-2012 03:40, Sanak escreveu:
<blockquote
cite="mid:CALeT7PCJhnTGtdw7fsb9MD3F56w7NKKNgHpy--igVBtnrJMwDQ@mail.gmail.com"
type="cite">
<div>Hi Ricardo,</div>
<div> </div>
<div>I don't know all of the windows binaries, but I have
not build 64bit one yet.</div>
<div> </div>
<div>PostGIS team have already supported windows mingw-64bit
build,</div>
<div><a moz-do-not-send="true"
href="http://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html">http://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html</a></div>
<div><a moz-do-not-send="true"
href="http://www.postgis.org/download/windows/#postgis-installers">http://www.postgis.org/download/windows/#postgis-installers</a></div>
<div>and began to make more crossplatform build system.(I guess
this means move to cmake/msvc in windows).</div>
<div><a moz-do-not-send="true"
href="http://blog.opengeo.org/2012/05/17/postgis-code-sprint-recap/">http://blog.opengeo.org/2012/05/17/postgis-code-sprint-recap/</a></div>
<div> </div>
<div>So, if the demand for windows 64bit binary seems to be large,</div>
<div>I will begin to investigate about it on my git(<a
moz-do-not-send="true"
href="https://github.com/sanak/pgrouting">https://github.com/sanak/pgrouting</a>)</div>
<div>mingw/msvc branch.</div>
<div> </div>
<div>Regards,<br>
</div>
<div class="gmail_quote">
2012/6/4 Ricardo Bayley <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:ricardo.bayley@gmail.com" target="_blank">ricardo.bayley@gmail.com</a>></span><br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
<font>Is there a build for postgis under windows in a 64bit
enviroment ?</font>
<div><font><br>
</font></div>
<div><font>thanks<br>
</font>
<div>
<div class="h5"><br>
<div class="gmail_quote">2012/5/23 Pedro Costa <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:pedrocostaarma@sapo.pt"
target="_blank">pedrocostaarma@sapo.pt</a>></span><br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote"><br>
Hello James,<br>
<br>
Of course. I have win7 64 bits with postgresql 9.1.2
and 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:
<div>
<div><br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
Hi Pedro,<br>
<br>
Would be very grateful if you'd provide a
short summary of what you<br>
did to get it all working - along with links
to the 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>>
wrote:<br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
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 justjkk's latest<br>
commit(2011/08/08), some drnextgis's sql
fixes had already applied after<br>
release 1.0.5,<br>
but more drnextgis's 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 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>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
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 older post or googlering<br>
it..<br>
and be sure that you had postgreSQL 9.1.3
32 bit because i try with 9.1.1<br>
and not work because a dll change from
that 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>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
Em 22-05-2012 16:48, Jorge Fuentes
escreveu:<br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
Yes I had them install and running
PosgreSQL 9.1.3, postGIS 2.0 and<br>
pgrouting on win 7-32bits<br>
</blockquote>
<br>
<br>
Hi Jorge,<br>
<br>
It was necessary to any change in code?
Or 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>
<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
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>
</blockquote>
<br>
<br>
10mo. ANIVERSARIO DE LA CREACION DE LA
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>
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>
</blockquote>
<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>
<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>
<br>
</blockquote>
_______________________________________________<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>
</blockquote>
<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>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org">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>
<br>
</blockquote>
</div>
<br>
<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>