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