[postgis-users] AddGeometryColumn does not exist

[Obe, Regina]

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
this.
 
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
\share\contrib\spatial_ref_sys.sql
 
The details are pretty much documented here.  
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01
 
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
 
http://postgis.refractions.net/download/windows/
 
Hope that helps,
Regina
 
 
 
 
 

________________________________

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
manual.
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,
-Elena 






-----------------------------------------
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>