<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi,</p>
<p>The issue has been reported in
<a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/issues/9994">https://github.com/OSGeo/gdal/issues/9994</a> and should be be fixed
in 3.9.1 per <a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/pull/10004">https://github.com/OSGeo/gdal/pull/10004</a> (testing of
the 3.9 branch at <a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/tree/release/3.9">https://github.com/OSGeo/gdal/tree/release/3.9</a>
would be appreciated to confirm that it fixes error for various
permission scenarios)</p>
<p>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</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 11/06/2024 à 17:33, Alexandre Gacon
via gdal-dev a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAFJaAp7yGPf4283tVMcUahspJ6YAxgyX9Zav7w10Y2k7nFsg3w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hello there,</div>
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div><span
style="color:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,sans-serif;font-size:15px;font-style:normal;font-variant-ligatures:common-ligatures;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;word-spacing:0px;white-space:normal;background-color:rgb(248,248,248);text-decoration-style:initial;text-decoration-color:initial;display:inline;float:none">ERROR:
permission denied to create event trigger
"ogr_system_tables_event_trigger_for_metadata". HINT: Must
be superuser to create an event trigger.</span></div>
<div><br>
</div>
<div>If I dig in the codebase, it is related to a change named "
<div class="gmail-d-flex">
<div class="gmail-commit-title gmail-markdown-title"> PG:
serialize GDAL multidomain metadata of layer as XML in a
ogr_system_tables.metadata table"</div>
</div>
</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Regards<br>
</div>
<div><br>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">Alexandre Gacon</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>