<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">I’ll have a fix in source control before lunch. A release might be a month or so away, as we collect a bunch of fixes into a single patch release.<div><br></div><div>P<br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On Oct 15, 2024, at 8:15 AM, Łukasz Szałek via postgis-users <postgis-users@lists.osgeo.org> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: HelveticaNeue; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span lang="EN-US" style="font-size: 11pt;">The same situation is in Postgis 3.5.0<o:p></o:p></span></div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span lang="EN-US" style="font-size: 11pt;">@</span><span lang="EN-US" style="">Erik Wienhold – do you know when some fix might appear?<o:p></o:p></span></div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span lang="EN-US" style="font-size: 11pt;"><o:p> </o:p></span></div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span lang="EN-US" style="font-size: 11pt;"><o:p> </o:p></span></div><div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">Best regards<o:p></o:p></span></div><div style="margin: 0cm 0cm 0cm 18pt; font-size: 12pt; font-family: Aptos, sans-serif; text-indent: -18pt;"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">Łukasz Szałek<o:p></o:p></span></div></div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 11pt;"><o:p> </o:p></span></div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 11pt;"><o:p> </o:p></span></div><div id="mail-editor-reference-message-container"><div><div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) currentcolor currentcolor; border-image: none; padding: 3pt 0cm 0cm;"><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: Aptos, sans-serif;"><b><span style="">Od:<span class="Apple-converted-space"> </span></span></b><span style="">Erik Wienhold <<a href="mailto:ewie@ewie.name" style="color: blue; text-decoration: underline;">ewie@ewie.name</a>><br><b>Data:<span class="Apple-converted-space"> </span></b>wtorek, 15 października 2024 o 15:59<br><b>Do:<span class="Apple-converted-space"> </span></b>Łukasz Szałek <<a href="mailto:Lukasz.Szalek@tomtom.com" style="color: blue; text-decoration: underline;">Lukasz.Szalek@tomtom.com</a>><br><b>DW:<span class="Apple-converted-space"> </span></b><a href="mailto:postgis-users@lists.osgeo.org" style="color: blue; text-decoration: underline;">postgis-users@lists.osgeo.org</a><span class="Apple-converted-space"> </span><<a href="mailto:postgis-users@lists.osgeo.org" style="color: blue; text-decoration: underline;">postgis-users@lists.osgeo.org</a>><br><b>Temat:<span class="Apple-converted-space"> </span></b>Re: SRID lost in ST_UNION<o:p></o:p></span></p></div><div><div style="margin: 0cm; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 11pt;">[Nie otrzymujesz często wiadomości e-mail z<span class="Apple-converted-space"> </span><a href="mailto:ewie@ewie.name" style="color: blue; text-decoration: underline;">ewie@ewie.name</a>. Dowiedz się, dlaczego jest to ważne, na stronie<a href="https://aka.ms/LearnAboutSenderIdentification" style="color: blue; text-decoration: underline;">https://aka.ms/LearnAboutSenderIdentification</a><span class="Apple-converted-space"> </span>]<br><br>On 2024-10-15 12:14 +0200, Łukasz Szałek via postgis-users wrote:<br>> 1)<br>> PostgreSQL 15.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit<br>> POSTGIS="3.3.2 4975da8" [EXTENSION] PGSQL="150" GEOS="3.11.1-CAPI-1.17.1" PROJ="7.2.1" LIBXML="2.9.1" LIBJSON="0.11"<br>><br>> Query:<br>> select ST_SRID(ST_GeomFromText('POLYGON ((4.9882543 50.4415584, 4.9882543 50.4415586, 4.9882545 50.4415586, 4.9882545 50.4415584, 4.9882543 50.4415584))',4326)), st_srid(ST_UNION(ARRAY[ST_GeomFromText('POLYGON ((4.9882543 50.4415584, 4.9882543 50.4415586, 4.9882545 50.4415586, 4.9882545 50.4415584, 4.9882543 50.4415584))',4326)]));<br>> st_srid | st_srid<br>> ---------+---------<br>> 4326 | 4326<br>> (1 row)<br>><br>><br>> 2)<br>> PostgreSQL 17.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20231218 (Red Hat 11.4.1-3), 64-bit<br>> POSTGIS="3.3.7 a0c7967" [EXTENSION] PGSQL="170" GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.0" LIBXML="2.9.13" LIBJSON="0.14" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"<br>><br>> Query:<br>> select ST_SRID(ST_GeomFromText('POLYGON ((4.9882543 50.4415584, 4.9882543 50.4415586, 4.9882545 50.4415586, 4.9882545 50.4415584, 4.9882543 50.4415584))',4326)), st_srid(ST_UNION(ARRAY[ST_GeomFromText('POLYGON ((4.9882543 50.4415584, 4.9882543 50.4415586, 4.9882545 50.4415586, 4.9882545 50.4415584, 4.9882543 50.4415584))',4326)]));<br>> st_srid | st_srid<br>> ---------+---------<br>> 4326 | 0<br>><br>> Is there a regression between those versions?<br><br>Yes, I see the same regression in 3.4.3 as well. This is caused by [1]<br>which sets SRID=0 [2] because the SRID has not been determined at this<br>point.<br><br>[1]<span class="Apple-converted-space"> </span><a href="https://trac.osgeo.org/postgis/ticket/5677" style="color: blue; text-decoration: underline;">https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftrac.osgeo.org%2Fpostgis%2Fticket%2F5677&data=05%7C02%7CLukasz.Szalek%40tomtom.com%7Ca695afcc41294588cada08dced218a42%7C374f80267b544a3ab87d328fa26ec10d%7C0%7C0%7C638645975535855008%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=oRHG9AeOjggODtwV8AZwG5%2Boq6Wl9%2BcFs%2Fof2jZaMHE%3D&reserved=0</a><br>[2]<span class="Apple-converted-space"> </span><a href="https://trac.osgeo.org/postgis/browser/git/postgis/lwgeom_geos.c?rev=f37390b9cc4b33e8a7ec15e0396112fca19391c9#L659" style="color: blue; text-decoration: underline;">https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftrac.osgeo.org%2Fpostgis%2Fbrowser%2Fgit%2Fpostgis%2Flwgeom_geos.c%3Frev%3Df37390b9cc4b33e8a7ec15e0396112fca19391c9%23L659&data=05%7C02%7CLukasz.Szalek%40tomtom.com%7Ca695afcc41294588cada08dced218a42%7C374f80267b544a3ab87d328fa26ec10d%7C0%7C0%7C638645975535881735%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=SFlNOLYkqr%2FTQNjEzAvH8%2FQHgI7OT2XSqE3e1rcve%2BE%3D&reserved=0</a><br><br>--<br>Erik</span></div></div></div></div></div></div></div></blockquote></div><br></div></body></html>