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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
