Prepare RPM build environmnet for Version 1.1

Stored data is backward compatible with 1.0.

Fixed "Original Hash Backets", IO Timings, Sort Keys in text plan
representation.

Fixed text plan representation of "ON CONFLICT", "GROUPING SETS",
"TABLESAMPLE" and multi-targetted ModifyTables, which just were not
shown or looked broken.

diff --git a/Makefile b/Makefile
index 7b46e35..dc5c747 100644 (file)
--- a/Makefile
+++ b/Makefile
@@ -1,13 +1,13 @@
 # pg_stat_plan/Makefile
 
 MODULES = pg_store_plans
-STOREPLANSVER = 1.0
+STOREPLANSVER = 1.1
 
 MODULE_big = pg_store_plans
 OBJS = pg_store_plans.o pgsp_json.o pgsp_json_text.o pgsp_explain.o
 
 EXTENSION = pg_store_plans
-DATA = pg_store_plans--1.0.sql
+DATA = pg_store_plans--1.1.sql pg_store_plans--1.0--1.1.sql
 
 REGRESS = all
 REGRESS_OPTS = --temp-config=regress.conf

diff --git a/SPECS/pg_store_plans94.spec b/SPECS/pg_store_plans94.spec
index 1ab59bc..93f10d5 100644 (file)
--- a/SPECS/pg_store_plans94.spec
+++ b/SPECS/pg_store_plans94.spec
@@ -13,7 +13,7 @@
 ## Set general information for pg_store_plans.
 Summary:    Record executed plans on PostgreSQL 9.4
 Name:       pg_store_plans94
-Version:    1.0
+Version:    1.1
 Release:    1%{?dist}
 License:    BSD
 Group:      Applications/Databases
@@ -56,7 +56,8 @@ rm -rf %{buildroot}
 install -d %{buildroot}%{_libdir}
 install pg_store_plans.so %{buildroot}%{_libdir}/pg_store_plans.so
 install -d %{buildroot}%{_datadir}/extension
-install -m 644 pg_store_plans--1.0.sql %{buildroot}%{_datadir}/extension/pg_store_plans--1.0.sql
+install -m 644 pg_store_plans--1.1.sql %{buildroot}%{_datadir}/extension/pg_store_plans--1.1.sql
+install -m 644 pg_store_plans--1.0--1.1.sql %{buildroot}%{_datadir}/extension/pg_store_plans--1.0--1.1.sql
 install -m 644 pg_store_plans.control %{buildroot}%{_datadir}/extension/pg_store_plans.control
 
 %clean
@@ -66,11 +67,14 @@ rm -rf %{buildroot}
 %defattr(0755,root,root)
 %{_libdir}/pg_store_plans.so
 %defattr(0644,root,root)
-%{_datadir}/extension/pg_store_plans--1.0.sql
+%{_datadir}/extension/pg_store_plans--1.1.sql
+%{_datadir}/extension/pg_store_plans--1.0--1.1.sql
 %{_datadir}/extension/pg_store_plans.control
 
 # History of pg_store_plans.
 %changelog
+* Fri Aug 26 2016 Kyotaro Horiguchi
+- Some fixes in text representaion.
 * Fri Jun 12 2015 Kyotaro Horiguchi
 - Initial version.
 

diff --git a/SPECS/pg_store_plans95.spec b/SPECS/pg_store_plans95.spec
index 0381246..0563497 100644 (file)
--- a/SPECS/pg_store_plans95.spec
+++ b/SPECS/pg_store_plans95.spec
@@ -13,7 +13,7 @@
 ## Set general information for pg_store_plans.
 Summary:    Record executed plans on PostgreSQL 9.5
 Name:       pg_store_plans95
-Version:    1.0
+Version:    1.1
 Release:    1%{?dist}
 License:    BSD
 Group:      Applications/Databases
@@ -56,7 +56,8 @@ rm -rf %{buildroot}
 install -d %{buildroot}%{_libdir}
 install pg_store_plans.so %{buildroot}%{_libdir}/pg_store_plans.so
 install -d %{buildroot}%{_datadir}/extension
-install -m 644 pg_store_plans--1.0.sql %{buildroot}%{_datadir}/extension/pg_store_plans--1.0.sql
+install -m 644 pg_store_plans--1.1.sql %{buildroot}%{_datadir}/extension/pg_store_plans--1.1.sql
+install -m 644 pg_store_plans--1.0--1.1.sql %{buildroot}%{_datadir}/extension/pg_store_plans--1.0--1.1.sql
 install -m 644 pg_store_plans.control %{buildroot}%{_datadir}/extension/pg_store_plans.control
 
 %clean
@@ -66,11 +67,14 @@ rm -rf %{buildroot}
 %defattr(0755,root,root)
 %{_libdir}/pg_store_plans.so
 %defattr(0644,root,root)
-%{_datadir}/extension/pg_store_plans--1.0.sql
+%{_datadir}/extension/pg_store_plans--1.1.sql
+%{_datadir}/extension/pg_store_plans--1.0--1.1.sql
 %{_datadir}/extension/pg_store_plans.control
 
 # History of pg_store_plans.
 %changelog
+* Fri Aug 26 2016 Kyotaro Horiguchi
+- Some fix in plan representation functions.
 * Wed Apr 13 2016 Kyotaro Horiguchi
 - Support PostgreSQL 9.5
 * Fri Jun 12 2015 Kyotaro Horiguchi

diff --git a/pg_store_plans--1.0--1.1.sql b/pg_store_plans--1.0--1.1.sql
new file mode 100644 (file)
index 0000000..d733791
--- /dev/null
+++ b/pg_store_plans--1.0--1.1.sql
@@ -0,0 +1 @@
+-- Nothing to do for SQL definitions as of 1.1

diff --git a/pg_store_plans--1.0.sql b/pg_store_plans--1.1.sql
similarity index 100%
rename from pg_store_plans--1.0.sql
rename to pg_store_plans--1.1.sql

diff --git a/pg_store_plans.control b/pg_store_plans.control
index b9751b6..068fc2c 100644 (file)
--- a/pg_store_plans.control
+++ b/pg_store_plans.control
@@ -1,5 +1,5 @@
 # pg_store_plans extension
 comment = 'track plan statistics of all SQL statements executed'
-default_version = '1.0'
+default_version = '1.1'
 module_pathname = '$libdir/pg_store_plans'
 relocatable = true