aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2016-06-09 17:18:18 -0400
committerRobert Haas <rhaas@postgresql.org>2016-06-09 17:18:18 -0400
commit6b3586caa810529635a8f77789d88e957b389469 (patch)
tree496f8f030433cbeceffe01b6c1aebd9a55ffeab6
parent42d4257a069584e205cafcc175f9f6f8d673237c (diff)
downloadpostgresql-6b3586caa810529635a8f77789d88e957b389469.tar.gz
postgresql-6b3586caa810529635a8f77789d88e957b389469.zip
Update pg_prewarm extension for parallel query.
The pg_prewarm function provided by this extension is PARALLEL SAFE. Andreas Karlsson
-rw-r--r--contrib/pg_prewarm/Makefile2
-rw-r--r--contrib/pg_prewarm/pg_prewarm--1.0--1.1.sql6
-rw-r--r--contrib/pg_prewarm/pg_prewarm--1.1.sql (renamed from contrib/pg_prewarm/pg_prewarm--1.0.sql)4
-rw-r--r--contrib/pg_prewarm/pg_prewarm.control2
4 files changed, 10 insertions, 4 deletions
diff --git a/contrib/pg_prewarm/Makefile b/contrib/pg_prewarm/Makefile
index eeba5026724..7ad941e72b9 100644
--- a/contrib/pg_prewarm/Makefile
+++ b/contrib/pg_prewarm/Makefile
@@ -4,7 +4,7 @@ MODULE_big = pg_prewarm
OBJS = pg_prewarm.o $(WIN32RES)
EXTENSION = pg_prewarm
-DATA = pg_prewarm--1.0.sql
+DATA = pg_prewarm--1.1.sql pg_prewarm--1.0--1.1.sql
PGFILEDESC = "pg_prewarm - preload relation data into system buffer cache"
ifdef USE_PGXS
diff --git a/contrib/pg_prewarm/pg_prewarm--1.0--1.1.sql b/contrib/pg_prewarm/pg_prewarm--1.0--1.1.sql
new file mode 100644
index 00000000000..99660548939
--- /dev/null
+++ b/contrib/pg_prewarm/pg_prewarm--1.0--1.1.sql
@@ -0,0 +1,6 @@
+/* contrib/pg_prewarm/pg_prewarm--1.0--1.1.sql */
+
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
+\echo Use "ALTER EXTENSION pg_prewarm UPDATE TO '1.1'" to load this file. \quit
+
+ALTER FUNCTION pg_prewarm(regclass, text, text, int8, int8) PARALLEL SAFE;
diff --git a/contrib/pg_prewarm/pg_prewarm--1.0.sql b/contrib/pg_prewarm/pg_prewarm--1.1.sql
index 2bec7765c0e..b15089598cb 100644
--- a/contrib/pg_prewarm/pg_prewarm--1.0.sql
+++ b/contrib/pg_prewarm/pg_prewarm--1.1.sql
@@ -1,4 +1,4 @@
-/* contrib/pg_prewarm/pg_prewarm--1.0.sql */
+/* contrib/pg_prewarm/pg_prewarm--1.1.sql */
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION pg_prewarm" to load this file. \quit
@@ -11,4 +11,4 @@ CREATE FUNCTION pg_prewarm(regclass,
last_block int8 default null)
RETURNS int8
AS 'MODULE_PATHNAME', 'pg_prewarm'
-LANGUAGE C;
+LANGUAGE C PARALLEL SAFE;
diff --git a/contrib/pg_prewarm/pg_prewarm.control b/contrib/pg_prewarm/pg_prewarm.control
index 8e5dee50684..cf2fb92bedd 100644
--- a/contrib/pg_prewarm/pg_prewarm.control
+++ b/contrib/pg_prewarm/pg_prewarm.control
@@ -1,5 +1,5 @@
# pg_prewarm extension
comment = 'prewarm relation data'
-default_version = '1.0'
+default_version = '1.1'
module_pathname = '$libdir/pg_prewarm'
relocatable = true