aboutsummaryrefslogtreecommitdiffstats
path: root/main/postgresql/postgresql-contrib.post-upgrade
diff options
context:
space:
mode:
authorJakub Jirutka <jakub@jirutka.cz>2018-02-09 12:39:58 +0100
committerJakub Jirutka <jakub@jirutka.cz>2018-02-09 13:01:36 +0100
commit1540930789e891ee25aa5c2849d92380be163c91 (patch)
tree7d3f3d28612fe74f27c89aa95a69b81206073cc2 /main/postgresql/postgresql-contrib.post-upgrade
parent5f006fb2a05d03b042bf0b3240d2922b43ce1475 (diff)
downloadaports-1540930789e891ee25aa5c2849d92380be163c91.tar.bz2
aports-1540930789e891ee25aa5c2849d92380be163c91.tar.xz
main/postgresql: security upgrade to 10.2
This upgrade contains one incompatible change in contrib/cube (packaged in -contrib subpackage). Explanation from https://www.postgresql.org/docs/10/static/release-10-2.html: > This is an incompatible change, but since the point of the operator > was to be used in KNN searches, it seems rather useless as-is. After > installing this update, any expression indexes or materialized views > using this operator will need to be reindexed/refreshed.
Diffstat (limited to 'main/postgresql/postgresql-contrib.post-upgrade')
-rw-r--r--main/postgresql/postgresql-contrib.post-upgrade16
1 files changed, 16 insertions, 0 deletions
diff --git a/main/postgresql/postgresql-contrib.post-upgrade b/main/postgresql/postgresql-contrib.post-upgrade
new file mode 100644
index 0000000000..c6a8825d90
--- /dev/null
+++ b/main/postgresql/postgresql-contrib.post-upgrade
@@ -0,0 +1,16 @@
+#!/bin/sh
+
+ver_new="$1"
+ver_old="$2"
+
+if [ "$(apk version -t "$ver_old" "10.2-r0")" = "<" ]; then
+ cat >&2 <<-EOF
+ *
+ * If you use contrib/cube's cube ~> int operator, you have to reindex/refresh
+ * all expression indexes and materialized views using this operator.
+ * Read https://www.postgresql.org/docs/10/static/release-10-2.html.
+ *
+ EOF
+fi
+
+exit 0