[postgis-users] ERROR:function totopogeom() does not exist

Denis Rouzaud denis.rouzaud at gmail.com
Wed Feb 29 02:50:12 PST 2012


I have the same output when postgis_full_version()

Running the minor upgrade files did not solve this.

I have a more general question. What is the procedure when you pull the 
new source of postigs.
Until now, I deleted the db and run again the SQL files in a fresh new db.
Is there a shorter way after re-compiling?



On 02/29/2012 11:13 AM, Sandro Santilli wrote:
> On Wed, Feb 29, 2012 at 12:50:43AM -0800, Salvatore Larosa-1 wrote:
>> Hi Sandro,
>> this is what I get:
>>
>> SELECT postgis_full_version();
>>
>> "POSTGIS="2.0.0alpha7SVN" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23
>> September 2009" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8"
>> USE_STATS (core procs from "2.0.0alpha7SVN" need upgrade) (topology procs
>> from "2.0.0alpha7SVN" need upgrade) (raster procs from "2.0.0alpha7SVN" need
>> upgrade)"
> Alright, as the messages say: "topology procs from '2.0.0alpha7SVN' need upgrade"
> It means you have to load topology/topology_upgrade_20_minor.sql
>
> Note that "core procs... need upgrade" also means you need to load
> postgis_upgrade_20_minor.sql.
>
> Similarly,  "raster procs... need upgrade" means you need to load
> rtpostgis_upgrade_20_minor.sql.
>
> Please let me know if doing so removes the "need upgrade" messsages,
> as they seem to be confusing.
>
> --strk;
>
>    ,------o-.
>    |   __/  |    Delivering high quality PostGIS 2.0 !
>    |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
>    `-o------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list