[postgis-users] AddGeometryColumn => column does not exist

[Michael Fuhr]

On Fri, Nov 18, 2005 at 08:00:27PM -0700, John Taber wrote:
> Hmmm, Still no go.  But I think that is on the right track.
> Latest error msg:
> 
> ERROR: function addgeometrycolumn(character varying, ....) does not 
> exist HINT: No function matches the given name and argument types.  You 
> may need to add explicit type casts.

What does "\df addgeometrycolumn" show in psql?  You said you
installed PostGIS, but did you load it into the new database?  Your
original message shows a createdb but nothing else, so unless PostGIS
is in your template database then you need to load it into the new
database.  See the documentation for instructions:

http://postgis.refractions.net/docs/ch02.html

-- 
Michael Fuhr