Thread: Help needed - error while adding geometry
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.
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.
Did you install PostGIS (http://postgis.refractions.net/) with PostgreSQL before tying to call the geometry function?
Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 9/15/06, ajay kamath <ajay_k9@yahoo.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 runpostgis.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.
On Fri, Sep 15, 2006 at 11:55:35AM -0700, ajay kamath wrote:
> 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
It looks like you don't have PostGIS loaded. This command runs
successfully in a PostGIS-enabled database.
> 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.
The file names are lwpostgis.sql and spatial_ref_sys.sql and they
must be loaded in that order because the former creates the table
that the latter populates. Also, you'll need install PL/pgSQL
(e.g., with "createlang plpgsql dbname") before loading lwpostgis.sql.
For more information see the Installation chapter of the PostGIS
documentation.
http://postgis.refractions.net/docs/ch02.html
If you continue to have trouble with PostGIS then you might get
more help on the postgis-users mailing list.
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Michael Fuhr