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------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users