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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-09-17 13:34:31 | Re: Help needed - error while adding geometry |
Previous Message | A. Kretschmer | 2006-09-17 08:29:48 | Re: Report tool for PostgreSQL |