Hi Eduardo,<div><br></div><div>I guess this is a problem due to that these functions where removed with the 2.x release of postgis.</div><div><br></div><div>I used the quick-fix - ie loading compatibility wrappers for these deprecated functions. <br>
<br>There are two scripts which you can load, which I found in my installation here;</div><div><br><div><div>/usr/share/postgresql/9.1/contrib/postgis-2.0/legacy.sql</div><div>/usr/share/postgresql/9.1/contrib/postgis-2.0/legacy_minimal.sql</div>
<div><br></div><div>There are two more which you might find relevant;</div><div>/usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis_legacy.sql</div><div>/usr/share/postgresql/9.1/contrib/postgis-2.0/uninstall_legacy.sql</div>
</div><div><br></div><div><br></div><div>I think it was enough to load the minimal set.</div><div><br></div><div><br></div><div>It might not be wise to encourage use of these because it might postpone the real solution, but for us in a hurry - it might be the right way (tm).</div>
<div><br></div><div><br></div><div>best regards Gunnar</div><div><br></div><br><div class="gmail_quote">2012/10/2 Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Eduardo,<div><br></div><div>You're right. There are several places where the ST_ prefix is missing.</div><div>Mario has started some time ago to cleanup the wrapper functions, adding the prefix where it was missing but also getting rid of unused code and renaming and cleaning up the functions: <a href="https://github.com/mbasa/pgrouting/commits/master" target="_blank">https://github.com/mbasa/pgrouting/commits/master</a></div>
<div><br></div><div>This just affects the wrappers as far as I know, so maybe you want to take a look and try it out. </div><div><br></div><div>Daniel</div><div><div><div class="h5"><br><br><div class="gmail_quote">On Tue, Oct 2, 2012 at 2:47 AM, Eduardo Kanegae <span dir="ltr"><<a href="mailto:eduardo.kanegae@gmail.com" target="_blank">eduardo.kanegae@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">hi,<br>
<br>
I'm building pgRouting 1.05 in a CentOS 6.3 box, but I'm noting that<br>
in some .sql files (eg. routing_core_wrappers.sql) is missing 'ST_'<br>
prefix in functions such as:<br>
*length<br>
*srid<br>
*x<br>
*y<br>
<br>
Should I fix these manually or download its current source?<br>
<br>
thanks in advance<br>
<br>
Eduardo Patto Kanegae<br>
<a href="http://www.webmapit.com" target="_blank">http://www.webmapit.com</a> | @webmapit<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <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>
</font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a 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 clear="all"><div><br></div>-- <br><table style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none" border="0">
<tbody style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">
<tr style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">
<td style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:bold;text-decoration:none">Gunnar Rangøy</td>
</tr>
<tr style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">
<td style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">System developer</td>
</tr>
<tr style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">
<td style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">Trådløse Trondheim / Wireless Trondheim</td>
</tr>
<tr style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">
<td style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none"><a style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none" href="http://tradlosetrondheim.no/" target="_blank"><span>tradlosetrondheim.no</span></a></td>
</tr>
<tr style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">
<td style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none"><a style="color:#010101;font-size:12px;font-family:arial,sans-serif;font-weight:normal;text-decoration:none">+47 99 36 06 99</a></td>
</tr>
</tbody>
</table>
<br>
</div>