[postgis-users] Topology

[Sandro Santilli]

On Tue, Apr 24, 2012 at 10:14:52AM -0700, Bob Pawley wrote:

> I’ve set up postgis 2.0 and have run the topology.sql file.
> Select postgis_full_version() returns the TOPOLOGY label.
> 
> However, unlike the postgis 1.5 setup, when I run 
> select topology.CreateTopology('TEST', -1);
...
> ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) is not unique
> LINE 1: SELECT AddGeometryColumn('TEST','face','mbr','-1','POLYGON',...

Uhm, maybe you have old PostGIS 1.5 signatures around ?

This is what I have here:

=> select proname, proargnames from pg_proc where proname = 'addgeometrycolumn';
      proname      |                                        proargnames
-------------------+-------------------------------------------------------------------------------------------
 addgeometrycolumn | {catalog_name,schema_name,table_name,column_name,new_srid_in,new_type,new_dim,use_typmod}
 addgeometrycolumn | {schema_name,table_name,column_name,new_srid,new_type,new_dim,use_typmod}
 addgeometrycolumn | {table_name,column_name,new_srid,new_type,new_dim,use_typmod}
(3 rows)

There might indeed be an ambiguity due to the use_typmod default argument,
but I can't reproduce here so please first of all check your pg_proc.

Then report your postgresql version.

--strk;

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