Skip site navigation (1) Skip section navigation (2)

Re: Help needed - error while adding geometry

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "ajay kamath" <ajay_k9(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help needed - error while adding geometry
Date: 2006-09-17 12:33:46
Message-ID: bf54be870609170533l13701788rd09daf53ec7ceb17@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Did you install PostGIS (http://postgis.refractions.net/) with PostgreSQL
before tying to call the geometry function?

Thanks,
-- 
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 9/15/06, ajay kamath <ajay_k9(at)yahoo(dot)com> wrote:
>
> Hi,
>        I'm a first time pgsql user. I've installed postgresQL and Postgis
> on a Windows XP Pro. machine. I just want to create a table and add geometry
> to it. So i tried the statements given in the manual.
>
> CREATE TABLE gtest ( ID int4, NAME varchar(20) );     ( works fine)
>
> SELECT AddGeometryColumn('', 'gtest','geom',-1,'LINESTRING',2); (this
> statement gives the blow error)
>
> ERROR:  function addgeometrycolumn("unknown", "unknown", "unknown",
> integer, "unknown", integer) does not exist
> HINT:  No function matches the given name and argument types. You may need
> to add explicit type casts.
>
> Things that i tried:
> (1) one of the help sites asks user to run
>      postgis.sql  and  spatial_reference_sys.sql files......
>  i seacrhed for postgis.sql file ..its not present in the installed
> directories. Also i copied the contents of spatial_reference_sys.sql to the
> sql prompt and tried executing it. It again throws an error.
>
> Please can any one let me know whats the problem....is there some special
> way to install postgis on win XP. What all does one need to configure before
> adding geometry...
>
> Thank you,
> Ajay Kamath.
>
> ------------------------------
> Stay in the know. Pulse on the new Yahoo.com. Check it out.<http://us.rd.yahoo.com/evt=42974/*http://www.yahoo.com/preview>
>
>

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-09-17 13:34:31
Subject: Re: Help needed - error while adding geometry
Previous:From: A. KretschmerDate: 2006-09-17 08:29:48
Subject: Re: Report tool for PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group