pgpool2.git / summary / log / commit / refs
commit 06ccffe4bbc1bcd992377ecd09415eeb95f0b08f
Author: Bo Peng <pengbo@sraoss.co.jp>
Date: Tue Sep 18 03:27:45 2018 +0000
Add pgpool_recovery--1.1--1.2.sql file to update pgpool_recovery() function version.
src/Makefile.in | 1 +
src/sql/pgpool-recovery/Makefile | 2 +-
src/sql/pgpool-recovery/pgpool_recovery--1.1--1.2.sql | 9 +++++++++
3 files changed, 11 insertions(+), 1 deletion(-)
diff --git a/src/Makefile.in b/src/Makefile.in
index 5f3447713..f70b4593c 100644
--- a/src/Makefile.in
+++ b/src/Makefile.in
@@ -517,6 +517,7 @@ EXTRA_DIST = sample/pgpool.pam \
sql/pgpool-recovery/pgpool-recovery.sql.in \
sql/pgpool-recovery/uninstall_pgpool-recovery.sql \
sql/pgpool-recovery/pgpool_recovery--1.2.sql \
+ sql/pgpool-recovery/pgpool_recovery--1.1--1.2.sql \
sql/pgpool-recovery/pgpool_recovery--1.1.sql \
sql/pgpool-recovery/pgpool_recovery.control \
sql/pgpool-recovery/Makefile \
diff --git a/src/sql/pgpool-recovery/Makefile b/src/sql/pgpool-recovery/Makefile
index 63b7812ea..510853ee7 100644
--- a/src/sql/pgpool-recovery/Makefile
+++ b/src/sql/pgpool-recovery/Makefile
@@ -3,7 +3,7 @@ DATA_built = pgpool-recovery.sql
DATA = uninstall_pgpool-recovery.sql
EXTENSION = pgpool_recovery
-DATA = pgpool_recovery--1.2.sql
+DATA = pgpool_recovery--1.2.sql pgpool_recovery--1.1--1.2.sql
# if you are using PostgreSQL 8.0 or later,
# using pg_config is recommended.
diff --git a/src/sql/pgpool-recovery/pgpool_recovery--1.1--1.2.sql b/src/sql/pgpool-recovery/pgpool_recovery--1.1--1.2.sql
new file mode 100644
index 000000000..cc550616a
--- /dev/null
+++ b/src/sql/pgpool-recovery/pgpool_recovery--1.1--1.2.sql
@@ -0,0 +1,9 @@
+/* contrib/pgpool_recovery/pgpool_recovery--1.1--1.2.sql */
+
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
+\echo Use "ALTER EXTENSION pgpool_recovery UPDATE TO '1.2'" to load this file. \quit
+
+create FUNCTION pgpool_recovery(script_name text, remote_host text, remote_data_directory text, remote_port text, recovery_node integer)
+RETURNS bool
+AS 'MODULE_PATHNAME', 'pgpool_recovery'
+LANGUAGE C STRICT;
[parent: 8e123b622772]