[postgis-users] function addgeometrycolumn does not exist

[Chris Hermansen]

Looking at the docs
http://postgis.refractions.net/docs/ch06.html#id3029134 and your note, I
infer that your:

schema = public
table = navaids
geometry-column = geom
srid = 32611
dimension = 2

but what is your geometry type?  that is supposed to be your second-last
argument.

cummings wrote:
> Hi There
>
> I'm pulling my hair out with a problem, and I hope someone can help me...
> I'm on a ubuntu gutsy server, with postgres 8.2 and postgis installed
> through apt-get.
>
> Now when working with the database, it now tells me that the functions do
> not exist:
>
> test=# select AddGeometryColumn('public','navaids','geom',32611,2);
> ERROR: function addgeometrycolumn("unknown", "unknown", "unknown", integer,
> integer) does not exist
> LINE 1: select AddGeometryColumn('public','navaids','geom',32611,2);
> ^
> HINT: No function matches the given name and argument types. You may need to
> add explicit type casts.
>
> ------
> 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
> public | addgeometrycolumn | text | character varying, character varying,
> character varying, integer, character varying, integer
> public | addgeometrycolumn | text | character varying, character varying,
> integer, character varying, integer
> --------------
>
> So the function should be in there, when I try other postgis functions like
> pointfromtext, it works..
>
> lwpostgis.sql and spatial_ref_sys.sql have been imported, and I'm also tried
> creating a database using template_postgis.
>
> Version info:
> test=# select postgis_full_version();
>                                postgis_full_version
> ----------------------------------------------------------------------------------
>  POSTGIS="1.2.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006"
> USE_STATS
> (1 row)
>
> I hope someone can help me with this.
>
>   


-- 
Regards,

Chris Hermansen · mailto:clh at timberline.ca
tel:+1.604.714.2878 · fax:+1.604.733.0631
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5

C'est ma façon de parler.