Thanks even for the feedback. I have just spotted the nomd option but I didn't get the time to test it.
Regards Alexandre Le mar. 11 juin 2024 à 17:43, Even Rouault <even.roua...@spatialys.com> a écrit : > 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 > listgdal-dev@lists.osgeo.orghttps://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