Hi,
The issue has been reported in https://github.com/OSGeo/gdal/issues/9994
and should be be fixed in 3.9.1 per
https://github.com/OSGeo/gdal/pull/10004 (testing of the 3.9 branch at
https://github.com/OSGeo/gdal/tree/release/3.9 would be appreciated to
confirm that it fixes error for various permission scenarios)
You can typically get the error with 3.9.0 when importing a shapefile
since there is a layer metadata item set on the shapefile layer when
reading it, that gets automatically imported by ogr2ogr. You can
workaround the issue by specifying the "-nomd" ogr2ogr option
Even
Le 11/06/2024 à 17:33, Alexandre Gacon via gdal-dev a écrit :
Hello there,
After updating our stack from GDAL 3.4.1 to GDAL 3.9.0, we have
ogr2ogr calls which no longer succeed with the following message:
ERROR: permission denied to create event trigger
"ogr_system_tables_event_trigger_for_metadata". HINT: Must be
superuser to create an event trigger.
If I dig in the codebase, it is related to a change named "
PG: serialize GDAL multidomain metadata of layer as XML in a
ogr_system_tables.metadata table"
We don't have multidomain in our data: is it mandatory no to use a
superuser when importing data into a PG DB with ogr2ogr or is there a
way to dismiss this message?
Regards
--
Alexandre Gacon
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
