[postgis-users] upgrade problem (ubuntu 12.04)

[Sandro Santilli]

On Mon, Oct 28, 2013 at 10:15:03AM +0000, António M. Rodrigues wrote:
> Hi,
> 
> I recently upgraded to postgis 2.1. When loading any table from a gis app
> (qgis), the layer appears in the layers panel, I can open the attributes
> table, but the geometry doesn't show up in the canvas.
> 
> In postgresql, trying to vaccumm analyse any table with geometry, the
> following error is issued:
> 
> ---
> could not find function "geometry_analyze_2d" in file
> "/usr/lib/postgresql/9.1/lib/postgis-2.1.so"
> ---
> 
> Postgis was compiled from source and I did a "soft upgrade" as described in
> "http://postgis.net/docs/postgis_installation.html#soft_upgrade".

Did you use the "with extension" or "without extension" section ?

If you did this:

 psql -f postgis_upgrade_20_minor.sql -d your_spatial_database

Then you were fooled by a bug in the documentation:
http://trac.osgeo.org/postgis/ticket/2517

--strk;