Hi,
I understand that you tried to create your table from pgAdminIII, so
error is not direcly related to OpenJUMP.
Are you sure postgis is installed (for ex. have you a geometry type
under Schémas/public/Types/) ?
I have postgreSQL 8.2 / pgadmin / postgis installed and if I execute
your request, it works.
I don't know much about postgre/postgis, but if you're a german speaker,
Uwe wrote a nice tutorial (http://de.giswiki.net/wiki/PostGIS_Tutorial).
You should also try to post to the postgis list.
Michael
Marcus a écrit :
Hello Jump-Users,
I try to create a geodatabase with following software (OpenJump 1.2 D,
PostGIS - PostgreSQL Version 1.6.3).
It was no problem to create my tables in pgAdminIIIQuery like
“create table baeume (bID INT NOT NULL, kurz_bez varchar(30) NOT NULL,
PRIMARY KEY ( bID );”
but if try to create the geometry column like
“select AddGeometryColumn ( 'baeume', 'geom', -1, 'POINT', 2);”
then I get follwing message.
ERROR: function addgeometrycolumn("unknown", "unknown", integer,
"unknown", integer) does not exist SQL Status:42883
Hinweis:No function matches the given name and argument types. You may
need to add explicit type casts.
Zeichen:33
It seems that the table or column „baeume” does not exist but if I do
“select * from baeume;“
then the table appear.
What is the problem? Could somebody help me please?
Regards
Marcus
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release Date:
16.09.2007 18:32
------------------------------------------------------------------------
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
