[postgis-tickets] [SCM] PostGIS branch stable-3.1 updated. 3.1.4-29-gc60e4e375
git at osgeo.org
git at osgeo.org
Mon Jan 31 22:57:45 PST 2022
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, stable-3.1 has been updated
via c60e4e3753591f4b561b8a52d9347cb1000547f2 (commit)
via ebffbef5dbe477f48eaf2e80a99a90ec465dd6fd (commit)
from 2d3e08b932441173069ccc2e99a8e689f740cfce (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit c60e4e3753591f4b561b8a52d9347cb1000547f2
Author: Regina Obe <lr at pcorp.us>
Date: Tue Feb 1 01:57:24 2022 -0500
Prep for 3.1.5 release
diff --git a/NEWS b/NEWS
index a3d7a487f..03ffdfa69 100644
--- a/NEWS
+++ b/NEWS
@@ -1,5 +1,5 @@
PostGIS 3.1.5
-2022/02/XX
+2022/02/01
* Bug Fixes
- #4994, Random missing INSERT in shp2pgsql (Sandro Santilli)
@@ -13,7 +13,7 @@ PostGIS 3.1.5
- #5069, search_path vulnerabilty during install/upgrade
(Regina Obe)
- #5041, postgis_tiger_geocoder: loader_generate_script
- generates script with invalid syntax(Regna Obe)
+ generates script with invalid syntax (Regna Obe)
PostGIS 3.1.4
2021/09/04
diff --git a/README.postgis b/README.postgis
index bb9515d93..80d133ff5 100644
--- a/README.postgis
+++ b/README.postgis
@@ -1,8 +1,8 @@
PostGIS - Geographic Information Systems Extensions to PostgreSQL
=================================================================
-:Version: 3.1.4
-:Date: 2021-09-04
+:Version: 3.1.5
+:Date: 2022-02-01
:Website: https://postgis.net
This distribution contains a module which implements GIS simple features, ties
diff --git a/Version.config b/Version.config
index 0acb215a2..1918f2027 100644
--- a/Version.config
+++ b/Version.config
@@ -5,7 +5,7 @@
POSTGIS_MAJOR_VERSION=3
POSTGIS_MINOR_VERSION=1
-POSTGIS_MICRO_VERSION=5dev
+POSTGIS_MICRO_VERSION=5
# Liblwgeom interface versioning, reset to 0:0:0 (cur:age:rev)
# when changing POSTGIS_MINOR_VERSION
diff --git a/doc/release_notes.xml b/doc/release_notes.xml
index 3230849d5..a36b34e42 100644
--- a/doc/release_notes.xml
+++ b/doc/release_notes.xml
@@ -3,6 +3,26 @@
<title>Appendix</title>
<subtitle>Release Notes</subtitle>
+ <sect1>
+ <title>Release 3.1.5</title>
+ <simplesect>
+ <title>Bug Fixes</title>
+ <para>Release date: 2022/02/01</para>
+ <para>#4994, Random missing INSERT in shp2pgsql (Sandro Santilli)</para>
+ <para>#5016, loader (shp2pgsq): Respect LDFLAGS (Greg Troxel)</para>
+ <para>#5018, pgsql2shp basic support for WITH CTE clause (Regina Obe)</para>
+ <para>#5026, fix DropTopology in presence of UPDATE triggers on
+ topology layers (Sandro Santilli)</para>
+ <para>#5033, #5035, allow upgrades in presence of views using deprecated
+ functions (Sandro Santilli)</para>
+ <para>#5046, Fix upgrades in absence of old library (Sandro Santilli)</para>
+ <para>#5069, search_path vulnerabilty during install/upgrade
+ (Regina Obe)</para>
+ <para>#5041, postgis_tiger_geocoder: loader_generate_script
+ generates script with invalid syntax (Regna Obe)</para>
+ </simplesect>
+ </sect1>
+
<sect1>
<title>Release 3.1.4</title>
<simplesect>
diff --git a/extensions/upgradeable_versions.mk b/extensions/upgradeable_versions.mk
index a2ffd5505..66b91c9b3 100644
--- a/extensions/upgradeable_versions.mk
+++ b/extensions/upgradeable_versions.mk
@@ -48,19 +48,23 @@ UPGRADEABLE_VERSIONS = \
2.4.7 \
2.4.8 \
2.4.9 \
+ 2.4.10 \
2.5.0 \
2.5.1 \
2.5.2 \
2.5.3 \
2.5.4 \
2.5.5 \
+ 2.5.6 \
3.0.0 \
3.0.1 \
3.0.2 \
3.0.3 \
3.0.4 \
+ 3.0.5 \
3.1.0 \
3.1.1 \
3.1.2 \
3.1.3 \
- 3.1.4
+ 3.1.4 \
+ 3.1.5dev
commit ebffbef5dbe477f48eaf2e80a99a90ec465dd6fd
Author: Regina Obe <lr at pcorp.us>
Date: Tue Feb 1 01:41:30 2022 -0500
Fix invalid insert for tract. References #5041 for PostGIS 3.1.5
diff --git a/NEWS b/NEWS
index d7566a751..a3d7a487f 100644
--- a/NEWS
+++ b/NEWS
@@ -12,6 +12,8 @@ PostGIS 3.1.5
- #5046, Fix upgrades in absence of old library (Sandro Santilli)
- #5069, search_path vulnerabilty during install/upgrade
(Regina Obe)
+ - #5041, postgis_tiger_geocoder: loader_generate_script
+ generates script with invalid syntax(Regna Obe)
PostGIS 3.1.4
2021/09/04
diff --git a/extras/tiger_geocoder/tiger_loader_2020.sql b/extras/tiger_geocoder/tiger_loader_2020.sql
index cee723015..2343fe15c 100644
--- a/extras/tiger_geocoder/tiger_loader_2020.sql
+++ b/extras/tiger_geocoder/tiger_loader_2020.sql
@@ -275,9 +275,8 @@ COMMENT ON COLUMN loader_lookuptables.website_root_override IS 'Path to use for
INSERT INTO loader_lookuptables(process_order, lookup_name, table_name, load, level_county, level_state, single_geom_mode, insert_mode, pre_load_process, post_load_process, columns_exclude )
VALUES(10, 'tract', 'tract', true, false, true,false, 'c',
'${psql} -c "CREATE TABLE ${data_schema}.${state_abbrev}_${lookup_name}(CONSTRAINT pk_${state_abbrev}_${lookup_name} PRIMARY KEY (tract_id) ) INHERITS(tiger.${lookup_name}); " ',
- '${psql} -c "ALTER TABLE ${staging_schema}.${state_abbrev}_${table_name} RENAME geoid IF EXISTS TO tract_id;
- ALTER TABLE ${staging_schema}.${state_abbrev}_${table_name} RENAME geoid10 IF EXISTS TO tract_id;
- SELECT loader_load_staged_data(lower(''${state_abbrev}_${table_name}''), lower(''${state_abbrev}_${lookup_name}'')); "
+ '${psql} -c "ALTER TABLE ${staging_schema}.${state_abbrev}_${table_name} RENAME geoid TO tract_id;"
+ ${psql} -c "SELECT loader_load_staged_data(lower(''${state_abbrev}_${table_name}''), lower(''${state_abbrev}_${lookup_name}'')); "
${psql} -c "CREATE INDEX ${data_schema}_${state_abbrev}_${lookup_name}_the_geom_gist ON ${data_schema}.${state_abbrev}_${lookup_name} USING gist(the_geom);"
${psql} -c "VACUUM ANALYZE ${data_schema}.${state_abbrev}_${lookup_name};"
${psql} -c "ALTER TABLE ${data_schema}.${state_abbrev}_${lookup_name} ADD CONSTRAINT chk_statefp CHECK (statefp = ''${state_fips}'');"', ARRAY['gid']);
-----------------------------------------------------------------------
Summary of changes:
NEWS | 4 +++-
README.postgis | 4 ++--
Version.config | 2 +-
doc/release_notes.xml | 20 ++++++++++++++++++++
extensions/upgradeable_versions.mk | 6 +++++-
extras/tiger_geocoder/tiger_loader_2020.sql | 5 ++---
6 files changed, 33 insertions(+), 8 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list