Hi,
You should know that currently, the PostGIS plugin
works in a case-sensitive way.
I choosed to double quote every schema/table names
before sending queries.
I know it is not the default behaviour of SQL, but it is
possible and it appeared more simple to understand
and to implement this way.
I tried to manage both cases with/without double
quotes but it made things much more complicated
and error prone.
I think that this way, you can manage lower case, upper
case and mixed case table names as soon as you are
aware of how it works.
Let me know
- if there is something broken from the above perspective
- if you know use cases where it can really be a problem
Michaël
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
------------------------------------------------------------------------------
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
