Hello Marcus, does the function "AddGeometryColumn" exist? Have a look at "/Schemata/public/Funktionen/". Stefanie
_____ Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Marcus Gesendet: Dienstag, 18. September 2007 16:47 An: [email protected] Betreff: [jump-users] Error "select AddGeometryColumn" 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
