Hi all, I have a Python script which converts data from GML (VFR) to PostGIS. When I am overwriting existing layers in PostGIS, not all layers are really created. First existing layers are deleted [1] and than created [2] from scratch.
Steps to reproduce (`git clone https://github.com/landam/ogr-vfr.git`): CPL_DEBUG=ON ./vfr2pg --type OB_584029_UKSH --dbname vfr --o 2> log Exporting layer Obce ... 1 features Exporting layer CastiObci ... 1 features Exporting layer KatastralniUzemi ... 1 features Exporting layer Zsj ... 3 features Exporting layer Ulice ... 28 features Exporting layer Parcely ... 5628 features Exporting layer StavebniObjekty ... 1007 features Exporting layer AdresniMista ... 851 features The problem is that table 'zsj' is not created in output DB. It's random, mostly one or two tables are missing at the end: psql vfr -c"select distinct f_table_name from geometry_columns" f_table_name ------------------ castiobci ulice obce katastralniuzemi stavebniobjekty adresnimista parcely (7 rows) >From the log [3] it seems to be OK. PG: PQexecParams(CREATE TABLE "public"."zsj" ( OGC_FID SERIAL, PRIMARY KEY (OGC_FID) )) = PGRES_COMMAND_OK PG: PQexecParams(COMMIT) = PGRES_COMMAND_OK Tested on Debian GNU/Linux, PG 9.1.12, PostGIS 2.1, GDAL compiled from trunk. Any idea what could be wrong? Thanks in advance! Martin [1] https://github.com/landam/ogr-vfr/blob/master/vfr4ogr/ogr.py#L156 [2] https://github.com/landam/ogr-vfr/blob/master/vfr4ogr/ogr.py#L164 [3] http://geo102.fsv.cvut.cz/~landa/log -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
