From 6c19cd8ce363abd9d760693d8f32ee4a09d6da90 Mon Sep 17 00:00:00 2001 From: Craig Ringer Date: Fri, 10 Jul 2015 09:51:11 +0800 Subject: [PATCH] Support for upgrading from 0.9.2.0 --- .gitignore | 2 +- Makefile.in | 7 +++++++ extsql/bdr--0.9.1.0--0.9.2.0.sql | 15 +++++++++++++++ extsql/bdr--0.9.2.0--0.10.0.0.sql | 2 ++ 4 files changed, 25 insertions(+), 1 deletion(-) create mode 100644 extsql/bdr--0.9.1.0--0.9.2.0.sql create mode 100644 extsql/bdr--0.9.2.0--0.10.0.0.sql diff --git a/.gitignore b/.gitignore index 7f595ef3df..3ca9f06d56 100644 --- a/.gitignore +++ b/.gitignore @@ -48,7 +48,7 @@ lib*.pc /run_tests /config.log /config.status -/extsql/bdr--0.[89].0.?.sql +/extsql/bdr--0.[89].?.?.sql /extsql/bdr--0.1?.0.?.sql /Makefile.global /doc/Makefile diff --git a/Makefile.in b/Makefile.in index 1bfc310803..a394d70a82 100644 --- a/Makefile.in +++ b/Makefile.in @@ -29,7 +29,9 @@ DATA = \ extsql/bdr--0.9.0.4--0.10.0.0.sql \ extsql/bdr--0.9.0.5--0.10.0.0.sql \ extsql/bdr--0.9.0.5--0.9.1.0.sql \ + extsql/bdr--0.9.1.0--0.9.2.0.sql \ extsql/bdr--0.9.1.0--0.10.0.0.sql \ + extsql/bdr--0.9.2.0--0.10.0.0.sql \ extsql/bdr--0.10.0.0--0.10.0.1.sql \ extsql/bdr--0.10.0.1--0.10.0.2.sql \ extsql/bdr--0.10.0.2--0.10.0.3.sql \ @@ -52,6 +54,7 @@ DATA_built = \ extsql/bdr--0.9.0.4.sql \ extsql/bdr--0.9.0.5.sql \ extsql/bdr--0.9.1.0.sql \ + extsql/bdr--0.9.2.0.sql \ extsql/bdr--0.10.0.0.sql \ extsql/bdr--0.10.0.1.sql \ extsql/bdr--0.10.0.2.sql \ @@ -211,6 +214,10 @@ extsql/bdr--0.9.1.0.sql: extsql/bdr--0.9.0.5.sql extsql/bdr--0.9.0.5--0.9.1.0.sq mkdir -p extsql cat $^ > $@ +extsql/bdr--0.9.2.0.sql: extsql/bdr--0.9.1.0.sql extsql/bdr--0.9.1.0--0.9.2.0.sql + mkdir -p extsql + cat $^ > $@ + extsql/bdr--0.10.0.4.sql: extsql/bdr--0.10.0.3.sql extsql/bdr--0.10.0.3--0.10.0.4.sql mkdir -p extsql cat $^ > $@ diff --git a/extsql/bdr--0.9.1.0--0.9.2.0.sql b/extsql/bdr--0.9.1.0--0.9.2.0.sql new file mode 100644 index 0000000000..f870764cf6 --- /dev/null +++ b/extsql/bdr--0.9.1.0--0.9.2.0.sql @@ -0,0 +1,15 @@ +SET LOCAL search_path = bdr; +SET bdr.permit_unsafe_ddl_commands = true; +SET bdr.skip_ddl_replication = true; + +-- +-- This is the same file as extsql/bdr--0.10.0.5--0.10.0.6.sql +-- in 0.10.0. It's safe to run twice. +-- + +CREATE OR REPLACE FUNCTION bdr.bdr_internal_sequence_reset_cache(seq regclass) +RETURNS void LANGUAGE c AS 'MODULE_PATHNAME' STRICT; + +RESET bdr.permit_unsafe_ddl_commands; +RESET bdr.skip_ddl_replication; +RESET search_path; diff --git a/extsql/bdr--0.9.2.0--0.10.0.0.sql b/extsql/bdr--0.9.2.0--0.10.0.0.sql new file mode 100644 index 0000000000..3cb0082504 --- /dev/null +++ b/extsql/bdr--0.9.2.0--0.10.0.0.sql @@ -0,0 +1,2 @@ +-- This file exists only to tell the extension infrastructure +-- that no changes are required. -- 2.39.5