<div>Hello,</div><div><br></div><div>I have a lot of problems with ch.2.7.1 at</div><div><br></div><a href="http://www.postgis.org/docs/ch02.html#upgrading">http://www.postgis.org/docs/ch02.html#upgrading</a><div><br></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:'Lucida Grande',Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><div>------</div></span><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">1) postgis_upgrade_13_to_15.sql NOT EXIST</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br></span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> The links not have any file.</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br></span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> locate </span><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">postgis_upgrade_13_to_15.sql</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> not exist</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br>
</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> for downlaod </span><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">ONLY with google, searching with "filetype:sql </span><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">postgis_upgrade_13_to_15.sql"</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> we have only one download,</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br>
</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> </span><a href="http://mapserver.sara.nl/scratch/pgsql843/share/contrib/postgis-1.5/postgis_upgrade_13_to_15.sql">http://mapserver.sara.nl/scratch/pgsql843/share/contrib/postgis-1.5/postgis_upgrade_13_to_15.sql</a></div>
<div><br></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> PS: </span><a href="http://svn.osgeo.org/postgis/trunk/postgis/">http://svn.osgeo.org/postgis/trunk/postgis/</a></div>
<div> not have the file.</div><div><br></div><div>2) problem with the ch.2.7.1 recomendation,</div><div> <span class="Apple-style-span" style="color:rgb(46,46,46);font-family:'Courier New',Courier,Monaco,monospace;font-size:11px;line-height:16px;white-space:pre;background-color:rgb(248,248,249)">$ psql -f postgis_upgrade_13_to_15.sql -d your_spatial_database</span></div>
<div><font class="Apple-style-span" face="monospace" size="3"><span class="Apple-style-span" style="white-space:pre-wrap"> psql: FATAL: role "root" not exist</span></font></div><div><font class="Apple-style-span" face="monospace" size="3"><span class="Apple-style-span" style="white-space:pre-wrap"><br>
</span></font></div><div><font class="Apple-style-span" face="monospace" size="3"><span class="Apple-style-span" style="white-space:pre-wrap"><br></span></font></div><div><font class="Apple-style-span" face="monospace" size="3"><span class="Apple-style-span" style="white-space:pre-wrap">3) try to create only a important function, </span></font></div>
<div><span class="Apple-style-span" style="font-family:monospace;white-space:pre-wrap;font-size:medium"><br></span></div><div><span class="Apple-style-span" style="font-family:monospace;white-space:pre-wrap;font-size:medium">CREATE OR REPLACE FUNCTION _ST_AsGeoJson(int4, geometry, int4, int4)</span></div>
<span class="Apple-style-span" style="font-family:'Times New Roman';font-size:medium"><pre style="word-wrap:break-word;white-space:pre-wrap"> RETURNS TEXT
AS '$libdir/postgis-1.5','LWGEOM_asGeoJson'
LANGUAGE 'C' IMMUTABLE STRICT;
</pre><div>-- file "$libdir/postgis-1.5" NOT EXIST</div><div><br></div></span><font class="Apple-style-span" face="monospace" size="3"><span class="Apple-style-span" style="white-space:pre-wrap"><br></span></font><span class="Apple-style-span" style="font-family:'Times New Roman';font-size:medium"><div>
4) ... </div><div><br></div><div><br></div></span><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">----</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">CLUES,</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br></span></div><div><span class="Apple-style-span" style="background-color:rgb(255,255,255)"><font class="Apple-style-span" color="#2e2e2e" face="monospace">select postgis_lib_version();</font></span></div>
<div><span class="Apple-style-span" style="background-color:rgb(255,255,255)"><font class="Apple-style-span" color="#2e2e2e" face="monospace"><div> 1.3.3</div><div><br></div></font></span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br>
</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)">My installation have things like</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> /usr/share/doc/postgresql-8.3-postgis</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> and</span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"> /usr/share/java/postgis.jar</span></div>
<div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br></span></div><div><span class="Apple-style-span" style="color:rgb(46,46,46);font-family:monospace;font-size:13px;background-color:rgb(255,255,255)"><br>
</span></div>