[postgis-users] function addgeometrycolumn does not exist

[Gregory Williamson]

Off hand, I'd guess that you are not giving the right parameters.

> ------
> However when I list my functions using \df this is a snippet of what i see:
> public | addgeometrycolumn | text | character varying, character varying,
> character varying, character varying, integer, character varying, integer

    4 varchar params, an integer, another varchar and another int

OR

> public | addgeometrycolumn | text | character varying, character varying,
> character varying, integer, character varying, integer

   3 varchar params, an int, a var char and another int.

OR

> public | addgeometrycolumn | text | character varying, character varying,
> integer, character varying, integer
    2 varchar params, an int, a var char and an int

> --------------

You had:
test=# select AddGeometryColumn('public','navaids','geom',32611,2);

    so 3 varchars, and 2 ints.

PostgreSQL is complaining correctly that there is no match.

I don't have a manual at hand but it seems to me are missing a parameter ... try rereading the documents and see what the columns are defined as. I think maybe you are missing a specification of what sort of geometry is to be used (POINT, POLYGON, GEOMETRY, etc.). Perhaps the missing text from the second variant, between the two int parameters ?

HTH,

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080101/794bf972/attachment.html>