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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
