pg_proc returns 6 rows.
Three rows identical to yours and three rows with column
proargnames returning a blank or (null) value.
postgresql version returns PostreSQL 9.1.3.
Bob
-----Original Message-----
From: Sandro Santilli
Sent: Tuesday, April 24, 2012 10:28 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Topology
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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
