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

[Sandro Santilli]

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------'