<html xmlns:v="urn:schemas-microsoft-com:vml" 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-1"><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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>The PostGIS development team is pleased to release PostGIS 3.0.0alpha3.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="http://www.postgis.net/2019/07/01/postgis-3.0.0alpha3/">http://www.postgis.net/2019/07/01/postgis-3.0.0alpha3/</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This release works with PostgreSQL 9.5-12beta2 and GEOS >= 3.6<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Best served with [PostgreSQL 12beta2] https://www.postgresql.org/developer/beta/<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>**3.0.0alpha3**<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>* [source download]https://download.osgeo.org/postgis/source/postgis-3.0.0alpha3.tar.gz<o:p></o:p></p><p class=MsoNormal>* [NEWS] https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha3/NEWS<o:p></o:p></p><p class=MsoNormal>* PDF docs [en] https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha3.pdf<o:p></o:p></p><p class=MsoNormal>* [html doc download] https://download.osgeo.org/postgis/docs/doc-html-3.0.0alpha3.tar.gz<o:p></o:p></p><p class=MsoNormal>* [epub doc download] https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha3.epub<o:p></o:p></p><p class=MsoNormal>* [Changelog]https://svn.osgeo.org/postgis/tags/3.0.0alpha3/ChangeLog<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>View all [closed tickets for 3.0.0] https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Main changes since PostGIS 3.0.0alpha2 release are as follows:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>* 4438, Update serialization to support extended flags area (Paul Ramsey)<o:p></o:p></p><p class=MsoNormal>* 3437, Speed up ST_Intersects with Points (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4352, Use CREATE OR REPLACE AGGREGATE for PG12+ (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4441, Make GiST penalty friendly to multi-column indexes and build single-column<o:p></o:p></p><p class=MsoNormal> ones faster. (Darafei Praliaskouski)<o:p></o:p></p><p class=MsoNormal>* 4372, PROJ6: Speed improvements (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4414, Include version number in address_standardizer lib (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4334, Fix upgrade issues related to renamed parameters (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4388, AddRasterConstraints: Ignore NULLs when generating constraints (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4327, Avoid pfree'ing the result of getenv (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4406, Throw on invalid characters when decoding geohash (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4429, Avoid resource leaks with PROJ6 (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4443, Fix wagyu configure dropping CPPFLAGS (Raúl Marín)<o:p></o:p></p><p class=MsoNormal>* 4440, Type lookups in FDW fail (Paul Ramsey)<o:p></o:p></p><p class=MsoNormal>* 4442, raster2pgsql now skips NODATA tiles. Use -k option if you still want<o:p></o:p></p><p class=MsoNormal> them in database for some reason. (Darafei Praliaskouski)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Happy Testing,<o:p></o:p></p><p class=MsoNormal>PostGIS Development Team<o:p></o:p></p></div></body></html>