Did you install PostGIS (http://postgis.refractions.net/) with PostgreSQL
before tying to call the geometry function?
On 9/15/06, ajay kamath <ajay_k9(at)yahoo(dot)com> wrote:
> 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 Fuhr||Date: 2006-09-17 13:34:31|
|Subject: Re: Help needed - error while adding geometry|
|Previous:||From: A. Kretschmer||Date: 2006-09-17 08:29:48|
|Subject: Re: Report tool for PostgreSQL|