Re: Help needed - error while adding geometry

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>
>
>