gvSIG bugs #4814
Error when exporting to PostGIS
Status: | Closed | % Done: | 0% | |
---|---|---|---|---|
Priority: | Normal | Spent time: | - | |
Assignee: | Joaquín del Cerro Murciano | |||
Category: | Database | |||
Target version: | 2.4.0-2849 (rev. org.gvsig.desktop-2.0.219) | |||
Severity: | Major | Add-on version: | ||
gvSIG version: | 2.4.0 | Add-on build: | ||
gvSIG build: | 2848 | Add-on resolve version: | ||
Operative System: | Add-on resolve build: | |||
Keywords: | Proyecto: | |||
Has patch: | Hito: | |||
Add-on name: | Unknown |
Description
When we export a SHP to PostGIS we get an error and it doesn't finish. The same action works in gvSIG 2.3.1.
I attach log file.
Associated revisions
refs #4814, añadido que cuando falle ejecutando una sentencia SQL la muestre en el log.
refs #4814. Modificado el builder de postgresql para que al crear sentencias del tipo 'CREATE INDEX IF NOT EXISTS ...' solo use el condicional para versiones de postgresql 9.5 y superiores.
History
#1 Updated by Joaquín del Cerro Murciano over 6 years ago
Mario, no soy capaz de reproducir el error.
¿ Podrias hacerme llegar la capa que estas usando (Zurich_Streets_4326.shp) ?
#3 Updated by Joaquín del Cerro Murciano over 6 years ago
- Target version set to 2.4.0-2850-final (rev. org.gvsig.desktop-2.0.220)
#4 Updated by Joaquín del Cerro Murciano over 6 years ago
Al parecer estamos usando una construccion:
CREATE INDEX IF NOT EXISTS ...
Y eso no esta soportado hasta Postgresql 9.5.
Voy a ver de comprobar la version de postgresql y si es 9.5 o superior tirare de eso y si no simplemente intetare crear el indice.
#5 Updated by Joaquín del Cerro Murciano over 6 years ago
- Assignee set to Joaquín del Cerro Murciano
- Status changed from New to Fixed
#6 Updated by Joaquín del Cerro Murciano over 6 years ago
- Target version changed from 2.4.0-2850-final (rev. org.gvsig.desktop-2.0.220) to 2.4.0-2849 (rev. org.gvsig.desktop-2.0.219)
#7 Updated by Álvaro Anguix over 5 years ago
- Status changed from Fixed to Closed