[postgis-tickets] r17324 - Prep for PostGIS 2.4.7 release

Regina Obe lr at pcorp.us
Mon Mar 11 07:22:27 PDT 2019


Author: robe
Date: 2019-03-11 07:22:26 -0700 (Mon, 11 Mar 2019)
New Revision: 17324

Modified:
   branches/2.4/ChangeLog
   branches/2.4/NEWS
   branches/2.4/README.postgis
   branches/2.4/doc/release_notes.xml
   branches/2.4/extensions/upgradeable_versions.mk
   branches/2.4/extras/tiger_geocoder/tables/lookup_tables_2011.sql
Log:
Prep for PostGIS 2.4.7 release 
Remove zcta5 geometry constraint
References #4086

Modified: branches/2.4/ChangeLog
===================================================================
--- branches/2.4/ChangeLog	2019-03-11 12:40:21 UTC (rev 17323)
+++ branches/2.4/ChangeLog	2019-03-11 14:22:26 UTC (rev 17324)
@@ -1,3 +1,161 @@
+2019-03-10 19:04  Regina Obe <lr at pcorp.us>
+
+	* [r17322] Make _drop_raster_constraint_spatially_unique and
+	  _raster_constraint_info_spatially_unique allow for presence or
+	  absense of schema qual on geometry cast.
+	  Was failing before when installed as extension (but not by
+	  script)
+	  Reference #4291 for PostGIS 2.4.7
+
+2019-03-09 18:43  Regina Obe <lr at pcorp.us>
+
+	* [r17315] Schema qualify all geometry casts in raster code,
+	  otherwise materialized views do not resture
+	  Closes #4291 for PostGIS 2.4.7
+
+2019-02-15 19:00  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17258] Update test running instructions
+
+2019-02-15 18:53  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17254] Update OGC certification scripts to match new SFSQL 1.2
+	  signatures
+
+2019-02-11 17:20  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17239] Add generated file
+
+2019-02-11 17:20  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17238] Add lexer initialization
+	  References #4017
+
+2019-01-31 15:51  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17225] PostgreSQL 12 compatibility
+	  
+	  Initial patch by Laurenz Albe
+	  Closes #4313
+	  Closes https://github.com/postgis/postgis/pull/368/
+
+2019-01-22 09:07  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17205] Partially revert r17179
+	  
+	  It changed the behaviour of _postgis_pgsql_version
+	  Now uses the appropiate 5-6 digit version from server_version_num
+	  
+	  References #4296
+	  References #4303
+
+2019-01-21 19:50  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17198] Sync generated files to parser file
+
+2019-01-21 19:47  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17197] Put fix for parser into y file
+	  References #4273
+
+2019-01-18 20:45  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17187] Avoid final point duplicates for circle stroking
+	  References #4283
+
+2019-01-18 18:03  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17183] Geodetic tolerance issue in 32-bit
+	  References #4298
+
+2019-01-18 17:24  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17179] Use `server_version_num` instead of parsing `version()`
+	  
+	  References #4296
+
+2019-01-18 16:06  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17176] Avoid passing a NULL pointer to GEOSisEmpty
+	  
+	  References #4275
+
+2019-01-18 11:56  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17171] Correct issue reference from previous commit
+	  
+	  References #4289
+
+2019-01-18 11:52  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17169] ST_AsMVTGeom: Transform coordinates space before
+	  clipping
+	  
+	  References #4300
+
+2019-01-11 21:46  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17141] More robust geography distance
+	  References #4290
+
+2019-01-11 13:50  Raúl Marín Rodríguez <rmrodriguez at carto.com>
+
+	* [r17136] ST_AsMVT: parse JSON numeric values with decimals as
+	  doubles
+	  
+	  Closes #4292
+
+2019-01-10 18:21  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17133] Fix memory leak in case where valid WKT is
+	  followed by garbage content
+	  Closes #4273
+
+2019-01-09 20:34  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17130] Tighter parsing of WKT
+	  References #4273
+
+2018-12-26 04:08  Regina Obe <lr at pcorp.us>
+
+	* [r17120] Fix so custom --with-projdir= configure switch works
+	  again.
+	  References #4279 for PostGIS 2.4
+
+2018-12-17 10:38  Darafei Praliaskouski <me at komzpa.net>
+
+	* [r17110] Support Proj 6. Support is via legacy API.
+	  
+	  Closes #4254
+	  Closes https://github.com/postgis/postgis/pull/354
+
+2018-11-27 00:15  Paul Ramsey <pramsey at cleverelephant.ca>
+
+	* [r17079] Change test conditions to explicit empty test
+	  References #4245
+
+2018-11-25 19:32  Darafei Praliaskouski <me at komzpa.net>
+
+	* [r17075] Stabilize GiST ND indexes for mixed dimensions
+	  
+	  Patch by Darafei Praliaskouski
+	  
+	  Thanks to
+	  Arthur Lesuisse for synthesizing test case,
+	  Andrew Gierth for finding runaway memcpy,
+	  Raúl Marín for pointing to memory problem in index construction.
+	  
+	  Closes #4139
+
+2018-11-24 05:35  Regina Obe <lr at pcorp.us>
+
+	* [r17069] Flip to 2.4.7dev
+
+2018-11-24 05:31  Regina Obe <lr at pcorp.us>
+
+	* [r17067] Prepping for 2.4.6 release and update docs to reflect
+	  2.4 only supported up to PostgreSQL 10
+
 2018-11-22 16:15  Raúl Marín Rodríguez <rmrodriguez at carto.com>
 
 	* [r17057] Avoid unaligned memory access in BOX2D_out

