Krzysztof Pado created GEOT-4143:
------------------------------------
Summary: JDBCDataStore fails to create association tables on
postgresql
Key: GEOT-4143
URL: https://jira.codehaus.org/browse/GEOT-4143
Project: GeoTools
Issue Type: Bug
Components: jdbc
Affects Versions: 2.7.4
Environment: Linux 3.3.2, Java 1.7, PostgreSQL 9.1.3, PostGIS 1.5.3
Reporter: Krzysztof Pado
When JDBCDataStore.associations is set to true method
ensureAssociationTablesExist tries to create association tables. One of tables
is named "geometry" as defined in final field JDBCDataStore.GEOMETRY_TABLE.
Method is executing following statement:
CREATE TABLE "schema_name"."geometry" ( "id" VARCHAR, "name" VARCHAR,
"description" VARCHAR, "type" VARCHAR, "geometry" geometry )
This fails with postgresql message:
ERROR: type "geometry" already exists
Hint: A relation has an associated type of the same name, so you must use a
name that doesn't conflict with any existing type.
Error message says that you cannot create table named "geometry" because type
named the same already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://jira.codehaus.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
