[postgis-users] AddGeometryColumn fails in PostGIS 2.0

[Paul Michell]

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...
               ^

This sample query causes this error:

CREATE TABLE "TestTable" (gid serial, "name" varchar(50));
ALTER TABLE "TestTable" ADD PRIMARY KEY (gid);
SELECT AddGeometryColumn('','TestTable','geom','27700','MULTIPOLYGON',2);


Thanks,

Paul
-- 
Paul Michell MSc BA MBCS
Michell Computing