Dear Regina, I tried the second solution and now it works perfectly! I found your guide really useful.
Thank you very much for your help, -Elena On 8/3/07, Obe, Regina <[EMAIL PROTECTED]> wrote: > > 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 > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
