[postgis-users] AddGeometryColumn fails in PostGIS 2.0

[Sandro Santilli]

On Thu, Jul 19, 2012 at 06:01:33PM +0100, Paul Michell wrote:
> Hello all,
> 
> We have a PostGIS 2.0 system that was upgraded from 1.5 and now
> AddGeometryColumn fails when we call it from the SQL window of PGAdmin
> with the following error:
> 
> ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, 
> unknown, integer) is not unique
> LINE 3: SELECT AddGeometryColumn('','TestTable','geom','27700','MULT...
>                ^

I suspect you didn't upgrade properly. Did you follow the "hard upgrade"
instructions in the PostGIS manual ?

Try running postgis_upgrade_minor_20.sql and see if it fixes your issue.

--strk;

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