gdal.VectorTranslate doesn't handle properly the connection

[yjacolin]

gdal.VectorTranslate() doesn't currently properly handle the situation where you pass a dstDS object but not specify accessMode to be 'append', 'update' or 'overwrite'.

Example of code:

dstDS = gdal.OpenEx(connectionString)

for id in idList:

    srcDS = gdal.OpenEx('/tmp/file_' + str(id) + '.geojson')

    gdal.VectorTranslate(
     dstDS,
     srcDS,
     format = 'PostgreSQL',
     layerName='myLayer'
   )
   del srcDS

del dstDS

Result: PostgreSQL fatal error: too many clients already.

[Even Rouault]

In 34857:

GDALVectorTranslate(): imply update mode if access mode not explicitly specified and hDstDS != NULL (fixes #6612)

[Even Rouault]

In 34858:

GDALVectorTranslate(): imply update mode if access mode not explicitly specified and hDstDS != NULL (fixes #6612)