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

[Thomas Schweikle]

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

The database is accessed using tcp/ip.

2013/12/19 Rémi Cura <remi.cura at gmail.com>:
> 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
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users



-- 
Thomas