[postgis-users] Topology

[Bob Pawley]

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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users