<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>Hi</DIV>
<DIV> </DIV>
<DIV>I’ve set up postgis 2.0 and have run the topology.sql file.</DIV>
<DIV> </DIV>
<DIV>Select postgis_full_version() returns the TOPOLOGY label.</DIV>
<DIV> </DIV>
<DIV>However, unlike the postgis 1.5 setup, when I run </DIV>
<DIV>select topology.CreateTopology('TEST', -1);</DIV>
<DIV>I get the following error which I’m not able to interpret.</DIV>
<DIV> </DIV>
<DIV>NOTICE: CREATE TABLE will create implicit sequence "face_face_id_seq"
for serial column "face.face_id"</DIV>
<DIV>CONTEXT: SQL statement "CREATE TABLE "TEST".face (face_id SERIAL,
CONSTRAINT face_primary_key PRIMARY KEY(face_id));"</DIV>
<DIV>PL/pgSQL function "createtopology" line 26 at EXECUTE statement</DIV>
<DIV>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"face_primary_key" for table "face"</DIV>
<DIV>CONTEXT: SQL statement "CREATE TABLE "TEST".face (face_id SERIAL,
CONSTRAINT face_primary_key PRIMARY KEY(face_id));"</DIV>
<DIV>PL/pgSQL function "createtopology" line 26 at EXECUTE statement</DIV>
<DIV>ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown,
unknown, integer) is not unique</DIV>
<DIV>LINE 1: SELECT
AddGeometryColumn('TEST','face','mbr','-1','POLYGON',...</DIV>
<DIV>
^</DIV>
<DIV>HINT: Could not choose a best candidate function. You might need to
add explicit type casts.</DIV>
<DIV>QUERY: SELECT
AddGeometryColumn('TEST','face','mbr','-1','POLYGON',2)</DIV>
<DIV>CONTEXT: PL/pgSQL function "createtopology" line 33 at EXECUTE
statement</DIV>
<DIV> </DIV>
<DIV>Any help would be appreciated.</DIV>
<DIV> </DIV>
<DIV>Bob</DIV></DIV></DIV></BODY></HTML>