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.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
------------------------------------------------------------------------------
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
