OSDN > Find Software > Use planner hints on PostgreSQL > SCM > git > pg_hint_plan > Commit

Use planner hints on PostgreSQL
Fork

pg_hint_plan: Commit

firtst release

Revision	cdd0824078d233ac42dc62deba45d7e660f96a00 (tree)
Time	2017-07-27 19:16:57
Author	Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
Commiter	Kyotaro Horiguchi

Change version to 1.1.5

1.1.4 has an assertion failure bug raised by DECLARE CURSOR with
enabling table hint. Fixed it.

Addition to that, core.c has been up to date to core.

--- a/Makefile

+++ b/Makefile

		@@ -5,7 +5,7 @@
5	5	#
6	6
7	7	MODULES = pg_hint_plan
8		-HINTPLANVER = 1.1.4
	8	+HINTPLANVER = 1.1.5
9	9
10	10	REGRESS = init base_plan pg_hint_plan ut-init ut-A ut-S ut-J ut-L ut-G ut-R ut-fdw ut-T ut-fini
11	11

		@@ -14,8 +14,8 @@ REGRESSION_EXPECTED = expected/init.out expected/base_plan.out expected/pg_hint_
14	14	REGRESS_OPTS = --encoding=UTF8
15	15
16	16	EXTENSION = pg_hint_plan
17		-DATA = pg_hint_plan--1.1.4.sql pg_hint_plan--1.1.3--1.1.4.sql \
18		- pg_hint_plan--1.1.2--1.1.3.sql
	17	+DATA = pg_hint_plan--1.1.5.sql pg_hint_plan--1.1.3--1.1.4.sql \
	18	+ pg_hint_plan--1.1.4--1.1.5.sql pg_hint_plan--1.1.2--1.1.3.sql
19	19
20	20	EXTRA_CLEAN = sql/ut-fdw.sql expected/ut-fdw.out
21	21

--- a/SPECS/pg_hint_plan93.spec

+++ b/SPECS/pg_hint_plan93.spec

		@@ -13,7 +13,7 @@
13	13	## Set general information for pg_hint_plan.
14	14	Summary: Optimizer hint for PostgreSQL 9.3
15	15	Name: pg_hint_plan93
16		-Version: 1.1.4
	16	+Version: 1.1.5
17	17	Release: 1%{?dist}
18	18	License: BSD
19	19	Group: Applications/Databases

		@@ -60,7 +60,8 @@ rm -rf %{buildroot}
60	60	install -d %{buildroot}%{_libdir}
61	61	install pg_hint_plan.so %{buildroot}%{_libdir}/pg_hint_plan.so
62	62	install -d %{buildroot}%{_datadir}/extension
63		-install -m 644 pg_hint_plan--1.1.4.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.4.sql
	63	+install -m 644 pg_hint_plan--1.1.5.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.5.sql
	64	+install -m 644 pg_hint_plan--1.1.4--1.1.5.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.4--1.1.5.sql
64	65	install -m 644 pg_hint_plan--1.1.3--1.1.4.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.3--1.1.4.sql
65	66	install -m 644 pg_hint_plan--1.1.2--1.1.3.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.2--1.1.3.sql
66	67	install -m 644 pg_hint_plan.control %{buildroot}%{_datadir}/extension/pg_hint_plan.control

		@@ -72,13 +73,16 @@ rm -rf %{buildroot}
72	73	%defattr(0755,root,root)
73	74	%{_libdir}/pg_hint_plan.so
74	75	%defattr(0644,root,root)
75		-%{_datadir}/extension/pg_hint_plan--1.1.4.sql
	76	+%{_datadir}/extension/pg_hint_plan--1.1.5.sql
	77	+%{_datadir}/extension/pg_hint_plan--1.1.4--1.1.5.sql
76	78	%{_datadir}/extension/pg_hint_plan--1.1.3--1.1.4.sql
77	79	%{_datadir}/extension/pg_hint_plan--1.1.2--1.1.3.sql
78	80	%{_datadir}/extension/pg_hint_plan.control
79	81
80	82	# History of pg_hint_plan.
81	83	%changelog
	84	+* Thu Jul 27 2017 Kyotaro Horiguchi
	85	+- Fixed a crash bug.
82	86	* Fri May 19 2017 Kyotaro Horiguchi
83	87	- Fixed a crash bug.
84	88	* Mon Dec 22 2014 Kyotaro Horiguchi

--- /dev/null

+++ b/pg_hint_plan--1.1.4--1.1.5.sql

		@@ -0,0 +1,4 @@
	1	+/* pg_hint_plan/pg_hint_plan--1.1.4-1.1.5.sql */
	2	+
	3	+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
	4	+\echo Use "ALTER EXTENSION pg_hint_plan UPDATE" to load this file. \quit

--- a/pg_hint_plan--1.1.4.sql

+++ b/pg_hint_plan--1.1.5.sql

		@@ -1,4 +1,4 @@
1		-/* pg_hint_plan/pg_hint_plan--1.1.3.sql */
	1	+/* pg_hint_plan/pg_hint_plan--1.1.5.sql */
2	2
3	3	-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4	4	\echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit

--- a/pg_hint_plan.control

+++ b/pg_hint_plan.control