gvSIG bugs #4814

Error when exporting to PostGIS

Added by Mario Carrera about 6 years ago. Updated about 5 years ago.

Status:Closed% Done:

0%

Priority:NormalSpent 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.

gvSIG.log (430 KB) Mario Carrera, 02/14/2018 01:32 PM

Zurich_Streets.zip (34.6 KB) Mario Carrera, 02/19/2018 09:46 AM

Associated revisions

Revision 43756
Added by Joaquín del Cerro Murciano about 6 years ago

refs #4814, añadido que cuando falle ejecutando una sentencia SQL la muestre en el log.

Revision 464
Added by Joaquín del Cerro Murciano about 6 years ago

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 about 6 years ago

Mario, no soy capaz de reproducir el error.
¿ Podrias hacerme llegar la capa que estas usando (Zurich_Streets_4326.shp) ?

#2 Updated by Mario Carrera about 6 years ago

Adjunto la capa.

#3 Updated by Joaquín del Cerro Murciano about 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 about 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 about 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 about 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 about 5 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF