[postgis-users] Errors while creating database from org.geotools.data.postgis

[Rémi Cura]

What is the information connection your software is using to connect to DB
where you want to execute commands.
Probably wrong role.

Cheers,
Rémi-C


2013/12/19 Thomas Schweikle <tschweikle at gmail.com>

> Hi!
>
> I am seeing various errors while a routine tries to create databases.
> I'm having trouble interpreting these errors:
> --- SNIP
> 18:35:34,895 ERROR Dez 18, 2013 6:35:34 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: CREATE TABLE "public"."npp" ("npp_fid" serial PRIMARY
> KEY, "the_geom" GEOMETRY, "Name" VARCHAR(256), "Longitude" DOUBLE
> PRECISION, "Latitude" DOUBLE PRECISION);
> --- SNAP
> To me it looks like they are trying to create a database, but without
> rights to create the database? Any way to find the user whom is to
> create this database?
>
> --- SNIP
> 18:35:35,069 ERROR Dez 18, 2013 6:35:35 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: DELETE FROM GEOMETRY_COLUMNS WHERE f_table_catalog='' AND
> f_table_schema = 'public'AND f_table_name = 'npp';
> --- SNAP
> They want to delete datasets, but fail. Access rights wrong? Wrong
> user? Which user was intended? Which user was used? Or -- is this
> database not enabled to use postgis??
>
> --- SNIP
> 18:35:35,080 ERROR Dez 18, 2013 6:35:35 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: INSERT INTO GEOMETRY_COLUMNS VALUES
> ('','public','npp','the_geom',2,4326,'POINT');
>
> 18:35:35,089 ERROR Dez 18, 2013 6:35:35 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: ALTER TABLE "public"."npp" ADD CONSTRAINT
> enforce_srid_the_geom CHECK (SRID(the_geom) = 4326);
>
> 18:35:35,097 ERROR Dez 18, 2013 6:35:35 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: ALTER TABLE "public"."npp" ADD CONSTRAINT
> enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
>
> 18:35:35,123 ERROR Dez 18, 2013 6:35:35 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: ALTER TABLE "public"."npp" ADD CONSTRAINT
> enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text
> OR the_geom IS NULL);
>
> 18:35:35,133 ERROR Dez 18, 2013 6:35:35 PM
> org.geotools.data.postgis.PostgisDataStore createSchema
> Information: CREATE INDEX "spatial_npp_the_geom" ON "public"."npp"
> USING GIST ("the_geom");
> --- SNAP
>
> Maybe someone 's got an idea how to find out what was going on here!
>
> --
> Thomas
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131219/c43ab188/attachment.html>