<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-GB" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;color:black">Hi all<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:black">I have used postgres 17.2 with postgis 3.5.1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:black">POSTGIS="3.5.1 48ab069" [EXTENSION] PGSQL="170" GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/lib/pgsql/.local/share/proj
DATABASE_PATH=/usr/proj95/share/proj/proj.db" (compiled against PROJ 9.5.1) LIBXML="2.9.13" LIBJSON="0.14" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" TOPOLOGY<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:black">As it should already fix the issue of loosing st_srid while doing st_union.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:black">However when doing :<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p style="margin:0cm;background:white"><b><span style="font-family:Menlo;color:maroon">select</span></b><span style="font-family:Menlo;color:black">
</span><b><span style="font-family:Menlo;color:navy">ST_SRID</span></b><span style="font-family:Menlo;color:black">(</span><b><span style="font-family:Menlo;color:navy">ST_GeomFromText</span></b><span style="font-family:Menlo;color:black">(</span><b><span style="font-family:Menlo;color:green">'POLYGON
((4.9882543 50.4415584, 4.9882543 50.4415586, 4.9882545 50.4415586, 4.9882545 50.4415584, 4.9882543 50.4415584))'</span></b><span style="font-family:Menlo;color:black">,</span><span style="font-family:Menlo;color:blue">4326</span><span style="font-family:Menlo;color:black">)),<o:p></o:p></span></p>
<p style="margin:0cm;background:white"><b><span style="font-family:Menlo;color:navy">st_srid</span></b><span style="font-family:Menlo;color:black">(ST_UNION(</span><b><span style="font-family:Menlo;color:maroon">ARRAY</span></b><span style="font-family:Menlo;color:black">[</span><b><span style="font-family:Menlo;color:navy">ST_GeomFromText</span></b><span style="font-family:Menlo;color:black">(</span><b><span style="font-family:Menlo;color:green">'POLYGON
((4.9882543 50.4415584, 4.9882543 50.4415586, 4.9882545 50.4415586, 4.9882545 50.4415584, 4.9882543 50.4415584))'</span></b><span style="font-family:Menlo;color:black">,</span><span style="font-family:Menlo;color:blue">4326</span><span style="font-family:Menlo;color:black">)]))
</span><span style="font-family:Menlo;color:red">;</span><span style="font-family:Menlo;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">again it is 4326 v 0.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Can someone confirm that fix was released in 3.5.1 ?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none">Best regards<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;text-indent:-18.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none">Łukasz Szałek<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>