[gdal-dev] ogr python: copying features from postgis to postgis

[Even Rouault]

On samedi 26 novembre 2016 21:18:50 CET Stefan Ziegler wrote:
> Hi
> 
> I'm trying to copy some features from one postgis table to another postgis
> table:
> 
> dstLayer.StartTransaction()
> 
> srcFeature = srcLayer.GetNextFeature()
> while srcFeature is not None:
>     srcLayerDefn = srcLayer.GetLayerDefn()
> 
>     dstLayerDefn = dstLayer.GetLayerDefn()
>     dstFeature = ogr.Feature(dstLayerDefn)
>     dstFeature.SetFID(-1)
> 
>     for i in range(0, dstLayerDefn.GetFieldCount()):
>         attrName = dstLayerDefn.GetFieldDefn(i).GetNameRef()
> 
>         # ATTRIBUTES
>         try:
>             attrVal = srcFeature.GetField(attrName)
>             dstFeature.SetField(attrName, attrVal)
>         except ValueError:
>             pass
> 
>     # GEOMETRY
>     geom = srcFeature.GetGeometryRef()
>     dstFeature.SetGeometry(geom)
> 
>     # ADD FEATURE
>     dstLayer.CreateFeature(dstFeature)
> 
>     srcFeature = srcLayer.GetNextFeature()
> 
> dstLayer.CommitTransaction()
> 
> It throws an error when trying to create the new feature:
> 
> GNM: GNMRegisterAllInternal
> GNM: RegisterGNMFile
> GNM: RegisterGNMdatabase
> PG: DBName="xanadu2"
> PG: PostgreSQL version string : 'PostgreSQL 9.5.4 on x86_64-pc-linux-gnu,
> compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.2) 5.4.0 20160609, 64-bit'
> PG: PostGIS version string : '2.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1'
> GDAL: GDALOpen(PG: host=localhost dbname=xanadu2 user=stefan
> password=XXXXXXXXXX this=0x11e41b0) succeeds as PostgreSQL.
> PG: Command Results Tuples = 11
> GDAL: GDALDriver::Create(Memory,,0,0,0,Unknown,(nil))
> PG: 11 features read on layer 'sql_statement'.
> PG: DBName="xanadu2"
> PG: PostgreSQL version string : 'PostgreSQL 9.5.4 on x86_64-pc-linux-gnu,
> compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.2) 5.4.0 20160609, 64-bit'
> PG: PostGIS version string : '2.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1'
> GDAL: GDALOpen(PG: host=localhost dbname=xanadu2 user=stefan
> password=XXXXXXXXXX this=0x12db330) succeeds as PostgreSQL.
> PG: Primary key name (FID): t_id, type : int8
> PG: Using column 't_id' as FID for table
> 'nachfuehrngskrise_nachfuehrungskreis'
> Traceback (most recent call last):
>   File "./datenumbau.py", line 117, in <module>
>     dstLayer.CreateFeature(dstFeature)
>   File "/usr/local/gdal_master/lib/python2.7/site-packages/osgeo/ogr.py",
> line 1479, in CreateFeature
>     return _ogr.Layer_CreateFeature(self, *args)
> RuntimeError: OGR Error: General Error
> GDAL: GDALClose(PG: host=localhost dbname=xanadu2 user=stefan
> password=XXXXXXXXXX this=0x12db330)
> GDAL: GDALClose(PG: host=localhost dbname=xanadu2 user=stefan
> password=XXXXXXXXXX this=0x11e41b0)
> GDAL: In GDALDestroy - unloading GDAL shared library.
> GDAL: Force close of  (0x136abb0) in GDALDriverManager cleanup.
> Mem: 1 features read on layer 'sql_statement'.
> 
> I'm bit confused about the "general error". Does anyone has an idea?

What if you don't enable python exceptions from GDAL errors (ie don't call 
gdal.UseExceptions(), or use gdal.DontUseExceptions()). Do you get something more 
verbose ?

> 
> regards
> Stefan


-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20161128/5cef389a/attachment-0001.html>