• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revisiona5f9aa7a5cc47181d502cceb787a66468168e39b (tree)
Time2017-02-21 09:34:20
AuthorKyotaro Horiguchi <horiguchi.kyotaro@lab....>
CommiterKyotaro Horiguchi

Log Message

Provide upgrade path from 1.1.3

pg_hint_plan96-1.2.0 has an upgrade path from 1.1.3. This adds
requires installation sql file and puts pointers to the files in
Makefile and spec file. It is the only upgrade path of pg_hint_plan
1.2.0 since it works only on PG9.6 and versions earlier than 1.1.3
don't support PG9.6.

Change Summary

Incremental Difference

--- a/Makefile
+++ b/Makefile
@@ -14,7 +14,7 @@ REGRESSION_EXPECTED = expected/init.out expected/base_plan.out expected/pg_hint_
1414 REGRESS_OPTS = --encoding=UTF8
1515
1616 EXTENSION = pg_hint_plan
17-DATA = pg_hint_plan--1.2.0.sql
17+DATA = pg_hint_plan--1.2.0.sql pg_hint_plan--1.1.3--1.2.0.sql
1818
1919 EXTRA_CLEAN = sql/ut-fdw.sql expected/ut-fdw.out RPMS
2020
--- a/SPECS/pg_hint_plan96.spec
+++ b/SPECS/pg_hint_plan96.spec
@@ -58,6 +58,7 @@ install -d %{buildroot}%{_libdir}
5858 install pg_hint_plan.so %{buildroot}%{_libdir}/pg_hint_plan.so
5959 install -d %{buildroot}%{_datadir}/extension
6060 install -m 644 pg_hint_plan--1.2.0.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.2.0.sql
61+install -m 644 pg_hint_plan--1.1.3--1.2.0.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.3--1.2.0.sql
6162 install -m 644 pg_hint_plan.control %{buildroot}%{_datadir}/extension/pg_hint_plan.control
6263
6364 %clean
@@ -68,6 +69,7 @@ rm -rf %{buildroot}
6869 %{_libdir}/pg_hint_plan.so
6970 %defattr(0644,root,root)
7071 %{_datadir}/extension/pg_hint_plan--1.2.0.sql
72+%{_datadir}/extension/pg_hint_plan--1.1.3--1.2.0.sql
7173 %{_datadir}/extension/pg_hint_plan.control
7274
7375 # History of pg_hint_plan.
--- /dev/null
+++ b/pg_hint_plan--1.1.3--1.2.0.sql
@@ -0,0 +1,6 @@
1+/* pg_hint_plan/pg_hint_plan--1.1.3--1.2.0.sql */
2+
3+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+\echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit
5+
6+-- nothing to do upgrading from 1.1.3.
Show on old repository browser