Marcus wrote: Hello,
> 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
When you create the database in which you want to create the new table
with the geometry column, you'll have to use the postgis_template (or
similar name) as template.
Best regards, Andreas
--
l a t / l o n GmbH
Aennchenstrasse 19 53177 Bonn, Germany
phone ++49 +228 18496-11 fax ++49 +228 1849629
http://www.lat-lon.de http://www.deegree.org
signature.asc
Description: Digital signature
_______________________________________________ jump-users mailing list [email protected] http://lists.refractions.net/mailman/listinfo/jump-users
