[postgis-users] AddGeometryColumn does not exist

Obe, Regina robe.dnd at cityofboston.gov
Fri Aug 3 04:32:23 PDT 2007

It sounds like you probably don't have the postgis functions installed
in the database you are working with.  You have one of 2 ways of doing
1) If you haven't done much, you can simply drop your current database,
and create a new database using the template_postgis database template.
2) If you have stuff already run the following file in your current db
that should be located in your
Program Files\PostgreSQL\8.2\share\contrib\lwpostgis.sql  and
The details are pretty much documented here.  
Sorry haven't had a chance to completely update the doc above.
To find out which version you are running, you can run the below command
select postgis_full_version()
If you are running a version than 1.2.1, you might want to upgrade to
the newest using
Hope that helps,


From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Elena Camossi
Sent: Friday, August 03, 2007 5:57 AM
To: PostGIS Users Discussion
Subject: [postgis-users] AddGeometryColumn does not exist

Hi all,

I'm new to PostGis, and I'm making some preliminary test following the
With this command:

   select AddGeometryColumn('', 'gtest', 'geom', -1, 'LINESTRING', 2); 

I got this error:

ERROR: function addgeometrycolumn("unknown", "unknown", "unknown",
integer, "unknown", integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You may
need to add explicit type casts. 
Character: 8

I'm running Postgres 8.2 with PostGIS enabled on Windows XP.

Thank you for any helping.

Best Regards,

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070803/81bdf8ad/attachment.html>

More information about the postgis-users mailing list