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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Did you install PostGIS ( with PostgreSQL
before tying to call the geometry function?

Shoaib Mir
EnterpriseDB (

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 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 Check it out.<*>

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-2017 The PostgreSQL Global Development Group