Hi, I can't reproduce the error with a bit old OpenJUMP version r3131, PostgreSQL 9.0 and PostGIS 1.5 by working in a normal way. No problem with saving a layer as "new", "New", "uusi" and "Uusi".
However, I managed to get the same error message than you by creating an index as CREATE INDEX "New_GEOMETRY_idx" ON "new" USING GIST ( "GEOMETRY" ) So I created an index named "New_GEOMETRY_idx" on existing table "new". Now I can't create new table "New" with OpenJUMP because there is already an index with that name, even it is an index for another table. Did you do what I was suggesting by running "SELECT * from pg_indexes where indexname='New_GEOMETRY_idx" -Jukka Rahkonen- Uwe Dalluege wrote: > Hi Jukka, > > it seems that the PostGIS PlugIn creates an index on the geometry column. > The problem are the tablenames with capital letters and small letters. > But for the user is the tablename new = New but unfortunately not for > Postgres. > > Maybe it is a solution that the plugin writes tablenames in small letters? > > What do you think? > > Regards > > Uwe > > Am 21.03.2013 13:09, schrieb Rahkonen Jukka: > > 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.AbstractSaveDatasetAsPlu > >> gI > >> 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(QueryEx > >> ec > >> utorImpl.java:2157) > >> at > >> > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor > >> Im > >> pl.java:1886) > >> at > >> > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja > >> va > >> :255) > >> at > >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat > >> em > >> ent.java:555) > >> at > >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract > >> Jdb > >> c2Statement.java:403) > >> at > >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat > >> em > >> 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 > > ------------------------------------------------------------------------------ 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
