pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc/databases/postgresql-postgis2 postgresql-postgis2: Upd...
details: https://anonhg.NetBSD.org/pkgsrc/rev/6fc47a327b41
branches: trunk
changeset: 369898:6fc47a327b41
user: gdt <gdt%pkgsrc.org@localhost>
date: Sat Oct 07 18:39:47 2017 +0000
description:
postgresql-postgis2: Update to 2.4.0
PostGIS 2.4.0
2017/09/30
* New Features *
- #3822, Have postgis_full_version() also show and check version of
PostgreSQL the scripts were built against (Sandro Santilli)
- #2411, curves support in ST_Reverse (Sandro Santilli)
- #2951, ST_Centroid for geography (Danny G?tte)
- #3788, Allow postgis_restore.pl to work on directory-style (-Fd) dumps
(Roger Crew)
- #3772, Direction agnostic ST_CurveToLine output (Sandro Santilli / KKGeo)
- #2464, ST_CurveToLine with MaxError tolerance (Sandro Santilli / KKGeo)
- #3599, Geobuf output support via ST_AsGeobuf (Bj?rn Harrtell)
- #3661, Mapbox vector tile output support via ST_AsMVT (Bj?rn Harrtell / CartoDB)
- #3689, Add orientation checking and forcing functions (Dan Baston)
- #3753, Gist penalty speed improvements for 2D and ND points
(Darafei Praliaskouski, Andrey Borodin)
- #3677, ST_FrechetDistance (Shinichi Sugiyama)
- Most aggregates (raster and geometry),
and all stable / immutable (raster and geometry) marked as parallel safe
- #2249, ST_MakeEmptyCoverage for raster (David Zwarg, ainomieli)
- #3709, Allow signed distance for ST_Project (Darafei Praliaskouski)
- #524, Covers support for polygon on polygon, line on line,
point on line for geography (Danny G?tte)
* Enhancements and Fixes*
- Many corrections to docs and several translations almost complete.
Andreas Schild who provided many corrections to core docs.
PostGIS Japanese translation team first to reach completion of translation.
- Support for PostgreSQL 10
- Preliminary support for PostgreSQL 11
- #3645, Avoid loading logically deleted records from shapefiles
- #3747, Add zip4 and address_alphanumeric as attributes
to norm_addy tiger_geocoder type.
- #3748, address_standardizer lookup tables update
so pagc_normalize_address better standardizes abbreviations
- #3647, better handling of noding in ST_Node using GEOSNode
(Wouter Geraedts)
- #3684, Update to EPSG register v9
(Even Rouault)
- #3830, Fix initialization of incompatible type (>=9.6) address_standardizer
- #3662, Make shp2pgsql work in debug mode by sending debug to stderr
- #3405, Fixed memory leak in lwgeom_to_points
- #3832, Support wide integer fields as int8 in shp2pgsql
- #3841, Deterministic sorting support for empty geometries in btree geography
- #3844, Make = operator a strict equality test, and < > to rough "spatial sorting"
- #3855, ST_AsTWKB memory and speed improvements
* Breaking Changes *
- Dropped support for PostgreSQL 9.2.
- #3810, GEOS 3.4.0 or above minimum required to compile
- Most aggregates now marked as parallel safe,
which means most aggs have to be dropped / recreated.
If you have views that utilize PostGIS aggs,
you'll need to drop before upgrade and recreate after upgrade
- #3578, ST_NumInteriorRings(POLYGON EMPTY) now returns 0 instead of NULL
- _ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0
when ST_DumpPoints got reimplemented in C
- B-Tree index operators < = > changed to provide better spatial locality on sorting
and have expected behavior on GROUP BY.
If you have btree index for geometry or geography, you need to REINDEX it, or review
if it was created by accident and needs to be replaced with GiST index.
If your code relies on old left-to-right box compare ordering,
update it to use << >> operators
PostGIS 2.4.0rc3
2017/09/27
* Fixes and Enhancements since PostGIS 2.4.0rc2 *
- #3781 st_contains cannot handle curvepolygon / compoundcurve
consisting of only straight lines
- #3866 server crashing from large values in ST_AsTWKB
- #3818 Allow triangles unclosed in M to be WKT parsed
- several packaging changes regarding checking trailing blanks
PostGIS 2.4.0rc2
2017/09/24
* Fixes and Enhancements since PostGIS 2.4.0rc1 *
- Numerous fixes to ST_AsMVT, ST_AsGeoBuf
- ST_AsTWKB speed and memory performance enhancments
- ST_RepeatedPoints speed improvements
- ST_ConcaveHull bug fix
See PostGIS 2.4.0 section for details of
new features and enhancements in this release.
PostGIS 2.4.0rc1
2017/09/13
Note possible breaking changes since 2.4.0 beta1 release are:
* Breaking Changes *
- B-Tree index operators < = > changed to provide better spatial locality on sorting
and have expected behavior on GROUP BY.
If you have btree index for geometry or geography, you need to REINDEX it, or review
if it was created by accident and needs to be replaced with GiST index.
If your code relies on old left-to-right box compare ordering,
update it to use << >> operators.
- ST_AsMVT aggregate now overloaded and arg order changed.
Check your code if you are already using this function.
- _ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0
when ST_DumpPoints got reimplemented in C
diffstat:
databases/postgresql-postgis2/Makefile | 5 +-
databases/postgresql-postgis2/PLIST | 81 ++++++---
databases/postgresql-postgis2/distinfo | 13 +-
databases/postgresql-postgis2/patches/patch-extensions_address__standardizer_Makefile.in | 36 ----
databases/postgresql-postgis2/patches/patch-extensions_postgis__topology_Makefile.in | 15 -
databases/postgresql-postgis2/patches/patch-raster_rt__core_librtcore.h | 74 ---------
6 files changed, 58 insertions(+), 166 deletions(-)
diffs (284 lines):
diff -r 39f4d539a0af -r 6fc47a327b41 databases/postgresql-postgis2/Makefile
--- a/databases/postgresql-postgis2/Makefile Sat Oct 07 18:19:21 2017 +0000
+++ b/databases/postgresql-postgis2/Makefile Sat Oct 07 18:39:47 2017 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.30 2017/09/22 17:18:42 gdt Exp $
+# $NetBSD: Makefile,v 1.31 2017/10/07 18:39:47 gdt Exp $
-DISTNAME= postgis-2.3.3
+DISTNAME= postgis-2.4.0
PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME}
-PKGREVISION= 1
CATEGORIES= databases geography
MASTER_SITES= http://download.osgeo.org/postgis/source/
diff -r 39f4d539a0af -r 6fc47a327b41 databases/postgresql-postgis2/PLIST
--- a/databases/postgresql-postgis2/PLIST Sat Oct 07 18:19:21 2017 +0000
+++ b/databases/postgresql-postgis2/PLIST Sat Oct 07 18:39:47 2017 +0000
@@ -1,39 +1,39 @@
-@comment $NetBSD: PLIST,v 1.9 2017/09/02 16:53:29 gdt Exp $
+@comment $NetBSD: PLIST,v 1.10 2017/10/07 18:39:47 gdt Exp $
bin/pgsql2shp
bin/raster2pgsql
bin/shp2pgsql
include/liblwgeom.h
include/liblwgeom_topo.h
lib/liblwgeom.la
-lib/postgresql/postgis-2.3.so
-lib/postgresql/postgis_topology-2.3.so
-lib/postgresql/rtpostgis-2.3.so
-share/postgresql/contrib/postgis-2.3/legacy.sql
-share/postgresql/contrib/postgis-2.3/legacy_gist.sql
-share/postgresql/contrib/postgis-2.3/legacy_minimal.sql
-share/postgresql/contrib/postgis-2.3/postgis.sql
-share/postgresql/contrib/postgis-2.3/postgis_comments.sql
-share/postgresql/contrib/postgis-2.3/postgis_for_extension.sql
-share/postgresql/contrib/postgis-2.3/postgis_proc_set_search_path.sql
-share/postgresql/contrib/postgis-2.3/postgis_restore.pl
-share/postgresql/contrib/postgis-2.3/postgis_upgrade.sql
-share/postgresql/contrib/postgis-2.3/postgis_upgrade_for_extension.sql
-share/postgresql/contrib/postgis-2.3/raster_comments.sql
-share/postgresql/contrib/postgis-2.3/rtpostgis.sql
-share/postgresql/contrib/postgis-2.3/rtpostgis_for_extension.sql
-share/postgresql/contrib/postgis-2.3/rtpostgis_legacy.sql
-share/postgresql/contrib/postgis-2.3/rtpostgis_proc_set_search_path.sql
-share/postgresql/contrib/postgis-2.3/rtpostgis_upgrade.sql
-share/postgresql/contrib/postgis-2.3/rtpostgis_upgrade_for_extension.sql
-share/postgresql/contrib/postgis-2.3/sfcgal_comments.sql
-share/postgresql/contrib/postgis-2.3/spatial_ref_sys.sql
-share/postgresql/contrib/postgis-2.3/topology.sql
-share/postgresql/contrib/postgis-2.3/topology_comments.sql
-share/postgresql/contrib/postgis-2.3/topology_upgrade.sql
-share/postgresql/contrib/postgis-2.3/uninstall_legacy.sql
-share/postgresql/contrib/postgis-2.3/uninstall_postgis.sql
-share/postgresql/contrib/postgis-2.3/uninstall_rtpostgis.sql
-share/postgresql/contrib/postgis-2.3/uninstall_topology.sql
+lib/postgresql/postgis-2.4.so
+lib/postgresql/postgis_topology-2.4.so
+lib/postgresql/rtpostgis-2.4.so
+share/postgresql/contrib/postgis-2.4/legacy.sql
+share/postgresql/contrib/postgis-2.4/legacy_gist.sql
+share/postgresql/contrib/postgis-2.4/legacy_minimal.sql
+share/postgresql/contrib/postgis-2.4/postgis.sql
+share/postgresql/contrib/postgis-2.4/postgis_comments.sql
+share/postgresql/contrib/postgis-2.4/postgis_for_extension.sql
+share/postgresql/contrib/postgis-2.4/postgis_proc_set_search_path.sql
+share/postgresql/contrib/postgis-2.4/postgis_restore.pl
+share/postgresql/contrib/postgis-2.4/postgis_upgrade.sql
+share/postgresql/contrib/postgis-2.4/postgis_upgrade_for_extension.sql
+share/postgresql/contrib/postgis-2.4/raster_comments.sql
+share/postgresql/contrib/postgis-2.4/rtpostgis.sql
+share/postgresql/contrib/postgis-2.4/rtpostgis_for_extension.sql
+share/postgresql/contrib/postgis-2.4/rtpostgis_legacy.sql
+share/postgresql/contrib/postgis-2.4/rtpostgis_proc_set_search_path.sql
+share/postgresql/contrib/postgis-2.4/rtpostgis_upgrade.sql
+share/postgresql/contrib/postgis-2.4/rtpostgis_upgrade_for_extension.sql
+share/postgresql/contrib/postgis-2.4/sfcgal_comments.sql
+share/postgresql/contrib/postgis-2.4/spatial_ref_sys.sql
+share/postgresql/contrib/postgis-2.4/topology.sql
+share/postgresql/contrib/postgis-2.4/topology_comments.sql
+share/postgresql/contrib/postgis-2.4/topology_upgrade.sql
+share/postgresql/contrib/postgis-2.4/uninstall_legacy.sql
+share/postgresql/contrib/postgis-2.4/uninstall_postgis.sql
+share/postgresql/contrib/postgis-2.4/uninstall_rtpostgis.sql
+share/postgresql/contrib/postgis-2.4/uninstall_topology.sql
share/postgresql/extension/postgis--2.0.0--${PKGVERSION}.sql
share/postgresql/extension/postgis--2.0.1--${PKGVERSION}.sql
share/postgresql/extension/postgis--2.0.2--${PKGVERSION}.sql
@@ -61,6 +61,13 @@
share/postgresql/extension/postgis--2.3.0--${PKGVERSION}.sql
share/postgresql/extension/postgis--2.3.1--${PKGVERSION}.sql
share/postgresql/extension/postgis--2.3.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.3.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.4.0dev--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.4.0alpha--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.4.0beta1--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.4.0rc1--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.4.0rc2--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.4.0rc3--${PKGVERSION}.sql
share/postgresql/extension/postgis--${PKGVERSION}--${PKGVERSION}next.sql
share/postgresql/extension/postgis--${PKGVERSION}.sql
share/postgresql/extension/postgis--${PKGVERSION}next--${PKGVERSION}.sql
@@ -93,6 +100,13 @@
share/postgresql/extension/postgis_tiger_geocoder--2.3.0--${PKGVERSION}.sql
share/postgresql/extension/postgis_tiger_geocoder--2.3.1--${PKGVERSION}.sql
share/postgresql/extension/postgis_tiger_geocoder--2.3.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.3.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.4.0dev--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.4.0alpha--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.4.0beta1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.4.0rc1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.4.0rc2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.4.0rc3--${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}next--${PKGVERSION}.sql
@@ -126,6 +140,13 @@
share/postgresql/extension/postgis_topology--2.3.0--${PKGVERSION}.sql
share/postgresql/extension/postgis_topology--2.3.1--${PKGVERSION}.sql
share/postgresql/extension/postgis_topology--2.3.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.3.3--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.4.0dev--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.4.0alpha--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.4.0beta1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.4.0rc1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.4.0rc2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.4.0rc3--${PKGVERSION}.sql
share/postgresql/extension/postgis_topology--${PKGVERSION}--${PKGVERSION}next.sql
share/postgresql/extension/postgis_topology--${PKGVERSION}.sql
share/postgresql/extension/postgis_topology--${PKGVERSION}next--${PKGVERSION}.sql
diff -r 39f4d539a0af -r 6fc47a327b41 databases/postgresql-postgis2/distinfo
--- a/databases/postgresql-postgis2/distinfo Sat Oct 07 18:19:21 2017 +0000
+++ b/databases/postgresql-postgis2/distinfo Sat Oct 07 18:39:47 2017 +0000
@@ -1,9 +1,6 @@
-$NetBSD: distinfo,v 1.11 2017/09/22 17:18:42 gdt Exp $
+$NetBSD: distinfo,v 1.12 2017/10/07 18:39:47 gdt Exp $
-SHA1 (postgis-2.3.3.tar.gz) = 9be0c182bc50a99a89f7190ea9ab5053647c2e2b
-RMD160 (postgis-2.3.3.tar.gz) = 12724a16d41131c322c55fdd40bfc2e6fe0fdd95
-SHA512 (postgis-2.3.3.tar.gz) = c0ec4b4b5c470e5f88d1bb72c528269a0cf954981385580db3333502c2da74e431b5a86e3d6427c839c3d4440122be18a69261c8205aa71c8aa4b790550c5e9c
-Size (postgis-2.3.3.tar.gz) = 11342032 bytes
-SHA1 (patch-extensions_address__standardizer_Makefile.in) = e560e734b3652b5ae4c539af8f077754979f2f29
-SHA1 (patch-extensions_postgis__topology_Makefile.in) = f1095e0a852d746027417d49a0c14bf00a5da00f
-SHA1 (patch-raster_rt__core_librtcore.h) = 4dd79beda6e8213addbe6280e1d1b90d5277e18f
+SHA1 (postgis-2.4.0.tar.gz) = 4782f1d18923604406a4b2b5fe284ebc4e421086
+RMD160 (postgis-2.4.0.tar.gz) = a2a8b9e9007d2386819e639ba86160c554ded42d
+SHA512 (postgis-2.4.0.tar.gz) = 813e8e9feb75b58673afaec2dda3b5d8fc586a0f483c553795c8ae2b917bb67a9741e8c901787a0b914c327848323239346f1d816aa60b47d5a7065596de0067
+Size (postgis-2.4.0.tar.gz) = 12576979 bytes
diff -r 39f4d539a0af -r 6fc47a327b41 databases/postgresql-postgis2/patches/patch-extensions_address__standardizer_Makefile.in
--- a/databases/postgresql-postgis2/patches/patch-extensions_address__standardizer_Makefile.in Sat Oct 07 18:19:21 2017 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,36 +0,0 @@
-$NetBSD: patch-extensions_address__standardizer_Makefile.in,v 1.1 2015/12/15 00:44:40 gdt Exp $
-
-Use perl from autoconf rather than pgxs. Reported upstream.
-
---- extensions/address_standardizer/Makefile.in.orig 2015-08-25 09:44:58.000000000 +0000
-+++ extensions/address_standardizer/Makefile.in
-@@ -66,7 +66,7 @@ PERL=@PERL@
- sql/%.sql: %.sql.in
- mkdir -p sql
- $(SQLPP) -I../libpgcommon $< | grep -v '^#' | \
-- $(PERL) -lpe "s'MODULE_PATHNAME'\$$libdir/${EXTENSION}-${MINORVERSION}'g" > $@
-+ @PERL@ -lpe "s'MODULE_PATHNAME'\$$libdir/${EXTENSION}-${MINORVERSION}'g" > $@
-
- sql/address_standardizer--@POSTGIS_LIB_VERSION@.sql: sql/address_standardizer_types.sql \
- sql/address_standardizer_functions.sql
-@@ -105,16 +105,16 @@ sql/$(EXTENSION)_data_us--$(EXTVERSION)n
- cat $^ > $@
-
- mk-st-regexp: mk-st-regexp.pl
-- $(PERL) -c mk-st-regexp.pl
-+ @PERL@ -c mk-st-regexp.pl
- rm -f mk-st-regexp
-- echo "#! " $(PERL) > mk-st-regexp
-+ echo "#! " @PERL@ > mk-st-regexp
- cat mk-st-regexp.pl >> mk-st-regexp
- chmod ugo+x mk-st-regexp
-
- mk-city-regex: mk-city-regex.pl usps-st-city-name.txt
-- $(PERL) -c mk-city-regex.pl
-+ @PERL@ -c mk-city-regex.pl
- rm -f mk-city-regex
-- echo "#! " $(PERL) > mk-city-regex
-+ echo "#! " @PERL@ > mk-city-regex
- cat mk-city-regex.pl >> mk-city-regex
- chmod ugo+x mk-city-regex
-
diff -r 39f4d539a0af -r 6fc47a327b41 databases/postgresql-postgis2/patches/patch-extensions_postgis__topology_Makefile.in
--- a/databases/postgresql-postgis2/patches/patch-extensions_postgis__topology_Makefile.in Sat Oct 07 18:19:21 2017 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-$NetBSD: patch-extensions_postgis__topology_Makefile.in,v 1.1 2015/12/15 00:44:40 gdt Exp $
-
-Use perl from autoconf rather than pgxs. Reported upstream.
-
---- extensions/postgis_topology/Makefile.in.orig 2014-06-27 07:35:32.000000000 +0000
-+++ extensions/postgis_topology/Makefile.in
-@@ -60,7 +60,7 @@ sql_bits/topology_comments.sql: ../../do
-
- sql/$(EXTENSION)--unpackaged--$(EXTVERSION).sql: ../../topology/topology.sql ../../utils/create_unpackaged.pl
- mkdir -p sql
-- cat $< | $(PERL) ../../utils/create_unpackaged.pl postgis_topology > $@
-+ cat $< | @PERL@ ../../utils/create_unpackaged.pl postgis_topology > $@
-
- #upgrade script should have everything but table, schema, type creation/alter
- #NOTE: we assume all object definitions end in ;
diff -r 39f4d539a0af -r 6fc47a327b41 databases/postgresql-postgis2/patches/patch-raster_rt__core_librtcore.h
--- a/databases/postgresql-postgis2/patches/patch-raster_rt__core_librtcore.h Sat Oct 07 18:19:21 2017 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,74 +0,0 @@
-$NetBSD: patch-raster_rt__core_librtcore.h,v 1.1 2017/09/22 17:18:42 gdt Exp $
-
-Work around configure code that fails to check HAVE_STRNICMP because
-the previous twisty maze of defines do not define UNIX. Complaint
-submitted upstream; this patch would break Windows (which is ok in
-pkgsrc).
-
---- raster/rt_core/librtcore.h.orig 2016-07-04 15:45:56.000000000 +0000
-+++ raster/rt_core/librtcore.h
-@@ -58,61 +58,10 @@
- #ifndef LIBRTCORE_H_INCLUDED
- #define LIBRTCORE_H_INCLUDED
-
--/* define the systems */
--#if defined(__linux__) /* (predefined) */
--#if !defined(LINUX)
--#define LINUX
--#endif
--#if !defined(UNIX)
--#define UNIX /* make sure this is defined */
--#endif
--#endif
--
--
--#if defined(__FreeBSD__) || defined(__FreeBSD_kernel__) || defined(__OpenBSD__) /* seems to work like Linux... */
--#if !defined(LINUX)
--#define LINUX
--#endif
--#if !defined(UNIX)
--#define UNIX /* make sure this is defined */
--#endif
--#endif
--
--#if defined(__GNU__) /* GNU/Hurd is also like Linux */
--#if !defined(LINUX)
--#define LINUX
--#endif
--#if !defined(UNIX)
--#define UNIX /* make sure this is defined */
--#endif
--#endif
--
--#if defined(__MSDOS__)
--#if !defined(MSDOS)
--#define MSDOS /* make sure this is defined */
--#endif
--#endif
--
--#if defined(__WIN32__) || defined(__NT__) || defined(_WIN32)
--#if !defined(WIN32)
--#define WIN32
--#endif
--#if defined(__BORLANDC__) && defined(MSDOS) /* Borland always defines MSDOS */
--#undef MSDOS
--#endif
--#endif
--
--#if defined(__APPLE__)
--#if !defined(UNIX)
-+/* For pkgsrc, assume POSIX. */
-+#ifndef UNIX
- #define UNIX
--#endif
--#endif
--
--#if defined(sun) || defined(__sun)
--#if !defined(UNIX)
--#define UNIX
--#endif
--#endif
-+#endif /* UNIX */
-
- /* if we are in Unix define stricmp to be strcasecmp and strnicmp to */
- /* be strncasecmp. I'm not sure if all Unices have these, but Linux */
Home |
Main Index |
Thread Index |
Old Index