[gdal-dev] Error when appending non-spatial tables in GML to PostGIS

[Matt Walker]

Hi,

I'm loading some Ordnance Survey ITN GML data into PostgreSQL 9.1 / PostGIS
1.5 which contains a number of feature types that are lookups without any
geometry, the first file loads fine but loading subsequent files using the
ogr2ogr -append option fails with the error:

    ERROR 1: Layer road already exists, CreateLayer failed.
    Use the layer creation option OVERWRITE=YES to replace it.

I'm finding that the gfs file generated by OGR sets the geometry type to
100 (no geometry), manually editing the gfs file to remove the GeometryType
element for the lookup feature types works around the error but creates a
redundant geometry column and an entry in geometry_columns.

I've put further details and two sample gml files containing a single
"feature" in each here: https://gist.github.com/walkermatt/7655745

Happy to create at ticket if it's appropriate.

Thanks,

Matt

-- 
Matt Walker
Astun Technology
@_walkermatt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20131126/33df15b5/attachment.html>