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

[Sandro Santilli]

On Wed, Feb 29, 2012 at 11:50:12AM +0100, Denis Rouzaud wrote:
> I have the same output when postgis_full_version()
> 
> Running the minor upgrade files did not solve this.

Where did you get the sources from ?

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

Yes, loading postgis_upgrade_20_minor.sql and, if you enabled raster,
rtpostgis_upgrade_20_minor.sql and, if you enabled topology,
topology_upgrade_20_minor.sql.

Theoretically (when it works) the postgis_full_version() should tell
you which you need to load. Feel like filing a ticket for that issue
as well (ie postgis_full_version() complain about need to upgrade
on a new install).

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'