[pkgsrc/trunk]: pkgsrc/databases/postgresql-postgis2 postgresql-postgis2: Upd...

[gdt <gdt%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/40e0f3699813
branches:  trunk
changeset: 443689:40e0f3699813
user:      gdt <gdt%pkgsrc.org@localhost>
date:      Sat Dec 19 14:18:24 2020 +0000

description:
postgresql-postgis2: Update to 3.1.0

packaging changes:  PostgresQL 9.5 is no longer supported.

Upstream NEWS:

PostGIS 3.1.0
2020/12/18

This version requires PostgreSQL 9.6 or higher and GEOS 3.6 or higher
Additional features are enabled if you are running GEOS 3.9.

 * Breaking changes *
  - #4737, Bump minimum protobuf-c requirement to 1.1.0 (Raúl Marín)
           The configure step will now fail if the requirement isn't
           met or explicitly disabled (--without-protobuf)
  - #4258, Separated postgis_sfcgal from postgis
           into its own lib file and extension (Regina Obe)
  - #4577, Drop support for PostgreSQL 9.5 (Raúl Marín)
  - #4601, ST_TileEnvelope signature changed.
  - #3057, ST_Force3D, ST_Force3DZ, ST_Force3DM and ST_Force4D signatures changed.

* Deprecated signatures *
  - Function postgis_svn_version() replaced by postgis_lib_revision()
    (Sandro Santilli)
  - #4214, Deprecated ST_Count(tablename,...), ST_ApproxCount(tablename, ...)
           ST_SummaryStats(tablename, ..),
           ST_Histogram(tablename, ...), ST_ApproxHistogram(tablename, ...),
           ST_Quantile(tablename, ...), ST_ApproxQuantile(tablename, ...) removed.
           (Darafei Praliaskouski)

 * New features*
  - #4687, (GEOS 3.9+) MaximumInscribedCircle (Paul Ramsey)
  - (GEOS 3.9+) Optional gridSize parameter to ST_Union, ST_UnaryUnion,
           ST_Difference, ST_Intersection, ST_SymDifference, ST_Subdivide
           for overlay with exact tolerance (Sandro Santilli)
  - #4624, ST_HexagonGrid and ST_SquareGrid, set returning functions to
           generate tilings of the plane (Paul Ramsey)
  - #4624, ST_Hexagon and ST_Square, shape generators (Paul Ramsey)
  - #4804, (GEOS 3.9+) ST_ReducePrecision allows valid precision reduction
           (Paul Ramsey)
  - #4710, ST_ClusterKMeans now works with 3D geometries (Darafei Praliaskouski)
  - #4801, ST_ClusterKMeans supports weights in POINT[Z]M geometries
           (Darafei Praliaskouski)
  - #4805, _ST_SortableHash exposed to work around parallel soring performance issue
           in Postgres. If your table is huge, use ORDER BY _ST_SortableHash(geom)
           instead of ORDER BY geom to make parallel sort faster (Darafei Praliaskouski)
  - #4625, Correlation statistics now calculated.
           Run ANALYZE for BRIN indexes to start kicking in.
           (Darafei Praliaskouski)
  - #4698, Add a precision parameter to ST_AsEWKT (Raúl Marín)

 * Enhancements *
  - #4789, Sped up TopoJSON output for areal TopoGeometry with
           many holes (Sandro Santilli)
  - #4758, Improved topology noding robustness (Sandro Santilli)
  - Make ST_Subdivide interruptable (Sandro Santilli)
  - #4660, Changes in double / coordinate printing (Raúl Marín)
         - Use the shortest representation (enough to guarantee roundtrip).
         - Uses scientific notation for absolute numbers smaller than 1e-8.
           The previous behaviour was to output 0 for absolute values smaller than
           1e-12 and fixed notation for anything bigger than that.
         - Uses scientific notation for absolute numbers greater than 1e+15
           (same behaviour).
         - The precision parameter now also affects the scientific notation
           (before it was fixed [5-8]).
         - All output functions now respect the requested precision (without
           any limits).
         - The default precision is the same (9 for GeoJSON, 15 for everything else).
  - #4746, Micro optimizations to the serialization process (Raúl Marín)
  - #4623, Optimize varlena returning functions (Raúl Marín)
  - #4615, Speed up geojson output (Raúl Marín)
  - #4737, Improve performance and reduce memory usage in ST_AsMVT, especially in
           queries involving parallelism (Raúl Marín)
  - #4719, Fail fast when srids don't match ST_Intersection(geometry,raster)
           Also schema qualify calls in function. (Regina Obe)
  - #4784, Add ST_CollectionExtract(geometry) with default behaviour of
           extracting the components of highest coordinate dimension. (Paul Ramsey)
  - #4675, topology.GetRingEdges now implemented in C (Sandro Santilli)
  - #4672, Cache getSRSbySRID and getSRIDbySRS for better performance (Raúl Marín)
  - #4676, #4657 Avoid decompressing toasted geometries to read only the header
           (Raúl Marín)
  - #4677, Share gserialized objects between different cache types (Raúl Marín)
  - #4601, Add ST_TileEnvelope margin argument (Yuri Astrakhan)
  - #2972, Add quiet mode (-q) to pgsql2shp (Kristian Thy)
  - #3057, Optional value params for Force3D*, Force4D functions (Kristian Thy)
  - #4569, Allow unknown SRID geometry insertion into typmod SRID column (Paul Ramsey)
  - #4149, ST_Simplify(geom, 0) is now O(N).
           ST_Affine (ST_Translate, ST_TransScale, ST_Rotate) optimized.
           ST_SnapToGrid optimized. (Darafei Praliaskouski)
  - #4656, Cast a geojson_text::geometry for implicit GeoJSON ingestion (Raúl Marín)

diffstat:

 databases/postgresql-postgis2/Makefile |   8 +++++---
 databases/postgresql-postgis2/PLIST    |  20 +++++++++++++++++---
 databases/postgresql-postgis2/distinfo |  10 +++++-----
 3 files changed, 27 insertions(+), 11 deletions(-)

diffs (124 lines):

diff -r d56c3340da6d -r 40e0f3699813 databases/postgresql-postgis2/Makefile
--- a/databases/postgresql-postgis2/Makefile    Sat Dec 19 14:17:39 2020 +0000
+++ b/databases/postgresql-postgis2/Makefile    Sat Dec 19 14:18:24 2020 +0000
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.85 2020/12/04 04:55:42 riastradh Exp $
+# $NetBSD: Makefile,v 1.86 2020/12/19 14:18:24 gdt Exp $
 
 # Note that the directory is still postgis2, for historical reasons.
 # It remains, due to inertia, until there is a good basis to be sure
 # no other changes will be needed.
-MAJOR=         3.0
-DISTNAME=      postgis-${MAJOR}.3
+MAJOR=         3.1
+DISTNAME=      postgis-${MAJOR}.0
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 PKGREVISION=   1
 CATEGORIES=    databases geography
@@ -16,7 +16,9 @@
 
 LICENSE=       gnu-gpl-v2
 
+PGSQL_VERSIONS_ACCEPTED?=      13 12 11 10 96
 DEPENDS+=              postgresql${PGSQL_VERSION}-server-[0-9]*:../../databases/postgresql${PGSQL_VERSION}-server
+
 BUILD_DEPENDS+=                docbook-xsl-[0-9]*:../../textproc/docbook-xsl
 
 CONFLICTS=             postgis-[0-9]*
diff -r d56c3340da6d -r 40e0f3699813 databases/postgresql-postgis2/PLIST
--- a/databases/postgresql-postgis2/PLIST       Sat Dec 19 14:17:39 2020 +0000
+++ b/databases/postgresql-postgis2/PLIST       Sat Dec 19 14:18:24 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.21 2020/11/25 01:04:53 gdt Exp $
+@comment $NetBSD: PLIST,v 1.22 2020/12/19 14:18:24 gdt Exp $
 bin/pgsql2shp
 bin/raster2pgsql
 bin/shp2pgsql
@@ -10,13 +10,11 @@
 share/postgresql/contrib/postgis-${MAJOR}/legacy_minimal.sql
 share/postgresql/contrib/postgis-${MAJOR}/postgis.sql
 share/postgresql/contrib/postgis-${MAJOR}/postgis_comments.sql
-share/postgresql/contrib/postgis-${MAJOR}/postgis_proc_set_search_path.sql
 share/postgresql/contrib/postgis-${MAJOR}/postgis_restore.pl
 share/postgresql/contrib/postgis-${MAJOR}/postgis_upgrade.sql
 share/postgresql/contrib/postgis-${MAJOR}/raster_comments.sql
 share/postgresql/contrib/postgis-${MAJOR}/rtpostgis.sql
 share/postgresql/contrib/postgis-${MAJOR}/rtpostgis_legacy.sql
-share/postgresql/contrib/postgis-${MAJOR}/rtpostgis_proc_set_search_path.sql
 share/postgresql/contrib/postgis-${MAJOR}/rtpostgis_upgrade.sql
 share/postgresql/contrib/postgis-${MAJOR}/sfcgal_comments.sql
 share/postgresql/contrib/postgis-${MAJOR}/spatial_ref_sys.sql
@@ -85,11 +83,16 @@
 share/postgresql/extension/postgis--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.0.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis--${PKGVERSION}--${PKGVERSION}.sql
 share/postgresql/extension/postgis--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis--${PKGVERSION}.sql
+share/postgresql/extension/postgis--${PKGVERSION}dev--${PKGVERSION}.sql
 share/postgresql/extension/postgis--${PKGVERSION}next--${PKGVERSION}.sql
 share/postgresql/extension/postgis--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis--unpackaged--${PKGVERSION}.sql
+share/postgresql/extension/postgis--unpackaged.sql
 share/postgresql/extension/postgis.control
 share/postgresql/extension/postgis_raster--2.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--2.0.1--${PKGVERSION}.sql
@@ -149,11 +152,15 @@
 share/postgresql/extension/postgis_raster--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.0.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--${PKGVERSION}--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--${PKGVERSION}dev--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}next--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--unpackaged--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--unpackaged.sql
 share/postgresql/extension/postgis_raster.control
 share/postgresql/extension/postgis_tiger_geocoder--2.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--2.0.1--${PKGVERSION}.sql
