<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Please file at ticket about that at
<a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/issues">https://github.com/OSGeo/gdal/issues</a><br>
</p>
<div class="moz-cite-prefix">Le 30/07/2024 à 10:57, Hanskaspar Frei
via gdal-dev a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:b2b05d57-4e9c-4ffc-9615-ee8d5fa19f33@karten-werk.ch">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<pre class="moz-quote-pre" wrap="">Hi everybody
We used an old GDAL Version (3.2.1) to load data to a postgis db with
ogr2ogr.
There was an automatic spatial index generation taking place, which
seemed to have a logic to avoid duplicated index names.
Examples with GDAL 3.2.1:
For a table with the name
"ch059_liegenschaften_grundstueckpos_hilfslinien" a index named
"ch059_liegenschaften_grundstueckpos_hilfs_wkb_geometry_geom_idx" got
created.
For a table with the name
"ch059_liegenschaften_grundstueckpos_hilfslinien_proj" a index named
"ch059_liegenschaften_grundstueckpos_hilfslinien_proj_wkb_geomet" got
created.
Examples with GDAL 3.9.1:
For a table with the name
"ch059_liegenschaften_grundstueckpos_hilfslinien" a index named
"ch059_liegenschaften_grundstueckpos_hilfs_wkb_geometry_geom_idx" got
created.(equal like GDAL 3.2.1)
For a table with the name
"ch059_liegenschaften_grundstueckpos_hilfslinien_proj" it tries to
create an index named
"ch059_liegenschaften_grundstueckpos_hilfs_wkb_geometry_geom_idx" which
is equal to the one of the table above and therefore not valid in postgres
I am aware that the the maximum identifier length in postgis is 63 Bytes
and therefore the index names get cutted.
But why is this change in the index naming happening between GDAL
Version 3.2.1 and 3.9.1?
We don't want to downgrade to the old GDAL Version, but Is there a way
to go back to the old naming system which avoided duplicated names?
Thanks and best regards
Hanskaspar Frei</pre>
<div class="moz-signature">-- <br>
<img src="cid:part1.FEloiMEL.lH2psuyB@spatialys.com" alt="logo"
class="" width="23" height="29"><br>
<font face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial,
sans-serif"><b>K</b></font></font><font
face="Helvetica, Arial,
sans-serif"><font face="Helvetica, Arial, sans-serif"><b>a</b></font></font><font
face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial,
sans-serif"><b>rten-Werk GmbH</b><br>
Hanskaspar Frei<br>
Via Vincenzo Dalberti 13<br>
6718 Olivone<br>
<br>
Phone: +41 79 360 72 83<br>
Web: <a class="moz-txt-link-freetext"
href="https://karten-werk.ch" moz-do-not-send="true">https://karten-werk.ch</a>
| E-Mail:
<a class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:hkfrei@karten-werk.ch" moz-do-not-send="true">hkfrei@karten-werk.ch</a></font></font></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>