Modified: branches/2.4/NEWS
===================================================================
--- branches/2.4/NEWS	2019-03-11 12:40:21 UTC (rev 17323)
+++ branches/2.4/NEWS	2019-03-11 14:22:26 UTC (rev 17324)
@@ -1,5 +1,5 @@
 PostGIS 2.4.7
-2019/xx/xx
+2019/03/11
 
   * Bug Fixes and Enhancements *
 
@@ -18,6 +18,7 @@
   - #4283, Avoid final point duplicates for circle stroking (Paul Ramsey)
   - #4313, #4307, PostgreSQL 12 compatibility (Laurenz Albe, Raúl Marín)
   - #4290, Schema qualify geometry casts in raster functions (Regina Obe)
+  - #4086, Constraint violation loading tiger_data (zcta5 geometry type) (Regina Obe)
 
 PostGIS 2.4.6
 2018/11/24

Modified: branches/2.4/README.postgis
===================================================================
--- branches/2.4/README.postgis	2019-03-11 12:40:21 UTC (rev 17323)
+++ branches/2.4/README.postgis	2019-03-11 14:22:26 UTC (rev 17324)
@@ -1,8 +1,8 @@
 PostGIS - Geographic Information Systems Extensions to PostgreSQL
 =================================================================
 
-:Version: 2.4.6
-:Date: 2018-11-24
+:Version: 2.4.7
+:Date: 2019-03-11
 :Website: http://postgis.net
 
 This distribution contains a module which implements GIS simple features, ties

Modified: branches/2.4/doc/release_notes.xml
===================================================================
--- branches/2.4/doc/release_notes.xml	2019-03-11 12:40:21 UTC (rev 17323)
+++ branches/2.4/doc/release_notes.xml	2019-03-11 14:22:26 UTC (rev 17324)
@@ -3,6 +3,29 @@
   <title>Appendix</title>
     <subtitle>Release Notes</subtitle>
     <sect1>
+      <title>Release 2.4.7</title>
+      <para>Release date: 2019/03/11</para>
+      <para>This is a bug fix and performance improvement release.</para>
+      <simplesect><title>Bug Fixes and Enhancements</title>
+        <para>#4139, Make mixed-dimension ND index build tree correctly.
+          WARNING: REINDEX your ND index on tables that have records with different M/Z
+                dimensions for &&& operator to work predictably.
+                (Darafei Praliaskouski, Arthur Lesuisse, Andrew Gierth, Raúl Marín)</para>
+        <para>#4273, Tighter parsing of WKT (Paul Ramsey)</para>
+        <para>#4267, Enable Proj 6 deprecated APIs (Darafei Praliaskouski, Raúl Marín)</para>
+        <para>#4290, More robust distance calculations in geography (Paul Ramsey)</para>
+        <para>#4292, ST_AsMVT: parse JSON numeric values with decimals as doubles (Raúl Marín)</para>
+        <para>#4289, ST_AsMVTGeom: Transform coordinates space before clipping (Raúl Marín)</para>
+        <para>#4275, Avoid passing a NULL pointer to GEOSisEmpty (Raúl Marín)</para>
+        <para>#4296, Use `server_version_num` instead of parsing `version()` (Raúl Marín)</para>
+        <para>#4298, Geodetic tolerance issue in 32-bit (Paul Ramsey)</para>
+        <para>#4283, Avoid final point duplicates for circle stroking (Paul Ramsey)</para>
+        <para>#4313, #4307, PostgreSQL 12 compatibility (Laurenz Albe, Raúl Marín)</para>
+        <para>#4290, Schema qualify geometry casts in raster functions (Regina Obe)</para>
+        <para>#4086, Constraint violation loading tiger_data (zcta5 geometry type) (Regina Obe)</para>
+      </simplesect>
+    </sect1>
+    <sect1>
       <title>Release 2.4.6</title>
       <para>Release date: 2018/11/24</para>
       <para>This is a bug fix and performance improvement release.</para>

Modified: branches/2.4/extensions/upgradeable_versions.mk
===================================================================
--- branches/2.4/extensions/upgradeable_versions.mk	2019-03-11 12:40:21 UTC (rev 17323)
+++ branches/2.4/extensions/upgradeable_versions.mk	2019-03-11 14:22:26 UTC (rev 17324)
@@ -35,6 +35,7 @@
 	2.3.6 \
 	2.3.7 \
 	2.3.8 \
+	2.3.9 \
 	2.4.0 \
 	2.4.1 \
 	2.4.2 \
@@ -41,5 +42,6 @@
 	2.4.3 \
 	2.4.4 \
 	2.4.5 \
-	2.4.6
+	2.4.6 \
+	2.4.7dev
 

Modified: branches/2.4/extras/tiger_geocoder/tables/lookup_tables_2011.sql
===================================================================
--- branches/2.4/extras/tiger_geocoder/tables/lookup_tables_2011.sql	2019-03-11 12:40:21 UTC (rev 17323)
+++ branches/2.4/extras/tiger_geocoder/tables/lookup_tables_2011.sql	2019-03-11 14:22:26 UTC (rev 17324)
@@ -1333,7 +1333,6 @@
   the_geom geometry,
   CONSTRAINT uidx_tiger_zcta5_gid UNIQUE (gid),
   CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
-  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL),
   CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4269),
   CONSTRAINT pk_tiger_zcta5_zcta5ce PRIMARY KEY (zcta5ce,statefp)
  );



More information about the postgis-tickets mailing list