[postgis-users] AddGeometryColumn does not exist

[Elena Camossi]

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 <robe.dnd at cityofboston.gov> 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:* 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. *
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070806/13484424/attachment.html>