<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] function addgeometrycolumn does not exist</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Off hand, I'd guess that you are not giving the right parameters.<BR>
<BR>
> ------<BR>
> However when I list my functions using \df this is a snippet of what i see:<BR>
> public | addgeometrycolumn | text | character varying, character varying,<BR>
> character varying, character varying, integer, character varying, integer<BR>
<BR>
4 varchar params, an integer, another varchar and another int<BR>
<BR>
OR<BR>
<BR>
> public | addgeometrycolumn | text | character varying, character varying,<BR>
> character varying, integer, character varying, integer<BR>
<BR>
3 varchar params, an int, a var char and another int.<BR>
<BR>
OR<BR>
<BR>
> public | addgeometrycolumn | text | character varying, character varying,<BR>
> integer, character varying, integer<BR>
2 varchar params, an int, a var char and an int<BR>
<BR>
> --------------<BR>
<BR>
You had:<BR>
test=# select AddGeometryColumn('public','navaids','geom',32611,2);<BR>
<BR>
so 3 varchars, and 2 ints.<BR>
<BR>
PostgreSQL is complaining correctly that there is no match.<BR>
<BR>
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 ?<BR>
<BR>
HTH,<BR>
<BR>
Greg Williamson<BR>
Senior DBA<BR>
GlobeXplorer LLC, a DigitalGlobe company<BR>
</FONT>
</P>
</BODY>
</HTML>