@@ -213,8 +220,11 @@
 share/postgresql/extension/postgis_tiger_geocoder--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.0.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}dev--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}next--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--unpackaged--${PKGVERSION}.sql
@@ -277,9 +287,13 @@
 share/postgresql/extension/postgis_topology--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.0.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--${PKGVERSION}--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--${PKGVERSION}dev--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}next--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--unpackaged--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--unpackaged.sql
 share/postgresql/extension/postgis_topology.control
diff -r d56c3340da6d -r 40e0f3699813 databases/postgresql-postgis2/distinfo
--- a/databases/postgresql-postgis2/distinfo    Sat Dec 19 14:17:39 2020 +0000
+++ b/databases/postgresql-postgis2/distinfo    Sat Dec 19 14:18:24 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.22 2020/11/25 01:04:53 gdt Exp $
+$NetBSD: distinfo,v 1.23 2020/12/19 14:18:24 gdt Exp $
 
-SHA1 (postgis-3.0.3.tar.gz) = f5b17388839eb5fc296efdc776c201c353414087
-RMD160 (postgis-3.0.3.tar.gz) = 39c8a4d8bbaba127223ff19a9ebe2b08a3b3c0d2
-SHA512 (postgis-3.0.3.tar.gz) = 478f0971e18c2a1bd651c9bf7b995236aad32fda037762505cf8ac9e67a4e40917436248c1e62827a1a6da96c15c4ae8d0b606d548fa080cdff453642b897115
-Size (postgis-3.0.3.tar.gz) = 16871696 bytes
+SHA1 (postgis-3.1.0.tar.gz) = e6edd1ed970072c85c5d5f30cee0bb979bc3a392
+RMD160 (postgis-3.1.0.tar.gz) = 8980425d3a811ac3e47ee399b46989a81a380232
+SHA512 (postgis-3.1.0.tar.gz) = c5b063ff7cbe855ab6ce4104d170b27eea04ae632fd6fcb8de38b14699296a8e0c9ce06bfb48ab14cba51b7a1b3f7e0a3996d9377a954dfc39fd68fe3f839e8f
+Size (postgis-3.1.0.tar.gz) = 17262134 bytes