[gdal-dev] python scripts - create layer problem

[Martin Landa]

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