[postgis-users] geometry problem

[Saurabh Data]

Dear users

I want to use postgis as a back end and want to fetch data from mapserver. 
My mapserver demo is working, so I wanted to convert shape files to psql by 
shp2pgsql in postgis

To do so I am told to make a table with geometry column to hold GIS data.

However when i try

a)   CREATE TABLE gtest ( ID int4, NAME varchar(20) );

Above query works; no problem, but with following query:

b)   SELECT AddGeometryColumn('dbname','gtest','geom',-1,'LINESTRING',2);

it gives an error:

ERROR:  Function addgeometrycolumn("unknown", "unknown", "unknown", integer, 
"unknown", integer) does not exist Unable to identify a function that 
satisfies the given argument types
You may need to add explicit typecasts

Can anyone give any ideas as to whats going wrong ?

Many Thanks

Saurabh Data


___________________________________________________________________

Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.

one who seeketh , will findeth and all door shall open - james Allen
___________________________________________________________________

_________________________________________________________________
Tired of 56k? Get a FREE BT Broadband connection 
http://www.msn.co.uk/specials/btbroadband