summaryrefslogtreecommitdiff
path: root/contrib/pgrowlocks/pgrowlocks--1.2.sql
diff options
context:
space:
mode:
authorRobert Haas2016-06-09 21:18:20 +0000
committerRobert Haas2016-06-09 21:35:53 +0000
commit9164deea2f4ac90ee5e008ff41fc5ad4423887b2 (patch)
treed2ab09ac911cab96cf586e28b2f5bbcb38676979 /contrib/pgrowlocks/pgrowlocks--1.2.sql
parent6b3586caa810529635a8f77789d88e957b389469 (diff)
Update pgrowlocks extension for parallel query.
The pgrowlocks function provided by this extension is PARALLEL SAFE. Andreas Karlsson
Diffstat (limited to 'contrib/pgrowlocks/pgrowlocks--1.2.sql')
-rw-r--r--contrib/pgrowlocks/pgrowlocks--1.2.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/contrib/pgrowlocks/pgrowlocks--1.2.sql b/contrib/pgrowlocks/pgrowlocks--1.2.sql
new file mode 100644
index 00000000000..58df728c07e
--- /dev/null
+++ b/contrib/pgrowlocks/pgrowlocks--1.2.sql
@@ -0,0 +1,15 @@
+/* contrib/pgrowlocks/pgrowlocks--1.1.sql */
+
+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
+\echo Use "CREATE EXTENSION pgrowlocks" to load this file. \quit
+
+CREATE FUNCTION pgrowlocks(IN relname text,
+ OUT locked_row TID, -- row TID
+ OUT locker XID, -- locking XID
+ OUT multi bool, -- multi XID?
+ OUT xids xid[], -- multi XIDs
+ OUT modes text[], -- multi XID statuses
+ OUT pids INTEGER[]) -- locker's process id
+RETURNS SETOF record
+AS 'MODULE_PATHNAME', 'pgrowlocks'
+LANGUAGE C STRICT PARALLEL SAFE;