From a56c86807e3aaa4839eb9e11938d63eaf85bd440 Mon Sep 17 00:00:00 2001
From: Marko Kreen <markokr@gmail.com>
Date: Wed, 31 Oct 2012 14:36:06 +0200
Subject: [PATCH] Bump ext ver to 2.5.0, add upgrade scripts

---
 META.json                                     |  4 ++--
 Makefile                                      | 20 +++++++++++++------
 plproxy.control                               |  2 +-
 ...packaged--2.3.0.sql => ext_unpackaged.sql} |  0
 4 files changed, 17 insertions(+), 9 deletions(-)
 rename sql/{plproxy--unpackaged--2.3.0.sql => ext_unpackaged.sql} (100%)

diff --git a/META.json b/META.json
index 8c1159e..671db7d 100644
--- a/META.json
+++ b/META.json
@@ -2,7 +2,7 @@
    "name": "plproxy",
    "abstract": "Database partitioning implemented as procedural language",
    "description": "PL/Proxy is database partitioning system implemented as PL language.",
-   "version": "2.4.0",
+   "version": "2.5.0",
    "maintainer": [
       "Marko Kreen <markokr@gmail.com>"
    ],
@@ -14,7 +14,7 @@
          "abstract": "Database partitioning implemented as procedural language",
          "file": "sql/plproxy.sql",
          "docfile": "doc/tutorial.txt",
-         "version": "2.4.0"
+         "version": "2.5.0"
       }
    },
    "prereqs": {
diff --git a/Makefile b/Makefile
index 8721589..3ccfe1e 100644
--- a/Makefile
+++ b/Makefile
@@ -1,8 +1,9 @@
 EXTENSION  = plproxy
 
 # sync with NEWS, META.json, plproxy.control, debian/changelog
-DISTVERSION = 2.4
-EXTVERSION = 2.4.0
+DISTVERSION = 2.5
+EXTVERSION = 2.5.0
+UPGRADE_VERS = 2.3.0 2.4.0
 
 # set to 1 to disallow functions containing SELECT
 NO_SELECT = 0
@@ -45,9 +46,9 @@ override CONTRIB_TESTDB := regression
 # sql source
 PLPROXY_SQL = sql/plproxy_lang.sql
 # Generated SQL files
-EXTSQL = sql/$(EXTENSION)--$(EXTVERSION).sql
-# Fixed SQL
-EXTMISC = sql/plproxy--unpackaged--2.3.0.sql
+EXTSQL = sql/$(EXTENSION)--$(EXTVERSION).sql \
+	$(foreach v,$(UPGRADE_VERS),sql/plproxy--$(v)--$(EXTVERSION).sql) \
+	sql/plproxy--unpackaged--$(EXTVERSION).sql
 
 # PostgreSQL version
 PGVER = $(shell $(PG_CONFIG) --version | sed 's/PostgreSQL //')
@@ -102,11 +103,18 @@ sql/plproxy.sql: $(PLPROXY_SQL)
 	cat $^ > $@
 
 # plain plproxy.sql is not installed, but used in tests
-$(EXTSQL): $(PLPROXY_SQL)
+sql/$(EXTENSION)--$(EXTVERSION).sql: $(PLPROXY_SQL)
 	@mkdir -p sql
 	echo "create extension plproxy;" > sql/plproxy.sql 
 	cat $^ > $@
 
+$(foreach v,$(UPGRADE_VERS),sql/plproxy--$(v)--$(EXTVERSION).sql):
+	touch $@
+
+sql/plproxy--unpackaged--$(EXTVERSION).sql: sql/ext_unpackaged.sql
+	@mkdir -p sql
+	cat $< > $@
+
 # dependencies
 
 $(OBJS): $(HDRS)
diff --git a/plproxy.control b/plproxy.control
index 38389e0..64b12a3 100644
--- a/plproxy.control
+++ b/plproxy.control
@@ -1,6 +1,6 @@
 # plproxy extension
 comment = 'Database partitioning implemented as procedural language'
-default_version = '2.4.0'
+default_version = '2.5.0'
 module_pathname = '$libdir/plproxy'
 relocatable = false
 # schema = pg_catalog
diff --git a/sql/plproxy--unpackaged--2.3.0.sql b/sql/ext_unpackaged.sql
similarity index 100%
rename from sql/plproxy--unpackaged--2.3.0.sql
rename to sql/ext_unpackaged.sql
-- 
2.39.5