[postgis-users] Topology

Bob Pawley rjpawley at shaw.ca
Tue Apr 24 10:56:44 PDT 2012

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.


-----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 = 
      proname      |                                        proargnames
addgeometrycolumn | 
addgeometrycolumn | 
addgeometrycolumn | 
(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.


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

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list