summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSimon Riggs2013-03-18 14:39:17 +0000
committerSimon Riggs2013-03-18 14:39:17 +0000
commite016b72411caa7027f9c980fb2c0560cdab2a129 (patch)
tree8b0f5197a1c69d6cd721b825a219afed63885b6e
parentef04cb745fc3167264f369a2710f237de4db0bf4 (diff)
Add pageinspect--1.0--1.sql for checksum changes
-rw-r--r--contrib/pageinspect/pageinspect--1.0--1.1.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/contrib/pageinspect/pageinspect--1.0--1.1.sql b/contrib/pageinspect/pageinspect--1.0--1.1.sql
new file mode 100644
index 00000000000..5997c580dac
--- /dev/null
+++ b/contrib/pageinspect/pageinspect--1.0--1.1.sql
@@ -0,0 +1,18 @@
+/* contrib/pageinspect/pageinspect--1.0--1.1.sql */
+
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION UPDATE
+\echo Use "ALTER EXTENSION pageinspect UPDATE TO 1.1" to load this file. \quit
+
+DROP FUNCTION page_header(bytea);
+CREATE FUNCTION page_header(IN page bytea,
+ OUT lsn text,
+ OUT checksum smallint,
+ OUT flags smallint,
+ OUT lower smallint,
+ OUT upper smallint,
+ OUT special smallint,
+ OUT pagesize smallint,
+ OUT version smallint,
+ OUT prune_xid xid)
+AS 'MODULE_PATHNAME', 'page_header'
+LANGUAGE C STRICT;