Hi,
if the PostGIS database contains a table namend new (with small letter)
and you try to save the layer New (with capital N)
you receive the error:
java.sql.SQLException: Error executing query: CREATE INDEX
"New_GEOMETRY_idx" ON "New" USING GIST ( "GEOMETRY" )
at
org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource.createAndPopulateTable(SaveToPostGISDataSource.java:341)
at
org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource.access$400(SaveToPostGISDataSource.java:50)
at
org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource$1.executeUpdate(SaveToPostGISDataSource.java:183)
at
com.vividsolutions.jump.workbench.datasource.AbstractSaveDatasetAsPlugIn.run(AbstractSaveDatasetAsPlugIn.java:33)
at
com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:152)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.postgresql.util.PSQLException: FEHLER: Relation
New_GEOMETRY_idx existiert bereits
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at
org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource.createAndPopulateTable(SaveToPostGISDataSource.java:339)
... 5 more
Regards
Uwe
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
