Ti serve la 2.0. Non e' un upgrade facile, ci vuole un dump/reload se vuoi tenere i dati.<br>Se ci vuoi passare il weekend fai sapere che problemi hai avuto a compilarlo.<br>Perche' tu _vuoi_ compilarlo, altrimenti non sarebbe un weekend abbastanza divertente :)<br>
<br>Trattami bene la OffsetCurve che e' un'altra figlia ;)<br><br>--strk;<br><br>Free GIS & Flash consultant/developer<br><a href="http://strk.keybit.net/services.html" target="_blank">http://strk.keybit.net/services.html</a><br>
<br><div class="gmail_quote">2011/9/24 PJ Hooker <span dir="ltr"><<a href="mailto:lima.cityplanner@gmail.com">lima.cityplanner@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Ho capito una cosa... <b><u>non ho la funzione</u></b>, come immaginavo e quindi ho tentato di capire se è colpa di un mio aggiornamento oppure no...<div><br></div><div>insomma sto cercando di aggiungere la funzione, visto che ho verificato in pgadmin che non è nell'elenco, tramite quello che ho capito di questo post:</div>
<div><a href="http://trac.osgeo.org/postgis/ticket/413" target="_blank">http://trac.osgeo.org/postgis/ticket/413</a></div><div>che spiega di una patch<font face="tahoma, sans-serif"> <span style="background-color:rgb(255, 255, 255)"><i>by rafalmag </i></span></font></div>
<div><font face="tahoma, sans-serif"><span style="background-color:rgb(255, 255, 255)"><i><br></i></span></font></div><div><font face="tahoma, sans-serif"><span style="background-color:rgb(255, 255, 255)">di cui non riesco a capire come usare gli </span></font><span style="font-family:Arial, Verdana, 'Bitstream Vera Sans', Helvetica, sans-serif;background-color:rgb(255, 255, 255)">Attachments</span><span style="font-family:tahoma, sans-serif;background-color:rgb(255, 255, 255)">:</span></div>
<div><font face="tahoma, sans-serif"><span style="background-color:rgb(255, 255, 255)"><br></span></font></div><div><span style="font-size:13px;background-color:rgb(255, 255, 255)"><blockquote class="gmail_quote" style="font-family:Verdana, Arial, 'Bitstream Vera Sans', Helvetica, sans-serif;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204, 204, 204);border-left-style:solid;padding-left:1ex">
<a href="http://trac.osgeo.org/postgis/attachment/ticket/413/postgis-1.5.0-RafalMagda.patch" title="View attachment" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank">postgis-1.5.0-RafalMagda.patch</a> <a href="http://trac.osgeo.org/postgis/raw-attachment/ticket/413/postgis-1.5.0-RafalMagda.patch" title="Download" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:initial;border-bottom-style:none;border-bottom-color:initial" target="_blank"><img src="" alt="Download" style="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;border-width:initial;border-color:initial"></a> (<span title="5332 bytes">5.2 KB</span>) - added by <i>rafalmag</i> <a href="http://trac.osgeo.org/postgis/timeline?from=2010-02-09T16%3A00%3A50-0800&precision=second" title="2010-02-09T16:00:50-0800 in Timeline" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank">20 months</a> ago.<br>
Usage: tar xvfz postgis-1.5.0.tar.gz && patch -p0 < postgis-1.5.0-<a style="color:rgb(153, 153, 136)">RafalMagda?</a>.patch<br><a href="http://trac.osgeo.org/postgis/attachment/ticket/413/postgis-offsetCurve-RafalMagda.patch" title="View attachment" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank">postgis-offsetCurve-RafalMagda.patch</a> <a href="http://trac.osgeo.org/postgis/raw-attachment/ticket/413/postgis-offsetCurve-RafalMagda.patch" title="Download" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:initial;border-bottom-style:none;border-bottom-color:initial" target="_blank"><img src="" alt="Download" style="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;border-width:initial;border-color:initial"></a> (<span title="6505 bytes">6.4 KB</span>) - added by <i>rafalmag</i> <a href="http://trac.osgeo.org/postgis/timeline?from=2010-03-09T12%3A12%3A10-0800&precision=second" title="2010-03-09T12:12:10-0800 in Timeline" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank">19 months</a> ago.<br>
usage: svn co <a href="http://svn.osgeo.org/postgis/trunk/" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank"><span style="background-color:initial;padding-left:12px;background-repeat:no-repeat no-repeat"> </span>http://svn.osgeo.org/postgis/trunk/</a> -r 5389 && patch -p0 < postgis-offsetCurve-<a style="color:rgb(153, 153, 136)">RafalMagda?</a>.patch<br>
<a href="http://trac.osgeo.org/postgis/attachment/ticket/413/postgres_geos_OffsetCurve_stacktrace-20110510.txt" title="View attachment" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank">postgres_geos_OffsetCurve_stacktrace-20110510.txt</a> <a href="http://trac.osgeo.org/postgis/raw-attachment/ticket/413/postgres_geos_OffsetCurve_stacktrace-20110510.txt" title="Download" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:initial;border-bottom-style:none;border-bottom-color:initial" target="_blank"><img src="" alt="Download" style="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;border-width:initial;border-color:initial"></a> (<span title="22003 bytes">21.5 KB</span>) - added by <i>sholl</i> <a href="http://trac.osgeo.org/postgis/timeline?from=2011-05-10T03%3A30%3A42-0700&precision=second" title="2011-05-10T03:30:42-0700 in Timeline" style="text-decoration:none;color:rgb(187, 0, 0);border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(187, 187, 187)" target="_blank">5 months</a>ago.<br>
Stacktrace for comment28 of a segfaulting postgres-backend.</blockquote><dd style="font-family:Verdana, Arial, 'Bitstream Vera Sans', Helvetica, sans-serif;font-style:italic;margin-left:0px;padding-left:0px">
<br></dd><dd style="margin-left:0px;padding-left:0px"><font face="tahoma, sans-serif">ma come si fa per tabelle, viste, spatial_rel, ecc... sono in cerca di fare l'add function così ho trovato:</font></dd>
</span></div><div><a href="http://trac.osgeo.org/postgis/attachment/ticket/413/postgis-offsetCurve-RafalMagda.patch" target="_blank">http://trac.osgeo.org/postgis/attachment/ticket/413/postgis-offsetCurve-RafalMagda.patch</a></div>
<div>che in fondo alla pagina incomincia ad indicarmi del testo per fare add function</div>
<div><br></div><div><blockquote class="gmail_quote" style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204, 204, 204);border-left-style:solid;padding-left:1ex">
-- Availability: 2.0.0 - requires GEOS-3.2 or higher <br>CREATE OR REPLACE FUNCTION _ST_OffsetCurve(geometry,float8,cstring,cstring) <br>RETURNS geometry <br>AS '$libdir/postgis-1.5','offsetcurve' <br>LANGUAGE 'C' IMMUTABLE STRICT <br>
COST 100; </blockquote><blockquote class="gmail_quote" style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204, 204, 204);border-left-style:solid;padding-left:1ex">
...</blockquote><div> </div></div><div>e a questo punto, restituendomi un errore:</div><blockquote class="gmail_quote" style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204, 204, 204);border-left-style:solid;padding-left:1ex">
could not find function "offsetcurve" in file "/usr/lib/postgresql/8.4/lib/<a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a></blockquote><div> sto scaricando il DVD live di OSGeo, per vedere se li è tutto a posto... e posso continuare col mio grafo, ma in questo momento ho problemi a scaricarlo, e ne ho già avuti anche nei giorni precedenti...</div>
<div><br></div><div>ho fatto diversi tentativi per installare postgis2.0.0, ma non sono riuscito. </div><div><br></div><div>infatti ho provato a fare la stessa query cambiando postgis-1.5 con postgis2.0 e mi da un errore diverso:</div>
<div><br></div><div>ERROR: could not load library "/usr/lib/postgresql/8.4/lib/<a href="http://postgis-2.0.so" target="_blank">postgis-2.0.so</a>": /usr/lib/postgresql/8.4/lib/<a href="http://postgis-2.0.so" target="_blank">postgis-2.0.so</a>: undefined symbol: GEOSRelatePatternMatch</div>
</blockquote></div>