Hi, The SQL in the error message looks good and the error seems to come from PostgreSQL and it says that an index with the same name exists already. FEHLER: Relation New_GEOMETRY_idx existiert bereits
Do "SELECT * from pg_indexes where indexname='New_GEOMETRY_idx" and make sure that such index does not really exist. If that is the case and you can repeat the error, turn on statement logging on PostrgreSQL side and check the exact SQL which is sent by OpenJUMP. The SQL from the error message shoud work OK " CREATE INDEX "New_GEOMETRY_idx" ON "New" USING GIST ( "GEOMETRY" )". -Jukka Rahkonen- Uwe Dalluege wrote: > 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.cr > eateAndPopulateTable(SaveToPostGISDataSource.java:341) > at > org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource.ac > cess$400(SaveToPostGISDataSource.java:50) > at > org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource$1. > executeUpdate(SaveToPostGISDataSource.java:183) > at > com.vividsolutions.jump.workbench.datasource.AbstractSaveDatasetAsPlugI > n.run(AbstractSaveDatasetAsPlugIn.java:33) > at > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrap > per.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(QueryExec > utorImpl.java:2157) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorIm > pl.java:1886) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java > :255) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statem > ent.java:555) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb > c2Statement.java:403) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statem > ent.java:395) > at > org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSource.cr > eateAndPopulateTable(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 ------------------------------------------------------------------------------ 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
