Hi, It creates table "table" and corresponding spatial index having name "table_GEOMETRY_idx". Or "Table" and "Table_GEOMETRY_idx". Indes names in my database are definitely with underscores, not with blancs.
I have PostgreSQL 9.1 and PostGIS 2.1 on another computer, I will repeat the test with it a bit later. -Jukka- Uwe Dalluege wrote: > > Hi Jukka, > > I am working with OJ 20130318 rev. 3364 > and with PostgreSQL 9.2.3 and PostGIS 2.0.2 > > SELECT * from pg_indexes > > shows under attribute tablename the value new and under indexname the > value new GEOMETRY idx (with blanks and not New_GEOMETRY_idx). > > Does the PostGIS PlugIn creates an index? > > Uwe > > > > Am 21.03.2013 14:23, schrieb Rahkonen Jukka: > > 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.SaveToPostGISDataSour > >>>> ce > >>>> .cr > >>>> eateAndPopulateTable(SaveToPostGISDataSource.java:341) > >>>> at > >>>> > org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSour > >>>> ce > >>>> .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(AbstractJdbc2St > >>>> at > >>>> em > >>>> ent.java:555) > >>>> at > >>>> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstra > >>>> ct > >>>> Jdb > >>>> c2Statement.java:403) > >>>> at > >>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2St > >>>> at > >>>> em > >>>> ent.java:395) > >>>> at > >>>> > org.openjump.core.ui.plugin.datastore.postgis.SaveToPostGISDataSour > >>>> ce > >>>> .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 > > ------------------------------------------------------------------------------ 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
