database - 错误 : function addgeometrycolumn is not unique

Question

我正在尝试使用以下功能；

SELECT Assign_vertex_id('ways', 0.00001, 'the_geom', 'gid')

但由于某种原因，它给了我以下错误；

NOTICE:  CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id"
CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id serial)"
PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement
ERROR:  function addgeometrycolumn(unknown, unknown, integer, unknown, integer) is not unique
LINE 1: SELECT addGeometryColumn('vertices_tmp', 'the_geom', 4326, '...
               ^
HINT:  Could not choose a best candidate function. You might need to add explicit type casts.
QUERY:  SELECT addGeometryColumn('vertices_tmp', 'the_geom', 4326, 'POINT', 2)
CONTEXT:  PL/pgSQL function "assign_vertex_id" line 24 at EXECUTE statement

********** Error **********

ERROR: function addgeometrycolumn(unknown, unknown, integer, unknown, integer) is not unique
SQL state: 42725
Hint: Could not choose a best candidate function. You might need to add explicit type casts.
Context: PL/pgSQL function "assign_vertex_id" line 24 at EXECUTE statement

现在，根据我的发现，它必须带有旧的 PostGIS 签名。当我运行以下命令时感染；

select proname, proargnames from pg_proc where proname = 'addgeometrycolumn'; 

结果是这样的；

pg_proc returns 6 rows.

Three rows with column proargnames  returning a blank or (null) value

有人可以帮助我吗？这与旧的 postgis 签名有关吗？如果是这样，我该如何解决？

谢谢

Answer 1

我也遇到过这个问题，我觉得楼主可能解决的不对。首先，AddGeometryColumn 确实重载了。三个原型(prototype)是:

    AddGeometryColumn(table_name, column_name, srid, type, dimension,
use_typmod=true)
    AddGeometryColumn(schema_name, table_name, column_name, srid, type, dimension, use_typmod=true)
    AddGeometryColumn(catalog_name, schema_name, table_name, column_name, srid, type, dimension, use_typmod=true)

在我的例子中，更改以下查询:

SELECT AddGeometryColumn('public', 'facilities', 'walk_area', 4326, 'POLYGON', 2);

(使用第二种形式)对此:

SELECT AddGeometryColumn('public', 'facilities', 'walk_area', 4326, 'POLYGON', 2, true);

解决了问题。