Re: When did this 'officially' change? "SQL-MM defines the default SRID of all geometry constructors as 0. PostGIS uses a default SRID of -1."

--000000000000eaea260649a01b08
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

PostGIS 2.0? 14 years ago

https://github.com/postgis/postgis/blob/master/NEWS#L1937

Wheeps, that's a long-time doo error.

P.

On Fri, Jan 30, 2026 at 11:31=E2=80=AFAM Michael Downey via postgis-users <
[email protected]> wrote:

> Hello,
>
>
>
> I see this note
>
> =E2=80=9CSQL-MM defines the default SRID of all geometry constructors as =
0.
> PostGIS uses a default SRID of -1" on the
> PostGIS_Special_Functions_Index.html page all the way though 3.2
>
> https://postgis.net/docs/manual-3.2/PostGIS_Special_Functions_Index.html
>
>
>
> Since then it is not there.
>
>
>
> I have not checked this question under versions < 3.4. AI results indicat=
e
> that it was 3.0 when it started. A question from a user in our community
> indicates 2.0.
>
>
>
> Perhaps it started at an earlier time and culminated at 3.3?
>
>
>
> Thanks,
>
> Michael
>
>
>

--000000000000eaea260649a01b08
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">PostGIS 2.0? 14 years ago<div><br></div><div><a href=3D"ht=
tps://github.com/postgis/postgis/blob/master/NEWS#L1937">https://github.com=
/postgis/postgis/blob/master/NEWS#L1937</a><br></div><div><br></div><div>Wh=
eeps, that&#39;s a long-time doo error.</div><div><br></div><div>P.</div></=
div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" c=
lass=3D"gmail_attr">On Fri, Jan 30, 2026 at 11:31=E2=80=AFAM Michael Downey=
 via postgis-users &lt;<a href=3D"mailto:[email protected]">pos=
[email protected]</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-le=
ft-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div cl=
ass=3D"msg-8223978787729032864">





<div lang=3D"EN-US" style=3D"overflow-wrap: break-word;">
<div class=3D"m_-8223978787729032864WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Hello,<u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">I see this note <u></=
u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=E2=80=9CSQL-MM defin=
es the default SRID of all geometry constructors as 0. PostGIS uses a defau=
lt SRID of -1&quot; on the PostGIS_Special_Functions_Index.html page all th=
e way though 3.2<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><a href=3D"https://po=
stgis.net/docs/manual-3.2/PostGIS_Special_Functions_Index.html" target=3D"_=
blank">https://postgis.net/docs/manual-3.2/PostGIS_Special_Functions_Index.=
html</a><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Since then it is not =
there.<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">I have not checked th=
is question under versions &lt; 3.4. AI results indicate that it was 3.0 wh=
en it started. A question from a user in our community indicates 2.0.<u></u=
><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Perhaps it started at=
 an earlier time and culminated at 3.3?<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Thanks,<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Michael<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
</div>
</div>

</div></blockquote></div>

--000000000000eaea260649a01b08--